Command Builder for updating SQLite Database
Posted: Thu 05 Mar 2015 16:53
Dear Sir/Madam,
I decided to use dotConnect Universal Professional as this version is shipped with several ADO providers such as dotConnect for Oracle and SQLite.
I have created a SQLite database to maintain the Quotation table in a disk folder. I want to write codes in c# as simple and automatic as possible and can use DbDataAdapter.Update method to post the changes from a DataTable to SQLite3 table.
I read through the online document on www.devart.com. May I ask if dotConnect Universal Professional support the Command Builder like working for SQLServer
"SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter)"
If the Command Builder of Universal can be worked for SQLite database, I can use DbDataAdapter.Update to update a single table without writing custom update and insert statements.
Million of thanks!
Richard
I decided to use dotConnect Universal Professional as this version is shipped with several ADO providers such as dotConnect for Oracle and SQLite.
I have created a SQLite database to maintain the Quotation table in a disk folder. I want to write codes in c# as simple and automatic as possible and can use DbDataAdapter.Update method to post the changes from a DataTable to SQLite3 table.
I read through the online document on www.devart.com. May I ask if dotConnect Universal Professional support the Command Builder like working for SQLServer
"SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter)"
If the Command Builder of Universal can be worked for SQLite database, I can use DbDataAdapter.Update to update a single table without writing custom update and insert statements.
Million of thanks!
Richard