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