private Model.Field GetField(string connectionString, string tbName, DataRow r) { Model.Field model = new Model.Field(); model.AllowNull = SchemeHelper.GetBool(r["IS_NULLABLE"]); model.DefaultValue = SchemeHelper.GetString(r["COLUMN_DEFAULT"]); model.FieldDescn = SchemeHelper.GetString(r["DESCRIPTION"]); model.FieldLength = SchemeHelper.GetInt(r["CHARACTER_MAXIMUM_LENGTH"]); model.FieldName = SchemeHelper.GetString(r["COLUMN_NAME"]); model.FieldNumber = SchemeHelper.GetInt(r["ORDINAL_POSITION"]); model.FieldSize = SchemeHelper.GetInt(r["CHARACTER_OCTET_LENGTH"]); model.OleDbTypeString = SchemeHelper.GetString(r["DATA_TYPE"]); model.IsIdentifier = SchemeHelper.GetInt(r["COLUMN_FLAGS"]) == 90; DataTable dtPrimanyKey = GetDbSchema(connectionString, OleDbSchemaGuid.Primary_Keys, null); foreach (DataRow rp in dtPrimanyKey.Rows) { if (rp[2].ToString() == tbName && rp[3].ToString() == model.FieldName) { model.IsKeyField = true; } } model.TableName = SchemeHelper.GetString(r["TABLE_NAME"]); return(model); }
private Model.Field GetField(DataRow r) { Model.Field model = new Model.Field(); model.AllowNull = SchemeHelper.GetBool(r["AllowNull"]); model.DefaultValue = SchemeHelper.GetString(r["DefaultValue"]); model.FieldDescn = SchemeHelper.GetString(r["FieldDescn"]); model.FieldLength = SchemeHelper.GetInt(r["FieldLength"]); model.FieldName = SchemeHelper.GetString(r["FieldName"]); model.FieldNumber = SchemeHelper.GetInt(r["FieldNumber"]); model.FieldSize = SchemeHelper.GetInt(r["FieldSize"]); model.SqlTypeString = SchemeHelper.GetString(r["FieldType"]); model.IsIdentifier = SchemeHelper.GetBool(r["IsIdentifier"]); model.IsKeyField = SchemeHelper.GetBool(r["IsKeyField"]); model.TableName = SchemeHelper.GetString(r["TableName"]); return(model); }