学步园

安装

.net v3.5

SQLiteConnection cn = new SQLiteConnection( 
    "Data Source=test.db;Pooling=true;FailIfMissing=false") 

pooling default value is true
FailIfMissing default value is false

CREATE TABLE test (id integer primary key, text varchar(10))
id will be auto increment

ref link:

http://roach0426.pixnet.net/blog/post/965051-%E7%94%A8c%23%E4%BE%86%E8%AE%80%E6%94%9C%E5%B8%B6%E5%9E%8B%E8%B3%87%E6%96%99%E5%BA%ABsqlite

dbhelper

http://www.cnblogs.com/ike_li/archive/2010/11/01/1866288.html

http://www.koders.com/csharp/fid40FA882F87466F7C8A97C27DE80236DF265BD345.aspx?s=dataset#L81

http://www.oschina.net/code/snippet_4946_3201