Entity Framework lazy loading fails for properties of just added entity

Question

Trying to get a property via lazy loading of a just added entity fails.

The only solution I've found until now is to decomment the commented code ,in other words to create another Manager which in turn creates another Context since each Manager has an instance of the Context and then re-query the entity.

I also tried creating a shared Context instance between all Managers but same result. Any idea why recreating the Context solves it and how to fix this?

Here is the code I use to test:

    IOrderManager ordManager = new OrderManager();

    [TestMethod]
    public void CategoryFromOrder()
    {
        Order order = new OrderBuilder()
            .SetCategory(2)
            .SetLegalForm(8)
            .SetClientIdentifier(new Random().Next(11111111,99999999).ToString())
            .SetLastName("Chaouachi")
            .SetFirstName("Saif")
            .SetQuantity(450)
            .SetStatus(Order.StatusValues.New)
            .SetAccountHolder("John")
            .SetPrimaryKey(PrimaryKeyFactory.GetOrderPrimaryKey(null, 1, 2))
            .Build();


        int res = ordManager.AddOrder(order);


    //ordManager = new OrderManager();                       
    // order = ordManager.GetOrder(PrimaryKeyFactory.GetOrderPrimaryKey(res, 1, 2));

        var categ = order.Category;

        Assert.IsNotNull(categ);
    }

Stilgar · Accepted Answer · 2014-08-27 11:06:38Z

3

For lazy loading to work with Code First Entity Framework you need a proxy object (an instance of a class inherited from your original POCO class). It is not obvious from your code but I expect that the original object is created via new Order() and if you want a proxy object you should use DataContext.Orders.Create(). The resulting object will be a proxy and lazy loading will work.

http://msdn.microsoft.com/en-us/library/gg679504(v=vs.113).aspx

answered Aug 27, 2014 at 11:06

Stilgar

23.8k16 gold badges68 silver badges108 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework lazy loading fails for properties of just added entity

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related