public List <Table> GetTableList()
{
using (MyDatabaseDocContext context = new MyDatabaseDocContext())
{
var query = context.Database.SqlQuery <Table>(getTableSql);
return(query.ToList());
}
}
public List <Column> GetColumnList(string tableName)
{
string sql = String.Format(getColumnSql, tableName);
using (MyDatabaseDocContext context = new MyDatabaseDocContext())
{
var query = context.Database.SqlQuery <Column>(sql);
return(query.ToList());
}
}
public List <Table> GetTableList()
{
using (MyDatabaseDocContext context = new MyDatabaseDocContext())
{
var query =
from data in context.Tables
select data;
var resultList = query.ToList();
return(resultList);
}
}
public Table GetTable(string tableName)
{
using (MyDatabaseDocContext context = new MyDatabaseDocContext())
{
var query =
from data in context.Tables.Include("ColumnList")
where
data.TableName == tableName
select data;
var result = query.FirstOrDefault();
return(result);
}
}
public List <Column> GetColumnList(string tableName)
{
using (MyDatabaseDocContext context = new MyDatabaseDocContext())
{
var query =
from data in context.Columns
where
data.TableName == tableName
orderby
data.ColumnIndex
select data;
var resultList = query.ToList();
return(resultList);
}
}
static void Main(string[] args)
{
// 当 Code First 与数据库结构不一致时
// 自动升级到最新的版本.
Database.SetInitializer(new MigrateDatabaseToLatestVersion <MyDatabaseDocContext, MyDatabaseDoc.Migrations.Configuration>());
using (MyDatabaseDocContext context = new MyDatabaseDocContext())
{
var query =
from data in context.Tables
select data;
foreach (var item in query)
{
Console.WriteLine(item.TableName);
}
}
Console.WriteLine("Finish!");
Console.ReadLine();
}
