public override void PopulateFields(Entity entity)
{
DS.SchemaReader.FieldDefinitionsDataTable dt = new CodeGenerator.BL.DBReader.DS.SchemaReader.FieldDefinitionsDataTable();
DS.SchemaReaderTableAdapters.FieldDefinitionsTableAdapter adp = new CodeGenerator.BL.DBReader.DS.SchemaReaderTableAdapters.FieldDefinitionsTableAdapter();
adp.Connection = new System.Data.SqlClient.SqlConnection(base.ConnectionString);
adp.FillByTableName(dt, entity.DBName);
foreach (DS.SchemaReader.FieldDefinitionsRow row in dt)
{
Field f;
f = entity.Fields.Find(delegate(Field ff) { return ff.DBName == row.column_name; });
if (f == null)
{
f = new Field();
entity.Fields.Add(f);
}
f.DBName = row.column_name;
f.LogicalName = row.column_name;
f.DBType = row.Data_type;
f.ID = row.object_id.ToString();
SqlFieldTypeMapper fieldType = new SqlFieldTypeMapper();
fieldType.TypeName = row.Data_type;
// f.LogicalType = CodeGenerator.GetCodeType(fieldType);
f.LogicalType = fieldType.MapDBtoLogical();
f.Nullable = Convert.ToBoolean(row.is_nullable.ToLower() == "no"? false:true);
}
}
public FieldEditor(CodeGenerator.BL.Modeler.Field field)
{
InitializeComponent();
this.Field = field;
LoadForm();
}
protected override void PopulateConstraintFields(Constraint con)
{
DS.SchemaReader.CONSTRAINT_COLUMN_USAGEDataTable dt = new CodeGenerator.BL.DBReader.DS.SchemaReader.CONSTRAINT_COLUMN_USAGEDataTable();
DS.SchemaReaderTableAdapters.CONSTRAINT_COLUMN_USAGETableAdapter adp = new CodeGenerator.BL.DBReader.DS.SchemaReaderTableAdapters.CONSTRAINT_COLUMN_USAGETableAdapter();
adp.Connection = new System.Data.SqlClient.SqlConnection(base.ConnectionString);
adp.FillByConstraintName(dt, con.Name);
foreach (DS.SchemaReader.CONSTRAINT_COLUMN_USAGERow row in dt)
{
Field f;
f = con.Entity.Fields.Find(delegate(Field ff) { return ff.DBName == row.COLUMN_NAME; });
if (f == null)
{
f = new Field();
}
f.DBName = row.COLUMN_NAME;
f.LogicalName = row.COLUMN_NAME;
FieldReference fr = new FieldReference();
fr.RelatedField = f;
fr.ID = f.ID;
fr.Name = f.LogicalName;
con.Fields.Add(fr);
}
}