PDA

View Full Version : خطا Unable to create a constant value of type 'Anonymous type'. Only primitive types ('such as Int32



spicirmkh
شنبه 27 خرداد 1391, 18:55 عصر
در برنامه زیر در 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();
}
}

hamid_kha
چهارشنبه 07 تیر 1391, 17:55 عصر
مقادیر برگشتی از join رو توی یه متغیر var بریز
ببین پیغام میده؟!