ataReader sqLiteDataReader command.ExecuteReader return sqLiteDataReader public static object ExecuteScalarstring cmdText List parameters lock lockObject using SQLiteConnection conn new SQLiteConnectionConnectionString using SQLiteCommand command new SQLiteCommand PrepareCommandcommand conn cmdText parameters return command.ExecuteScalar public static void CreateDataBase if File.ExistsDataBasePath SQLiteConnection.CreateFileDataBasePath CreateTable public static void CreateTable ExecuteNonQueryCodeDetailTabale null private static string CodeDetailTabale get return CREATE TABLE CodeDetail CdType nvarchar 10 NOT NULL CdCode nvarchar 20 NOT NULL CdString1 ntext NOT NULL CdString2 ntext NOT NULL CdString3 ntext NOT NULL PRIMARY KEY CdTypeCdCode 示例讲解 A、使用到自己定义的锁private static object lockObject new object B、使用完连接后都进行关闭操作。

    使用了using C、创建数据库命令SQLiteConnection.CreateFileDataBasePath 最后再讲解个Insert or Replace into的经典用法 Insert or Replace INTO UserID NameAge Select old.IDnew.Namenew.Age From select Spring Yang as Name 25 as Age as new left join Select IDName from User where Name Spring Yang as old on old.Name new.Name