According to MSDN, calling RefreshSchema is supposed to remove all (dispose) all DbCommand objects associated with the builder. If the SQL Server provider is doing something else it is not following the specification.
http://msdn.microsoft.com/en-us/library/system.data.common.dbcommandbuilder. refreshschema.aspx In your example you use: SQLiteCommand cmd1 = builder.GetInsertCommand(); And then you call: builder.RefreshSchema(); Which disposes of the command you previously grabbed. This is by design, per the MSDN specification. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
