LINQ to SQL C#中的SELECT COUNT
技术问答
248 人阅读
|
0 人回复
|
2023-09-14
|
如何使用COUNT将LINQ编写为SQL?
* m0 ~8 u) Q$ n# k% V2 E) Y. W例子:
( O; G7 [. q- @3 y: T% x6 lvar purch = from purchase in myBlaContext.purchases
1 f) x- W1 ~& M' M" U5 O/ C select purchase;
5 w _5 V5 Y/ W& w& A/ z Z我如何在这里得到计数?- l3 @) G$ `9 o6 x0 s1 T- ~
: ^/ F7 P M: R7 K2 Y1 j2 ]. N* m解决方案:
- C8 o0 o5 `+ o' f8 J ! d _& f. f$ d' y& V" _: }% B
, j, o$ V7 i- P- p' O0 R
' S" i" F1 s1 y! T& a 像那样
) q" l4 G5 M/ u4 l' y3 Ivar purchCount = (from purchase in myBlaContext.purchases select purchase).Count();
* R: K5 c5 I, c) o' k2 Z甚至更容易7 }. ~3 x- n7 B! F, C2 T
var purchCount = myBlaContext.purchases.Count() |
|
|
|
|
|