// IQueryable<AlacNet2.Data.Linq.NewAssignmentWorkOrderView> query = context.NewAssignmentWorkOrderViews;
IQueryable<AlacNet2.Data.Linq.NewAssignmentWorkOrderView> query = context.NewAssignmentWorkOrderViews.GroupBy(q=>q.AssignmentId).Select(x=>x.First());
这bug花费了将近一天才解决,首先思路很重要,一开始以为是控件问题,结果是数据问题。但其实出错的提示很清楚,same key,其实就要有意识到是数据库里有重复的键。
如何查找是否有重复键:
SELECT AssignmentId from NewAssignmentWorkOrderView group by AssignmentId having Count(AssignmentId)>1