Shulou(Shulou.com)05/31 Report--

This article will explain in detail about the advantages of operating SQLite database in .net. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Summary:

The library installation for SQLite is special:

Download address: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki-ok!

Https://www.sqlite.org/download.html . -for downloading Android, Mac, Linux and other platforms.

Download the installation package:

Sqlite-netFx20-setup-bundle-x64-2005-1.0.108.0.exe-Test ok!

Or sqlite-netFx45-setup-bundle-x64-2012-1.0.108.0.exe needs to be uninstalled before installing. -Test ok!

(in order to be consistent with other software, it is recommended to install version 4.5 of .net!)

Default installation path: C:\ Program Files\ System.Data.SQLite

.net reference: just reference the installation bin directory and System.Data.SQLite.dll a file!

Note:

1. The presentation dynamic library with bundle is compiled in mixed mode, and there are three libraries in pure x86 and pure x64 mode, which are selected according to the actual needs. (it has to be consistent with the project's build-target platform! )

2. Download the library, be sure to install it! (only referenced, not installed, run will report an error! )

3. Net uses SQLite. You only need to reference System.Data.SQLite.dll, not sqlite3.dll at all. What a surprise!

SQLite introduction:

SQLite is a lightweight database for local data storage. Open source database.

Advantages, it takes up very low resources, in embedded devices need hundreds of kilograms of memory is enough; as a lightweight database, its processing speed is fast enough; support for the capacity level of T-level; independent: no additional dependence; open source; support for multiple languages.

Detailed benefits:

1. Its design goal is embedded, it occupies very low resources, in embedded devices, only a few hundred kilograms of memory may be enough.

2. Cross-platform and multilingual support: it can support mainstream operating systems such as Windows/Linux/Unix, and can be combined with many programming languages.

For example, C, Clippers, PHP, Perl, Java, Clippers, Python, Ruby and so on.

3. High speed: compared with Mysql and PostgreSQL, which are two world-famous open source database management systems, its processing speed is faster than them.

It is faster than some popular databases in most ordinary databases. )

4. Database size up to 2TB is supported.

5. Small enough, approximately 130000 lines of C code, 4.43m

6. Simple and easy API

The source code is completely open source, and you can use it for any purpose, including selling it.

8. It also supports transaction processing and so on.

Use .NET to manipulate SQLLITE:

Sample code 1:

Public string Query () {string datasource = "e:/tmp/test.db"; System.Data.SQLite.SQLiteConnection.CreateFile (datasource); / / connect to the database System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection (); System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder (); connstr.DataSource = datasource Connstr.Password = "admin"; / / set password, SQLite ADO.NET implements database password protection conn.ConnectionString = connstr.ToString (); conn.Open (); / / create table System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand (); string sql = "CREATE TABLE test (username varchar (20), password varchar (20)" Cmd.CommandText = sql; cmd.Connection = conn; cmd.ExecuteNonQuery (); / / insert data sql = "INSERT INTO test VALUES"; cmd.CommandText = sql; cmd.ExecuteNonQuery (); / / take out data sql = "SELECT * FROM test" Cmd.CommandText = sql; System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader (); StringBuilder sb = new StringBuilder (); while (reader.Read ()) {sb.Append ("username:") .append (reader.GetString (0)). Append ("\ n") .append ("password:") .append (reader.GetString (1)) } / / MessageBox.Show (sb.ToString ()); return sb.ToString ();}

Sample code 2: transaction operation:

Using (SQLiteConnection conn = new SQLiteConnection (connectionString)) {conn.Open (); SQLiteCommand cmd = new SQLiteCommand (); cmd.Connection = conn; SQLiteTransaction tx = conn.BeginTransaction (); cmd.Transaction = tx; try {for (int n = 0; n)

1) {cmd.CommandText = strsql; cmd.ExecuteNonQuery ();}} tx.Commit () } catch (System.Data.SQLite.SQLiteException E) {tx.Rollback (); throw new Exception (E.Message) } this is the end of the article on "what are the advantages of operating SQLite database in .net". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.