When there is a blob field in a Version 3 db,
the SchemaTable-Info isn't correct, resulting
in not being able to use DataAdapter/CommandBuilder
for Updateing the DB.
I have changed SQLiteDataReader.EnhanceSchemaTable
the following way.
row["IsAutoIncrement"] = primaryKey && string.Compare
(type,"INTEGER",true) == 0;
if (type.ToLower() == "blob")
row["ProviderType"] = Convert.ToInt32(DbType.Binary);
Otherwise keep up the good work ;-)
Log in to post a comment.