Practical .NET

Use Lambda Expressions in LINQ Includes

You couldn't do it in earlier versions of Entity Framework but, in more recent versions, you can use lambda expressions to save yourself from some runtime errors.

As I discuss in my column on building a query layer in an ASP.NET MVC application, the LINQ Include method is essential to controlling getting all the data you want. When I first started working with Entity Framework, you had to pass to the Include method (in quotes) the name of the navigation property you were using to retrieve related items. Typical code would look like this (this retrieves the SalesOrderItem entities associated each SalesOrderHeader through the SalesOrderItems property):

Dim soDTO = From so In db.SalesOrderHeaders _
            Select so

The problem is that, because the property name is in quotes, the compiler can't check it. If you've mistyped the property name (or picked the wrong one), you won't find out until you run your code and it blows up.

These days, however, you can pass a lambda expression to the Include method. Rewriting my previous example to use a lambda expression would look like this (and you'll get IntelliSense support all the way through):

Dim soDTO = From so In db.SalesOrderHeaders _
                .Include(Function(s) s.SalesOrderItems)
            Select so 

You might still pick the wrong property but you can't misspell it. In C#, the query would look like this:

var soDTO = from so in db.SalesOrderHeaders _
                .Include(s => s.SalesOrderItems)
            select so;

This isn't an unalloyed blessing though. If I wanted to include the Product entity that's available from the SalesOrderItem, I would have to do it this way with a lambda expression:

Dim soDTO = From so In sor.SalesOrderHeaders _
                 .Include(Function(s) s.SalesOrderItems.Select(Function(si) si.Product))
            Where so.SalesOrderId = SalesOrderId
            Select so

I have to admit that string-based method:

Dim soDTO = From so In sor.SalesOrderHeaders _
            Where so.SalesOrderId = SalesOrderId
            Select so

is a little easier to read.

About the Author

Peter Vogel is a system architect and principal in PH&V Information Services. PH&V provides full-stack consulting from UX design through object modeling to database design. Peter tweets about his VSM columns with the hashtag #vogelarticles. His blog posts on user experience design can be found at

comments powered by Disqus


  • AI for GitHub Collaboration? Maybe Not So Much

    No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.

  • Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

    As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.

  • .NET 9 Preview 3: 'I've Been Waiting 9 Years for This API!'

    Microsoft's third preview of .NET 9 sees a lot of minor tweaks and fixes with no earth-shaking new functionality, but little things can be important to individual developers.

  • Data Anomaly Detection Using a Neural Autoencoder with C#

    Dr. James McCaffrey of Microsoft Research tackles the process of examining a set of source data to find data items that are different in some way from the majority of the source items.

  • What's New for Python, Java in Visual Studio Code

    Microsoft announced March 2024 updates to its Python and Java extensions for Visual Studio Code, the open source-based, cross-platform code editor that has repeatedly been named the No. 1 tool in major development surveys.

Subscribe on YouTube