/// <summary>
/// 取得 DB 的 Schema 定義 (Schema=Database)
/// </summary>
/// <returns></returns>
public IEnumerable<SchemaField> GetInitialCatalogData()
{
try
{
DAL dal = new DAL();
var result = from schema in dal.GetSchemaDataTable("Databases").AsEnumerable()
select new SchemaField
{
SCHEMA_Field01 = schema["dbid"].ToString(),
SCHEMA_Field02 = (string)schema["database_name"]
};
return result.OrderBy(c => c.SCHEMA_Field02);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 取得 DB 的 Schema 定義 (Schema=Tables)
/// </summary>
/// <returns></returns>
public IEnumerable<SchemaField> GetTableData()
{
try
{
DAL dal = new DAL();
var result = from schema in dal.GetSchemaDataTable("Tables").AsEnumerable()
where (string)schema["TABLE_TYPE"] == "BASE TABLE" //先只找出 Table 類型的 Schema
select new SchemaField
{
SCHEMA_Field01 = (string)schema["TABLE_CATALOG"],
SCHEMA_Field02 = (string)schema["TABLE_SCHEMA"],
SCHEMA_Field03 = (string)schema["TABLE_NAME"],
SCHEMA_Field04 = (string)schema["TABLE_TYPE"]
};
return result.OrderBy(c => c.SCHEMA_Field03);
}
catch (Exception ex)
{
throw ex;
}
}
