EF LINQ to PostgreSQL Include

[damon.cognito]

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();

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)

[Shalex]

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();

[damon.cognito]

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!