where子句不在LINQ c sharp的组中工作

Question

我有一个表"register_operation with fields"；[键]int id_registru_casa，DateTime数据，int id_cont_ sintetic，十进制suma，字符串提示

tip只能取2个值："；收据"；以及"；"付款"；

"Groupby"；工作没有问题但是当我加上"；其中"；条款无效(它没有显示任何记录((尽管数据库中有第19天、第9个月和小费=收据的记录(

var centralizator_rc = db.register_operation
.Where(i => (i.data.Day == 19) && (i.data.Month == 9) && (tip=="receipts"))
.GroupBy(i => i.id_cont_sintetic)
.Select(g => new {
id_cont_sintetic = g.Key,
total_receipts = g.Sum(i=>i.suma),
}).ToList();

谢谢！

Answer 1

已解决！我这样更改代码：

var centralizator_rc = db.registru_casa  
.Where(crc=>(crc.data.Month==8) && (crc.data.Day==16) && (crc.tip=="receipts"))
.GroupBy(crc=> new
{
crc.id_cont_sintetic,
crc.data.Month,
crc.data.Day,
crc.tip
})                             
.Select(g => new  {
data = ziuaOK,
id_cont_sintetic = g.Key.id_cont_sintetic,
total_incasare = g.Sum(i => i.suma),

}).ToList();