Lint to Sql 查询包含对不同数据上下文上所定义项的引用,该如何处理

Lint to Sql 查询包含对不同数据上下文上所定义项的引用

C# code

private CustomerDataContext dc = new CustomerDataContext();private SysDataContext ds = new SysDataContext();public IEnumerable<MiddleSellerOrg> SelectSellerOrgBySellerID(string SellerID)        {var q = from a in dc.Cust_SellerOrgs                    join b in ds.Sys_Organizations on a.OrgID equals b.OrgID                    where a.SellerID == SellerID                    select new MiddleSellerOrg {                     ..........                    };return q.ToList();}

dc.Cust_SellerOrgs 和ds.Sys_Organizations 是多对多的关系

怎么改，网上找了很多，但不知道怎么改

[解决办法]
不支持多个DataContext的连接！若有疑问！请QQ（252377274）帮你解决
[解决办法]
转化成Linq2Object查询：

C# code

private CustomerDataContext dc = new CustomerDataContext();private SysDataContext ds = new SysDataContext();public IEnumerable<MiddleSellerOrg> SelectSellerOrgBySellerID(string SellerID)        {var q = from a in dc.Cust_SellerOrgs.ToList()                    join b in ds.Sys_Organizations.ToList()                    on a.OrgID equals b.OrgID                    where a.SellerID == SellerID                    select new MiddleSellerOrg {                     ..........                    };return q.ToList();} 

 

查看更多 下一篇