Trouble converting SQL Query to LINQ?

Question

I need some help converting the SQL found below to an equivalent LINQ statement in C# assuming that I am using the EF also.

SELECT DISTINCT [ProductID],[NumberOfMixes]
  FROM [EPOS_DB].[dbo].[Combinations]
  WHERE NumberOfMixes != 1
  Group By ProductID, NumberOfMixes

The sql above is producing the correct number of results for me. I just want to wrap .Count().ToString method around a LINQ statement to produce a numeric valued stored in a string. That is all I need.

Why do you need the grouping if you already grab only distinct elements? — BrokenGlass
– BrokenGlass, Commented Nov 12, 2011 at 17:12

BrokenGlass · Accepted Answer · 2011-11-12 17:15:55Z

1

Something like this:

var count = context.Combinations
                   .Where( x=> x.NumberOfMixes!=1)
                   .Select( x=> new { x.ProductId, x.NumberOfMixes })
                   .Distinct()
                   .Count();

answered Nov 12, 2011 at 17:15

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trouble converting SQL Query to LINQ?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related