LINQ to SQL C＃中的SELECT COUNT
技术问答
249 人阅读
|
0 人回复
|
2023-09-14
|
|
如何使用COUNT将LINQ编写为SQL？
4 v7 X3 }2 T9 ?% B例子：
3 c9 X0 z4 X, Y% ^& b9 Y0 Hvar purch = from purchase in myBlaContext.purchases
; \4 N! E4 [6 w) ?$ G: Y select purchase;% y; n5 H! @# Z$ O% x0 y5 H# T
我如何在这里得到计数？' T) L+ ?, o( @- ]3 j
# g- F% x! h) Q q9 o+ D* `( m/ T+ M解决方案:
7 r; y& [7 J8 ~
3 S/ L9 E: H' s S) p* W0 C1 [4 b. n! W. c6 P7 w
1 o& J& T1 \0 T4 M% y
像那样1 i( w8 T- ~! g4 J0 F2 p
var purchCount = (from purchase in myBlaContext.purchases select purchase).Count();
/ o% f' S* U6 @- R/ h甚至更容易
, ^( F0 n# C3 x7 g1 c# Dvar purchCount = myBlaContext.purchases.Count() |
|
|
|
|
|
|
|
|
|
