I am new in Entity framework. Please help me to convert these sql query in Entity Framework. Here table name is DB_Deals and Title, ProductDescription,VendorName are the fields.
Here is the Query:-
1.SELECT DISTINCT Title, ProductDescription, COUNT(1) as Duplicate FROM DB_Deals GROUP BY Title, ProductDescription HAVING COUNT(1) > 1;
2. select a.Title,a.ProductDescription,a.VendorName from DB_Deals a join (SELECT DISTINCT Title, ProductDescription, COUNT(1) as Duplicate FROM DB_Deals GROUP BY Title, ProductDescription HAVING COUNT(1) > 1)b on a.Title=b.Title and a.ProductDescription=b.ProductDescription
Thanks in Advanced.