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
Command Builder for updating SQLite Database
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Command Builder for updating SQLite Database
dotConnect Universal has UniCommandBuilder class which allows you to use UniDataAdapter.Update to update a single table without writing custom update and insert statements.
dotConnect Universal is a provider that offers universal interface for other providers. If it has such a class, this class can be used with any internal provider including SQLite.
For more information, please refer to http://www.devart.com/dotconnect/univer ... ilder.html
dotConnect Universal is a provider that offers universal interface for other providers. If it has such a class, this class can be used with any internal provider including SQLite.
For more information, please refer to http://www.devart.com/dotconnect/univer ... ilder.html
Re: Command Builder for updating SQLite Database
Dear Pinturiccio,
Great Software, I will create a project and write some codes on DataAdapter to learn.
Thank you
Richard
Great Software, I will create a project and write some codes on DataAdapter to learn.
Thank you
Richard