public void CreateTable() { if (mDbMgr.TableExists(mTablename)) { return; } DbGenerateTableStatement clause = mDbMgr.CreateGenerateTableClause(); clause .CreateTable(mTablename) .WithPrimaryKey(mPrimaryKey); foreach (string fieldname in mFields.Keys) { clause.WithField(fieldname, mFields[fieldname]); } foreach (string fieldname in mForeignKeys.Keys) { clause.WithReference(fieldname, mForeignKeys[fieldname]); } mDbMgr.ExecuteNonQuery(clause); }
public void RecreateTable() { if (mDbMgr.TableExists(mTablename)) { mDbMgr.ExecuteNonQuery(mDbMgr.CreateDropTable().DropTable(mTablename)); } DbGenerateTableStatement clause = BuildClause(); mDbMgr.ExecuteNonQuery(clause); }
protected virtual DbGenerateTableStatement BuildClause() { DbGenerateTableStatement clause = mDbMgr.CreateGenerateTableClause(); clause .CreateTable(mTablename) .WithPrimaryKey(mPrimaryKey); foreach (string fieldname in mFields.Keys) { clause.WithField(fieldname, mFields[fieldname]); } foreach (string fieldname in mForeignKeys.Keys) { clause.WithReference(fieldname, mForeignKeys[fieldname]); } return(clause); }
public override string ToString() { DbGenerateTableStatement clause = BuildClause(); return(string.Format("TableCmd: {0}", clause.ToString())); }