public void CreateEasyJobTable(EntityDB.IDatabaseService db) { bool exists = true; try { db.ExecSqlString("select * from __wayeasyjob"); } catch (Exception ex) { exists = false; } if (!exists) { db.ExecSqlString("CREATE TABLE [__wayeasyjob](contentConfig TEXT NOT NULL)"); var dbconfig = new DataBaseConfig(); try { dbconfig.LastUpdatedID = Convert.ToInt32(db.ExecSqlString("select lastID from __EasyJob")); } catch { } db.ExecSqlString("insert into __wayeasyjob (contentConfig) values (@p0)", dbconfig.ToJsonString()); } //try //{ // db.ExecSqlString("CREATE TABLE [] ([lastID] integer NOT NULL)"); // db.ExecSqlString("insert into (lastID) values (0)"); //} //catch //{ //} }
public void CreateEasyJobTable(EntityDB.IDatabaseService db) { bool exists = true; try { db.ExecSqlString("select * from __wayeasyjob"); } catch { exists = false; } if (!exists) { db.ExecSqlString("CREATE TABLE [__wayeasyjob](contentConfig varchar(1000) NOT NULL)"); var dbconfig = new DataBaseConfig(); try { dbconfig.LastUpdatedID = Convert.ToInt32(db.ExecSqlString("select lastID from __EasyJob")); } catch { } db.ExecSqlString("insert into __wayeasyjob (contentConfig) values (@p0)", dbconfig.ToJsonString()); } }