در برنامه زیر در query دوم پیغام خطا یعنی در خط join dbDown in querydowanload on dbEj.PaperID equals (int)dbDown.PaperID
Unable to create a constant value of type 'Anonymous type'. Only primitive types ('such as Int32, String, and Guid') are supported in this context
می دهد چرا ؟
using (var dbContext = new UserSpicEntities())
{
var querydowanload = (from db in dbContext.tblDownload
where (db.BankID == 5 && db.Downloaded == false)
group db by new {db.BankID, db.Downloaded, db.DocID}
into grp
select new {EjournalCount = grp.Count(), PaperID = grp.Key.DocID,}
).ToList();
using (var dbContextEj = new EJournalSpicEntities())
{
e.Result = (from dbEj in dbContextEj.tblEjournalA
join dbDown in querydowanload on dbEj.PaperID equals (int)dbDown.PaperID
orderby dbDown.EjournalCount descending
select
new
{
con = dbDown.EjournalCount,
PubTitle = dbEj.tblEjournalT.Title,
}
).ToList();
}
}
پاسخ با نقل قول
