LINQ to SQL C＃中的SELECT COUNT
技术问答
731 人阅读
|
0 人回复
|
2023-09-14
|
|
如何使用COUNT将LINQ编写为SQL？: Y; n) f, q y1 c3 s5 s [
例子：
$ x* `( U% h1 e x0 ^: Vvar purch = from purchase in myBlaContext.purchases
( j! j+ R. \9 U9 }6 O select purchase;
2 _9 W0 Z/ Z7 Y& f" Z% y我如何在这里得到计数？! N n, H0 T7 @
* |1 p0 L0 |* l2 `! e7 Y0 e
解决方案:
2 U/ d" g7 z0 y* z 3 {7 H4 `) g$ W1 _( p- L8 c$ E. v; H( r
$ _' i. o) X' T ]
9 ^, ^1 t4 ]' G) O1 u4 \' q& t+ A
像那样
0 z+ x7 G5 I, O5 ^1 ~var purchCount = (from purchase in myBlaContext.purchases select purchase).Count();4 r# c3 X, \8 ?3 h' w5 w7 U& O
甚至更容易1 n! m8 L0 n0 q/ C- v0 h. y
var purchCount = myBlaContext.purchases.Count() |
|
|
|
|
|
|
|
|
|
