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