Methods to use Sqlite database

In actual use, when I use SqliteAdmin and SQLite Expert Professional 2 software to create a new Sqlite database, it cannot be used in it, and I always report an error: the file is not a legal database. Later, one method was used, which was to directly use the referenced DLL to create a new database and then use it.

string datasource = "d:\\"; //The address of the database file

(datasource); //Create a file

In this way, the generated table can be used. At this time, even if you use SqliteAdmin and SQLite Expert Professional 2 software to open it and create tables in it, it will not affect its use.

The operation of Sqlite is actually very similar to Access, except that the ones at the beginning of OleDB have become SQLite...

.NET Framework Data Provider for ODBC

DRIVER=SQLite3 ODBC Driver; Database=; LongNames=0; Timeout=1000; NoTXN=0;SyncPragma=NORMAL; StepAPI=0;
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

SQLite3 ODBC Driver

DRIVER=SQLite3 ODBC Driver; Database=; LongNames=0; Timeout=1000; NoTXN=0;SyncPragma=NORMAL; StepAPI=0;