Can't enumerate LinQ results with left join
Posted
by nvtthang
on Stack Overflow
See other posts from Stack Overflow
or by nvtthang
Published on 2010-05-20T02:32:59Z
Indexed on
2010/05/20
2:40 UTC
Read the original article
Hit count: 302
linq-to-entities
|LINQ
var itemSet = from item in da.GetList<Models.account>()
join file in objFileStorageList
on item.account_id equals file.parent_id into objFile
from fileItem in objFile.DefaultIfEmpty()
where item.company != null && item.company.company_id == 123
orderby item.updatedDate descending
select
new
{
Id = item.account_id,
RefNo = item.refNo,
StartDate = item.StartDate ,
EndDate = item.EndDate ,
Comment = item.comment,
FileStorageID = fileItem != null ? fileItem.fileStorage_id : -1,
Identification = fileItem != null ? fileItem.identifier : null,
fileName = fileItem != null ? fileItem.file_nm : null
};
It raises error message when I try to enumerate through collection result from Linq query above.
LINQ to Entities does not recognize the method 'System.Collections.Generic.IEnumerable
1[SCEFramework.Models.fileStorage] DefaultIfEmpty[fileStorage](System.Collections.Generic.IEnumerable
1[SCEFramework.Models.fileStorage])' method, and this method cannot be translated into a store expression
foreach (var item in itemSet)
{
string itemRef= item.RefNo;
}
Please suggest me any solutions. Thanks in advance.
© Stack Overflow or respective owner