public CreateTableStatement(Table table)
{
Table = table;
Columns = new List<Field>(table.Fields.Values);
Constraints = new List<Evaluant.NLinq.Expressions.Expression>();
var primaryKey = new AlterTableAddStatement() { ConstraintName = "PK_" + table.TableName, Table = table, Constraint = new PrimaryKeyConstraint() };
foreach (Field f in Columns)
{
if (!string.IsNullOrEmpty(f.DefaultValue))
{
Constraints.Add(new AlterTableAddStatement() { Table = table, ColumnName = f.ColumnName.Text, Constraint = new DefaultConstraint() { Field = f, DefaultValue = true }, ConstraintName = "DF_" + Table.TableName + '_' + f.ColumnName.Text });
}
if (f.IsPrimaryKey)
((PrimaryKeyConstraint)primaryKey.Constraint).Fields.Add(f);
}
if (((PrimaryKeyConstraint)primaryKey.Constraint).Fields.Count > 0)
Constraints.Add(primaryKey);
}
public LazyTableAlias(Table table)
{
TargetTable = table;
}
public Field Clone(Table table)
{
Field clone = Clone();
clone.Table = table;
return clone;
}
public Field Clone(Table table, string fieldName)
{
Field clone = Clone(table);
clone.ColumnName = new Evaluant.NLinq.Expressions.Identifier(fieldName);
return clone;
}
public Field(Table table, string columnName, bool isPrimaryKey) : this(columnName, isPrimaryKey) { Table = table; }
