private DBInfo.Core.Statement.CreateTable ParseCreateTableStatement(CreateTable ct)
{
DBInfo.Core.Model.Table t = new DBInfo.Core.Model.Table();
t.TableName = ct.TableName;
t.HasIdentity = ct.HasIdentity == YesNo.Yes;
t.IdentitySeed = Convert.ToInt32(ct.IdentitySeed);
t.IdentityIncrement = Convert.ToInt32(ct.IdentityIncrement);
if (ct.Columns != null)
{
foreach (Column ctc in ct.Columns)
{
DBInfo.Core.Model.Column c = new DBInfo.Core.Model.Column();
c.Name = ctc.Name;
c.Type = GetDBColumnType(ctc.Type);
c.Size = Convert.ToInt32(ctc.Size);
c.Precision = Convert.ToInt32(ctc.Precision);
c.Scale = Convert.ToInt32(ctc.Scale);
c.IsNull = ctc.Nullable == YesNo.Yes;
c.IdentityColumn = ctc.IdentityColumn == YesNo.Yes;
c.DefaultValue = ctc.DefaultValue;
c.ConstraintDefaultName = ctc.ConstraintDefaultName;
t.Columns.Add(c);
}
}
DBInfo.Core.Statement.CreateTable createTable = new DBInfo.Core.Statement.CreateTable();
createTable.Table = t;
return(createTable);
}
private DBInfo.Core.Statement.CreatePrimaryKey ParseCreatePrimaryKeyStatement(CreatePrimaryKey xmlPrimaryKey)
{
DBInfo.Core.Model.Table t = new DBInfo.Core.Model.Table();
t.TableName = xmlPrimaryKey.TableName;
t.PrimaryKeyName = xmlPrimaryKey.PrimaryKeyName;
foreach (string c in xmlPrimaryKey.Columns)
{
t.PrimaryKeyColumns.Add(c);
}
DBInfo.Core.Statement.CreatePrimaryKey cpk = new DBInfo.Core.Statement.CreatePrimaryKey();
cpk.Table = t;
return(cpk);
}
