Question

实体框架新版。我有一个数据库问题,我需要转换为实体框架。如何写进LinQ到Enity的询问

谁能帮助我?

SELECT 
  FLD1, 
  FLD2, 
  SUM(FLD3), 
  (TO_CHAR(FLD4, MM/DD/YYYY ))
FROM 
  TABLE1
WHERE 
  (FLD2=XXX ) AND  
  (FLD3 BETWEEN TO_DATE(VARDATE, MMDDYYYY ) AND TO_DATE(VARDATE1, MMDDYYYY ))
GROUP BY 
  FLD1, 
  FLD2, 
  FLD4

Answer 1

Well...info is sparse and you filled it with a lot of different cases something like this would do.

_context.SomeObject
     .Where(x=>x.SomeField == "SomeValue" && x.SomeField > 5 && x.SomeField < 10)
     .Select(x=>new {  x.SomeField1, x.SomeField2, x.SomeField2, SomeField4 = x.SomeChildCollection.Sum(y=>y.SomeChildvalue)
.GroupBy(x=>new {x.SomeField1, x.SomeField2, x.SomeField3})
.ToList()

这将导致一个关键是具有价值的群体:有些领域1、有些领域2、有些领域3,而目标则是与选择中的4个特性进行匿名预测。

在某些类型的比较中,你可能需要使用实体的职能。

友情链接