private void InitColumns(IDataBaseSchema meta)
{
foreach (DataRow row in meta.GetColumns(catalog, schema, name, null).Rows)
{
AddColumn(row);
}
}
/// <summary>
/// Inicializa as colunas da instancia.
/// </summary>
/// <param name="meta"></param>
private void InitColumns(IDataBaseSchema meta)
{
foreach (System.Data.DataRow row in meta.GetColumns(_catalog, _schema, _name, null).Rows)
{
AddColumn(row);
}
}
public void InquireSchema()
{
Dialect.MsSql2005Dialect dialect = new MsSql2005Dialect();
DbConnection conn = new SqlConnection(@"");
conn.Open();
DatabaseMetadata meta = new DatabaseMetadata(conn, dialect);
IDataBaseSchema schema = dialect.GetDataBaseSchema(conn);
var dt = schema.GetTables(null, null, null, new string[0]);
var cols = schema.GetColumns(null, null, null, null);
var keys = schema.GetForeignKeys(null, null, null);
foreach (DataRow r in dt.Rows)
{
var tableMeta = schema.GetTableMetadata(r, true);
Console.WriteLine(string.Format("Table {2}:[{0}].[{1}]", tableMeta.Schema, tableMeta.Name, tableMeta.Catalog));
ITableMetadata tm = meta.GetTableMetadata(tableMeta.Name, tableMeta.Schema, tableMeta.Catalog, false);
IColumnMetadata col = tm.GetColumnMetadata(cols.Rows[0].ItemArray[2] as string);
}
}
private void InitColumns(IDataBaseSchema meta)
{
foreach (DataRow row in meta.GetColumns(catalog, schema, name, null).Rows)
{
AddColumn(row);
}
}
