Asp.net Simple Layer 3 + Sqllite add, delete, modify, and query, asp. netsqllite
Right-click the solution name, and create a DAL, BLL, and Model class library. As a result, when creating each class library, you may choose to right-click the class library attribute, and change factoryModel to "factory" in the default namespace. model.
If not changed
Create a Windows form application (UI Layer)
Add reference: Because the SQLite database is used, you must manually add a reference file named SQLite dll. In the solution, create a new lib folder and add the SQLite dll file to the DAL reference Model, and SQLite. dll and BLL reference DAL, Model and Model UI reference DAL and Model
Ado.net SqlliteHelper. cs under DAL
App. config configuration file
The SQLite database file is placed in the bin à debug directory of the UI.
Finally, the parameter is
Complete Image
This is the first time I wrote a blog, mainly focusing on records. If you have any other mistakes, I hope you can give me some advice.
Source code download
SQLite third-party editing tool (sqlitestudio)
