解决MySQL查询与LINQ转换问题：Any方法在LINQtoMySQL中的应用挑战

solution

不过,我的问题是一样的。我无法转换我的

MySQL

查询到

LINQ

LinqPad

为了它。我已经建立了一个连接。执行我的查询并得到结果。但是

lambda

节为空。

SELECT *

FROM (

SELECT

&＃64;row :&＃61; &＃64;row &＃43;1 AS rownum, zdjh,sjsj ,xhqd

FROM (

SELECT &＃64;row :&＃61;0) r, &＃96;tj_xhqd&＃96; ORDER BY sjsj

) ranked

WHERE rownum % 24&＃61; 0 AND zdjh &＃61; &＃39;002999001180&＃39; AND sjsj>&＃61;&＃39;2018-02-24 08:38:11&＃39;

林肯

. 型号名称是

kesc

更新1

我试着改变我的

到

.

var mainDetails &＃61; kesc.tj_xhqd.Where(m &＃61;> (m.zdjh &＃61;&＃61; msn) && (m.sjsj >&＃61; dt)).AsEnumerable()

.Select((x, i) &＃61;> new { MSN &＃61; x.zdjh, PingDateTime &＃61; x.sjsj, PingValue &＃61; x.xhqd, i &＃61; i })

.Where(x &＃61;> x.i % interval &＃61;&＃61; 0)

.ToList();

结果是

{

"details": [

{

"MSN": "002999001180",

"PingDateTime": "2018-05-16T18:39:52",

"PingValue": "19",

"i": 0

},

{

"MSN": "002999001180",

"PingDateTime": "2018-05-16T18:39:52",

"PingValue": "19",

"i": 24

},

{

"MSN": "002999001180",

"PingDateTime": "2018-05-16T18:39:52",

"PingValue": "19",

"i": 48

},

{

"MSN": "002999001180",

"PingDateTime": "2018-05-16T18:39:52",

"PingValue": "19",

"i": 72

},

{

"MSN": "002999001180",

"PingDateTime": "2018-05-16T18:39:52",

"PingValue": "19",

"i": 96

},

.

.

.

.

.

{

"MSN": "002999001180",

"PingDateTime": "2018-05-16T18:39:52",

"PingValue": "19",

"i": 144

},

]

}

return Request.CreateResponse(HttpStatusCode.OK, new { details &＃61; mainDetails });

2018-05-16T18:39:52

.