Articles about linq

Helping you solve those tough coding problems since 2009!

The specified type member is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported

Published on Jun 21, 2022

This morning I was writing an Entity Framework query where I was selecting an object from a model called Invoice to a table called NetsuiteErrorLog. This previously used to be an actual relationship in my EDMX; however, I needed to do some refactoring and remove the direct foreign key from Invoice to NetsuiteErrorLog. When I did this I needed to add a new partial property that mimicked this relationship. When I did that and tried to perform my query I received the generic error:

The specified type member 'NetsuiteErrorLog' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported

LINQ Group By to Dictionary Object

Published on May 28, 2022

So many times to have a list of objects that I want to group - as an example - by a customer ID. The end result that I would like would be a: Dictionary<long, List>

Tutorials

Learn how to code in HTML, CSS, JavaScript, Python, Ruby, PHP, Java, C#, SQL, and more.

No matter the programming language you're looking to learn, I've hopefully compiled an incredible set of tutorials for you to learn; whether you are beginner or an expert, there is something for everyone to learn. Each topic I go in-depth and provide many examples throughout. I can't wait for you to dig in and improve your skillset with any of the tutorials below.