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