今天调试Linq to Mysql遇到问题,查遍谷歌,找不到相关资料,很是郁闷:
记录于此,日后再次折腾!
无法获取查询集合的 数量:总是抛出MemberInit异常!
![](http://hi.csdn.net/attachment/201203/13/0_133164802079k7.gif)
发现,与Linq to Sql 不同,实例化对象后,竟然不能使用Count()
var result = from ai in sc.ClCaRTicLEItem
// join au in sc.ClCaRTicLEUser
//on ai.GeneralID equals au.GeneralID into a
// from au in a.DefaultIfEmpty()
//orderby ai.UpdatedTime descending
select new ArticleItemInfo()
{
GeneralId = ai.GeneralID,
CatcherItemId = ai.ItemID,
//OrignalUrl = ai.OrignalUrl,
//Status = (CommonStatus)(ai.Status ?? -2),
//CreatedTime = ai.CreatedTime ?? DateTime.Now,
//UpdatedTime = ai.UpdatedTime ?? DateTime.Now,
//Title = ai.Title,
//Content = ai.Content,
AssignedUser = new UserInfo()
{
Id = au.UserID ?? -1,
Name = au.UserName ?? string.Empty
},
//Remark = au.Remark
};
var result2 = from ai in sc.ClCaRTicLEItem select ai;
int count2 = result2.Count();
Console.WriteLine("==========Count :" + count2);
如上 result.Count()的话 就会抛出异常,result2可以顺利执行。