public InformationSchemaColumnBase(DBStructure.INFORMATION_SCHEMA_COLUMNSRow dr)
{
_ColumnName = dr[ISColumnName].ToString();
string tempType = dr[ISColumnDataType].ToString();
LoadTypeInformation(tempType);
_Order = Convert.ToInt32(dr[ISColumnOrder]);
if (dr.Table.Columns.Contains(ISColumnCharLength) && !dr.IsNull(ISColumnCharLength))
{
_ColumnLength = Convert.ToInt64(dr[ISColumnCharLength]);
}
else if (dr.Table.Columns.Contains(ISColumnNumLength) && !dr.IsNull(ISColumnNumLength))
{
_ColumnLength = Convert.ToInt64(dr[ISColumnNumLength]);
if (!dr.IsNull(ISColumnNumScale))
{
_ColumnScale = Convert.ToInt32(dr[ISColumnNumScale]);
}
}
else if (dr.Table.Columns.Contains(ISColumnDateLength) && !dr.IsNull(ISColumnDateLength))
{
_ColumnLength = Convert.ToInt64(dr[ISColumnDateLength]);
}
_IsPrimaryKey = GetBoolean(dr, "IS_PRIMARY_KEY");
_IsIdentity = GetBoolean(dr, "IS_IDENTITY");
_IsNullable = GetBoolean(dr, "IS_NULLABLE");
}
protected internal void LoadColumnInfo(DBStructure.INFORMATION_SCHEMA_COLUMNSDataTable table)
{
var rows = new DBStructure.INFORMATION_SCHEMA_COLUMNSRow[table.Rows.Count];
table.Rows.CopyTo(rows, 0);
LoadColumnInfo(rows);
}
public SqlColumnInfo(DBStructure.INFORMATION_SCHEMA_COLUMNSRow dr)
: base(dr)
{
}
protected abstract IColumnInfo CreateColumn(DBStructure.INFORMATION_SCHEMA_COLUMNSRow dr);
protected override IColumnInfo CreateColumn(DBStructure.INFORMATION_SCHEMA_COLUMNSRow dr)
{
return(new SqlColumnInfo(dr));
}
