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()));
}