Devart Forums

Posted: **Tue 23 Jun 2015 22:37**

As I understand it you should be able to construct an eager laoding statement like:

    var blog1 = context.Blogs.Where(b => b.Name == "PostgreSQL") 
                        .Include(b => b.Posts).FirstOrDefault();

but I can only get it to work if I use a string (which is obviously not great). I feel I'm missing something obvious here...

Code: Select all

    var blog1 = context.Blogs.Where(b => b.Name == "PostgreSQL") 
                        .Include("Posts").FirstOrDefault();

(EF to PostgreSQL 9.3.4)

Posted: **Wed 24 Jun 2015 13:51**

damon.cognito wrote:As I understand it you should be able to construct an eager laoding statement like:
Code: Select all
    var blog1 = context.Blogs.Where(b => b.Name == "PostgreSQL") 
                        .Include(b => b.Posts).FirstOrDefault();

This functionality is implemented by Microsoft via the DbExtensions methods: https://msdn.microsoft.com/en-us/librar ... 03%29.aspx. Just add the necessary namespace and try again:

Code: Select all

    using System.Data.Entity;
//...
    var blog1 = context.Blogs.Where(b => b.Name == "PostgreSQL") 
                        .Include(b => b.Posts).FirstOrDefault();

Posted: **Wed 24 Jun 2015 17:27**

Brilliant thanks - knew I was missing something. Just in case anyone else is looking at this, the include appears to have to be before the Where.

cheers!

Devart Forums

EF LINQ to PostgreSQL Include

EF LINQ to PostgreSQL Include

Re: EF LINQ to PostgreSQL Include

Re: EF LINQ to PostgreSQL Include