DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

8
shouts

Shout it

LINQ Group By with NULL database values

published 584 days, 1 hour, 5 minutes ago posted by

http://vistadb.myopenid.com/ 584 days, 23 hours, 55 minutes ago

LINQ is fantastic for the ability to write queries that express intent much more clearly than the same SQL, or structured code. One problem that I have run into though is handling NULL database values that are part of a group by statement. Grouping by ProductSKU Grouping in LINQ allows you to return sets of data from a collection for a given key value. The group by clause is what the key ends up being in the result set. Lets take a grouping of the Products by the SKU.from p in Products group p ...