实体框架select（）隐藏数据 [英] Entity framework select() hide the data

问题描述

我尝试用distinct（）选择所有唯一（过期日期）：

 gridView3.Columns [0] .FieldName = pis_ExpireDate; 
 
 var EXdates = DB0201.purchases_item_seriels.Where（u =>（u.stitems_ID == ItemID&& u.ss_StoreID == StoreID&& u.pis_Statues == 0）| | 
（u.stitems_ID == ItemID&& u.ss_StoreID == StoreID&& u.pis_Statues == 5）|| 
（u.stitems_ID == ItemID&& u.ss_StoreID == StoreID&& u.pis_Statues == 6））
 .OrderBy（o => o.pis_ExpireDate）.Select（u => u.pis_ExpireDate）.Distinct（）; 
 
 gridControl3.DataSource = EXdates.ToList（）; 

行已创建，但没有数据显示!!



我尝试了什么：



i尝试选择所有数据而不用选择（u => u.pis_ExpireDate），它的工作原理

 gridView3.Columns [0] .FieldName =pis_ExpireDate; 
 
 var EXdates = DB0201.purchases_item_seriels.Where（u =>（u.stitems_ID == ItemID&& u.ss_StoreID == StoreID&& u.pis_Statues == 0）| | 
（u.stitems_ID == ItemID&& u.ss_StoreID == StoreID&& u.pis_Statues == 5）|| 
（u.stitems_ID == ItemID&& u.ss_StoreID == StoreID&& u.pis_Statues == 6））
 .OrderBy（o => o.pis_ExpiraeDate）; 
 gridControl3.DataSource = EXdates.ToList（）; 

行创建并显示所有数据但没有合并

解决方案

谢谢你，更改为

后工作。选择（u => new {u.pis_ExpireDate}）

i try to select all unique (expired dates) with distinct() :

gridView3.Columns[0].FieldName = "pis_ExpireDate";

var EXdates = DB0201.purchases_item_seriels.Where(u => (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 0) ||
                                                                                (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 5) ||
                                                                                (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 6))
                                                                                .OrderBy(o => o.pis_ExpireDate).Select(u => u.pis_ExpireDate).Distinct(); 

    gridControl3.DataSource = EXdates.ToList();

rows created but no data appears!!

What I have tried:

i tried to select all data without Select(u => u.pis_ExpireDate) , it work

gridView3.Columns[0].FieldName = "pis_ExpireDate";

var EXdates = DB0201.purchases_item_seriels.Where(u => (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 0) ||
                                                                                (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 5) ||
                                                                                (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 6))
                                                                                .OrderBy(o => o.pis_ExpiraeDate);
    gridControl3.DataSource = EXdates.ToList();

rows created and all data appear but without merge

解决方案

thank you , it work after changing to

.Select(u => new { u.pis_ExpireDate })

这篇关于实体框架select（）隐藏数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！