Re: [sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder

2012-02-20 Thread ITS Smoynihan
e: [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 > T

Re: [sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder

2012-02-19 Thread Joe Mistachkin
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 DbComm

Re: [sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder

2012-02-19 Thread Joe Mistachkin
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. r

[sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder

2012-02-19 Thread ITS Smoynihan
Bug : RefreshSchema sets SQLiteCommandBuilder command texts to NULL Effect : SQLiteCommandBuilder builds the complex command texts , if u need to append second qry , it fails when the tableAdapter Update is called later. Hi guys , sent this also last w