c# - Count Rows in Linq -
i new in linq
i have written following query :
var duplicate = loginid in dataworkspace.v2oneboxdata.me_employees loginid.me_login_name == this.me_login_name && loginid.me_pkey != this.me_pkey select loginid;
i want count rows returned in result duplicate
i searched many of articles says use duplicate.count(). dont see count() in intelisense
how count result
how doing using extension methods:
var count = me_employees.where(me => me.me_login_name == this.me_login_name && me.me_pkey != this.me_pkey).count();
even better:
var count = me_employees.count(me => me.me_login_name == this.me_login_name && me.me_pkey != this.me_pkey);
big note: ensure have referenced system.core. system.data.linq assume referenced it.
Comments
Post a Comment