Geek asks and answers

SQlite String Connection Format

I have 2 parts of the question here

1) I downloaded SQLite from here: SQLite site and for .NET 4.5 there was a version with mixed mode and "mixed mode". How do I know which one should I use?

When creating a connection, I use the following command:

sqlite_conn = new SQLiteConnection ("Data Source = db.db; Version = 3; New = True; Compress = True;");

2) "Version = 3", I assume, is the used version of SQLite. Therefore, if I boot from a link above the version, says System.Data.SQLite 1.0.84.0 (3.7.15.2), so I should change version = 3 to version = 3.7.15.2 ??

+5
source share
3 answers
  • You must select Mixed.

  • 1.0.84.0 - SQLite DLL. SQLite c#, :

    sqlite_conn = new SQLiteConnection("Data Source=C:\SQLITEDATABASES\SQLITEDB1.sqlite;Version=3;");

SQLite 3, DLL - , SQLite 3.

+12

SQLite ++. Windows 32- (x86).dll. .NET , , .NET- . COM Interop, .

, System.Data.SQLite. , SQLite. ++ SQLite .NET - ++ .NET(hooray, - ).

(++ SQLite), .NET- (-) , ​​ , . SQLite , .

64- Windows, . , , ( , ). 1.0.80.0 System.Data.SQLite, : 1.) .NET.dll System.Data.SQLite.dll, 32- 64- ) 2.) 32- .dll x86\SQLite.Interop.dll 3. 64- .dll x64\SQLite.Interop.dll

.NET( 1) , , 32- 64- .dll.

System.Data.SQLite, , , .

, , SQLite System.Data.SQLite.

+1

Sqlite Connection String Types Listed Below

The main

Data Source=c:\mydb.db;Version=3;

Version 2 is not supported by this class library.

Database with memory The SQLite database is usually stored on disk, but the database can also be stored in memory.

Data Source=:memory:;Version=3;New=True;

Using UTF16

Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;

With password

Data Source=c:\mydb.db;Version=3;Password=myPassword;

+1
source

More articles:


All Articles