读书人

Lint to Sql 查询包含对不同数据上下文

发布时间: 2012-02-02 23:57:14 作者: rapoo

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();} 

读书人网 >.NET

热点推荐