EF 通用查询类
/// <summary>泛型查询数据表方法
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="tableName"></param>
/// <returns></returns>返回查到list
private object tbList<T>(string tableName)
{
using (dbModel mod = new dbModel())
{
string sql = "select * from [dbo].[" + tableName + "]";
var tableList = mod.Database.SqlQuery<T>(sql).ToList();
return tableList;
}
}
/// <summary>调用
///
/// </summary>
private void getTableList()
{
string tableName = "USER";//定义表名
var lists = tbList<USER>(tableName);//调用的时候传数据类型
}
浙公网安备 33010602011771号