[Mono-dev] Support for blobs in SQLite

pablosantosluac at terra.es pablosantosluac at terra.es
Mon Jan 23 08:16:27 EST 2006


As far as I know there is no way to insert blobs using the SQLite provider 
included in mono. I've checked the latests sources and I can't find the code 
handling this kind of paramenter.

I tried to recompile Mono.Data.SqliteClient.dll adding the following to 
SqliteCommand.cs in BindParameters3:

else if (ptype.Equals (typeof( System.Byte[])))


  err = Sqlite.sqlite3_bind_blob(pStmt, i, (System.Byte[]) param.Value, 
((byte[])param.Value).Length,   System.IntPtr.Zero);


With this change is possible to read and write blobs...

Can somebody add these 4 lines in the next release???



More information about the Mono-devel-list mailing list