Updating Columns with Foreign Key takes more than 1 minute first time in Entity Framework

Question

I am trying to update the entity that has some columns with foreign keys. Everything seems to work fine but during first time assignment, it takes more than 1 minute but if I execute the same action again , it comes immediately.

Code Snippet :

 public bool UpdateStatus(DetailDataModel DetailDataModel)
    {
        Details updateStatus = (from d in UnitOfWork.Details
                           where d.Id == DetailDataModel.Id
                           select d).FirstOrDefault();
        updateStatus.StatusId = DetailDataModel.StatusId;
        UnitOfWork.Commit();
        return true;
    }

Below is the culprit line :

updateStatus.StatusId = updateStatus.StatusId;

I cannot find the problem but when try to update other columns of the same entity, it works fine and the problem is only with Foreignkey columns. Is there any limitation for association with Entity framework.

Please suggest your thoughts on it, Thanks in Advance.

score 1 · Accepted Answer · edited May 23 '17 at 11:48

1

I guess you are using POCO T4 Generator and you have lazy loading enabled because in such case the delay can be easily explained - fixup methods in generated POCO classes will cause lazy loading of Status entity and in turn lazy loading of all its related Details.

If you don't need lazy loading for this operation try to turn it off in your context otherwise you will have remove circular reference from your entity model (Status will not have navigation property to Details) or modify T4 template and remove those fixup calls.

edited May 23 '17 at 11:48

Community

1
1

answered Feb 14 '12 at 08:57

Ladislav Mrnka

360,892
59
660
670

Yes you are correct I am using POCO template only and as you mentioned it takes more time in setting up fixup relation. But my point it occurs only when i changed it default status to something else but once default status is changed, it works fine everytime. By the way how can i remove Lazy loading for particular for particular action while all other place I need. Thanks a lot for answering. – linktoarun Feb 15 '12 at 18:59

score 0 · Answer 2 · answered Feb 24 '12 at 16:39

0

Disabling the Lazy loading for objectContext work as it is just Update statement for one column so Eager loading is not required, Below code worked :

UnitOfWork.EnableLazyLoading = false;

answered Feb 24 '12 at 16:39

linktoarun

203
1
2
6

Updating Columns with Foreign Key takes more than 1 minute first time in Entity Framework

2 Answers2