指定的 LINQ 表达式包孕对与不同上下文关联的查询的引用

2013-06-25

指定的 LINQ 表达式包含对与不同上下文关联的查询的引用先贴代码var pb from d in pr.Purchases join b

指定的 LINQ 表达式包含对与不同上下文关联的查询的引用
先贴代码

var pb = from d in pr.Purchases join b in br.Books
                                           on d.bookID equals b.bookID
                                           where d.pUserID == userID && d.sta != "2"
                                           orderby d.pTime descending
                                           select new PurchaseBook {
                                               pID = d.pID,
                                               bookID = d.bookID,
                                               bookName = d.bookName,
                                               pUserID = d.pUserID,
                                               pUserName = d.pUserName,
                                               sta = d.sta,
                                               pTime = d.pTime,
                                               ZT = d.ZT,
                                               sUserID = d.sUserID,

                                               sUserName = d.sUserName,
                                               price = d.price,
                                               number = d.number,
                                               author = b.author,
                                               pub=b.pub
                                           };

br.Books和pr.Purchases是同一个数据库中的两张表，分别放到了两个类中，连接数据的时候是分别建立连接
运行的时候报了如标题所示的错误，改如何改写代码呢
LINQ 数据库
[解决办法]
http://www.cnblogs.com/Joetao/articles/2106426.html
[解决办法]
Try:

var books=br.Books.ToList();
var pb = from d in pr.Purchases join b in books
                                           on d.bookID equals b.bookID
                                           where d.pUserID == userID && d.sta != "2"
                                           orderby d.pTime descending
                                           select new PurchaseBook {

                                               pID = d.pID,
                                               bookID = d.bookID,
                                               bookName = d.bookName,
                                               pUserID = d.pUserID,
                                               pUserName = d.pUserName,
                                               sta = d.sta,
                                               pTime = d.pTime,
                                               ZT = d.ZT,
                                               sUserID = d.sUserID,
                                               sUserName = d.sUserName,
                                               price = d.price,
                                               number = d.number,
                                               author = b.author,

pub=b.pub
};

[解决办法]
http://stackoverflow.com/questions/7332920/the-specified-linq-expression-contains-references-to-queries-that-are-associated

热点排行

.NET

指定的 LINQ 表达式包孕对与不同上下文关联的查询的引用