linq 按一定条件查询不重复的数据

ViewData["distinctcount"] = db.ClubHitCount.Select(a => a.UserID).Distinct().Count(); 能不能在这句基础上加一个限制条件ResourceClubID == vendorid；在线等，谢谢
--------------------编程问答--------------------



ViewData["distinctcount"] = db.ClubHitCount.Select(a => a.UserID && a.ResourceClubID == vendorid).Distinct().Count();

是这么个意思吗？

--------------------编程问答-------------------- 不行报错了 --------------------编程问答-------------------- ViewData["distinctcount"] = db.ClubHitCount.Where(a=>a.ResourceClubID == vendorid).Select(a => a.UserID).Distinct().Count(); --------------------编程问答--------------------



            using (DataClassesDataContext db = new DataClassesDataContext())

            {

                ViewData["distinctcount"] = db.ClubHitCount.where(m => m.ResourceClubID == vendorid).Select(a => a.UserID).Distinct().Count();

            }

--------------------编程问答-------------------- 添加一条where语句，如4楼所写

引用 4 楼 nidexuanzhe 的回复:

C# code?1234 using (DataClassesDataContext db = new DataClassesDataContext()) { ViewData["distinctcount"] = db.ClubHitCount.where(m => m.ResourceClubI……

--------------------编程问答--------------------

引用 3 楼 q107770540 的回复:

ViewData["distinctcount"] = db.ClubHitCount.Where(a=>a.ResourceClubID == vendorid).Select(a => a.UserID).Distinct().Count();

引用 4 楼 nidexuanzhe 的回复:

C# code?1234 using (DataClassesDataContext db = new DataClassesDataContext()) { ViewData["distinctcount"] = db.ClubHitCount.where(m => m.ResourceClubI……

加.where 条件放进去 --------------------编程问答-------------------- [code=csharp]
ViewData["distinctcount"] = db.ClubHitCount.Where(a=>a.ResourceClubID == Vendorid).Select(a => a.UserID).Distinct().Count(); --------------------编程问答-------------------- ViewData["distinctcount"] = db.ClubHitCount.Where(x=>x.ResourceClubID == Vendorid.).Select(x => x.UserID).Distinct().Count() --------------------编程问答--------------------

ViewData["distinctcount"] = db.ClubHitCount.Where(a=>a.ResourceClubID == vendorid).Select(a => a.UserID).Distinct().Count();

--------------------编程问答--------------------

引用 3 楼 q107770540 的回复:

ViewData["distinctcount"] = db.ClubHitCount.Where(a=>a.ResourceClubID == vendorid).Select(a => a.UserID).Distinct().Count();

补充：.NET技术 ,  LINQ