Joe Here is an MS link that describes using/manipulating the command texts , but I had misinterpreted the instructions .
http://msdn.microsoft.com/en-us/library/tf579hcz.aspx so , you are correct , no bug , but the behaviour with SqlCommandBuilder is a bit different which does not null the InsertCommand text ( maybe it should) many thanks for prompt responses -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: 20 February 2012 04:30 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder ITS Smoynihan wrote: > > The MS note in > http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuil > der.aspx would not make sense otherwise, if it is going to null out the > texts > That page of documentation is specific to the provider for SQL Server. None of the DbCommandBuilder derived classes appear, at least publically, to store any text to be used for later reconstructing the commands disposed by the RefreshSchema method. The RefreshSchema method is implemented by the DbCommandBuilder class itself (part of the .NET Framework), not System.Data.SQLite and the DbCommandBuilder class does not null out any texts because there are none stored to null out. What problem you are reporting here? Where does any documentation on the DbCommandBuilder class or the SQLiteCommandBuilder class directly mention storing command text (via the public interface)? -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
