首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > .NET >

entity语法有关问题求解决

2013-04-20 
entity语法问题求解决string[] numbersID this.HidCIdList.Value.Split()数组的形式是 123[456] 就

entity语法问题求解决
string[] numbersID = this.HidCIdList.Value.Split(';');
数组的形式是 123[456] 就是一个id加上[另一个id]拼起来的作为唯一标示

                  List<string> result = new List<string>(numbersID).ConvertAll(i => i);
            var Query = (from a in adviceNoteEarnestMoneyTableEntities.AssetsInfo
                         join b in adviceNoteEarnestMoneyTableEntities.MgProjectBaseInfo on a.ProjectID equals b.ProjectID
                         join c in adviceNoteEarnestMoneyTableEntities.AssetsType.Where(c=>c.ID==6) on a.AssetsType equals c.ID
                         join d in adviceNoteEarnestMoneyTableEntities.MgProjectCustomers.Where(d=>d.Type==0) on a.ID equals d.AssetsID
                         join f in adviceNoteEarnestMoneyTableEntities.CustomerBaseInfo on d.CustomerID equals f.CustomerID
                         
                         select new
                         {
                             CustomerCode = f.MainDataNO,
                             CustomerID = f.CustomerID,
                             CustomerName=f.Name,
                             ProjectCode = b.Code,
                             ProjectID = a.ProjectID,
                             AssetsID = a.ID,
                             ProjectMainNo = b.MainDataNO,
                             ProjectTitle = b.Title,
                             AssetsType=a.AssetsType,


                             Name = c.Name,
                             Cpid=f.CustomerID+"["+a.ProjectID+"]",
                             DepreciationReserves = ""
                         }).Where(m => result.Contains(m.Cpid)).OrderBy(p => p.ProjectID); 报错 无法将类型“System.Int32”强制转换为类型“System.Object”。LINQ to Entities 仅支持强制转换 Entity Data Model 基元类型。
[解决办法]
在select前,先 AsEnumerable,这也是 延迟查询的。

热点排行