linq数据库连接问题
public class DGService : IDGService
{
public List<user> GetUsers()
{
SampleDCDataContext dc = new SampleDCDataContext();
var query = from p in dc.users
select p;
return query.ToList<user>();
}
}
标下划线的部分是数据表名,运行时显示错误:
“SampleDCDataContext”不包含“users”的定义,并且找不到可接受类型为“SampleDCDataContext”的第一个参数的扩展方法“users”(是否缺少 using 指令或程序集引用?)
这是什么原因,请大家帮忙给看一下
[解决办法]
- C# code
public UsersDataContext() : base(ConfigurationManager.ConnectionStrings["DBNameConnectionString"].ConnectionString, mappingSource) { OnCreated(); }
[解决办法]
- C# code
public class DGService : IDGService{ public List <user> GetUsers() { SampleDCDataContext dc = new SampleDCDataContext(); var query = from p in dc.users select new user{ id = p.Id....}; return query.ToList(); }}