Entity Framework Code First lazy loading non navigation properties

Question

I'm using the entity framework code first CTP4.

Is it possible to lazy load non navigation properties like you can in NH 3.

A common example would be having a table containing a binary column. I only want to retrieve this column's data when I explicitly ask for that property in my code e.g. image.ImageData

Thanks Ben

Just a guess. There is a Table Splitting approach, maybe it will help: thedatafarm.com/blog/data-access/… — Devart
– Devart, Commented Nov 1, 2010 at 12:42
Yes this is what we used to do with NH before support for lazy loaded properties was added. Looks like the same will be true of EF code first. — Ben Foster
– Ben Foster, Commented Nov 5, 2010 at 12:18

Community · Accepted Answer · 2017-05-23 11:55:35Z

2

Vote here
Vote here
Read this

Ugly workaround:

public static void Main()
{
  IEnumerable<MyTable> table;
  using (Entities context = new Entities())
  {
    var buffer =
      context.MyTable
      .Select(myTable => new
      {
        Id = myTable.Id,
        OtherColumn = myTable.OtherColumn
      })
      .ToArray();

    table = buffer
      .Select(t => new MyTable 
      {
        Id = t.Id, 
        OtherColumn = t.OtherColumn
      });
  }
}

This will not select the rest of the fields.

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered May 9, 2011 at 19:50

Shimmy Weitzhandler

105k126 gold badges437 silver badges644 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Code First lazy loading non navigation properties

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related