1、通过Add References引用SQLite ADO .NET安装目录的bin目录下的System.Data.SQLite.DLL。
2、创建数据库文件:因为始终是个0字节文件,应该利用IO也可以(?!)。
System.Data.SQLite.SQLiteConnection.CreateFile(datasource);
3、连接数据库
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(connectionString);
connectionString中包含了数据库的一些配置信息,比如数据库文件,数据库打开的密码等,可以利用System.Data.SQLite.SQLiteConnectionStringBuilder来辅助创建connectionString
4、创建表、读取数据等和Access或MS SQL没多大区别了。
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/ExpandedBlockStart.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/ContractedBlock.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/InBlock.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/InBlock.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/ExpandedBlockEnd.gif)
![](http://www.csharpwin.com/Admin/fckeditor/editor/plugins/insertcode/images/None.gif)