entity framework Group by multiple columns and count the number of groups with more than 1 item

[desanti]

Hello ! I'm using Entity Framework 6 I have Myobject1 : Name , City , Price, Value I want to group all the items on groups that have the same Name , city and Price. After I want to count the groups that have more than 1 item. I'm using this code :

Dim q As Integer = context.myobjects.GroupBy(Function(x) New With {x.Name,x.City,x.Price}).Where(Function(t3) t3.Count > 1).Count

But this query always return 0 But on my table I have several groups that have more than 1 item. What is wrong with my query ? Thank you !

[Richard Deeming]

That code looks like it should work. Are you sure you're connecting to the right database? What happens if you run the generated query directly within SQL? You can see the query with:

Dim query As String = context.myobjects.GroupBy(Function(x) New With {x.Name,x.City,x.Price}).Where(Function(t3) t3.Count > 1).ToString()

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer