How to Use Sqlite database in Asp.net

Sqlite is a popular database recently. It is more efficient and fast than Access and is easy to implement. No configuration is required on the client. You only need to reference the DLL file in the site.

In practical use, when I use SqliteAdmin and SQLite Expert Professional 2 to create an Sqlite database, it cannot be used in ASP. NET. The error is always reported: The file is not a legal database. Later, we used a method to create a database using the referenced DLL in ASP. NET.

String datasource = "d :\\ test. db"; // address of the database file

System. Data. SQLite. SQLiteConnection. CreateFile (datasource); // generate a file

In this way, the test. db can be used in asp.net. In this case, you can use SqliteAdmin and SQLite Expert Professional 2 software to open it and create tables in it without affecting its use.

The operations on Sqlite are actually very similar to those on Access, except that all operations starting with OleDB have become SQLite.