public static void Init(string dbFileName,SqliteInitInfo initInfo) { _dbFileName = dbFileName; Connect((c) => { CreateTableIfNotExist(initInfo, c); }); }
private static void CreateTableIfNotExist(SqliteInitInfo initInfo, SQLiteConnection c) { var existCommandText = string.Format("SELECT COUNT(*) FROM sqlite_master where type='table' and name='{0}'", initInfo.TableName); SQLiteCommand cmd = new SQLiteCommand(existCommandText, c); var dataAdapter = new SQLiteDataAdapter(cmd); var ds = new DataSet(); dataAdapter.Fill(ds); if (ds.Tables[0].Rows[0][0].ToString() != "1") { cmd.CommandText = initInfo.CreateSql; var r = cmd.ExecuteNonQuery(); } }
public static void Init(string dbName) { var tableName = "Record"; SqliteInitInfo initInfo = new SqliteInitInfo { TableName = tableName, CreateSql = string.Format( @"create table {0} ( Id varchar(36) not null, Title nvarchar(36) not null , Project nvarchar(100) , Description text, Tag nvarchar(300) , Status int, DealWith text , CreateDate datetime, LastEditDate datetime, PRIMARY KEY('Id'))", tableName) }; SqliteHelper.Init(dbName, initInfo); }