SQLite Typed DataSets Designer forgetting 'Refresh the data table setting'

[ghostrider203]

Hi,

I downloaded System.Data.SQLite 1.0.65.0 at on 3 days ago and dragged and dropped a table from the Server Explorer onto a typed dataset designer.

I then configured the Data adapter query to Refesh the data table in the advanced settings diaglog and the TableAdapter Configuration Wizard and saved. Every time I go back to look at the setting it is unchecked. On top of this when I try to build the build does not finish and I have to kill the Visual Studio 2005 dev environment and reboot my machine.

Any help gratefully recieved.

TC

 

[jmcilhinney]

I think the first thing to do, unless you already know, is make sure that the SQLite provider supports multiple SQL statements in a command. To do that, create a DataAdapter and put the INSERT and SELECT statements in the InsertCommand and see if an exception is thrown.