Hints And Tips research knowledge archive
Tip# 505
Sponsored Links
 
Subject: LINQ - LoadOptions not working
Updated: Nov-4-2007
Rating: Not Rated
By: Rocky Moore - Member #: 1
Location: Klamath Falls, Oregon USA
Website: www.RockyMoore.com
Category: Computers > Programming > Databases
Rate This Tip (10=Great):  1  2  3  4  5  6  7  8  9  10
I did not have time to fully research this and see exactly where the issue is at, but when using the DataContext LoadOptions to force load of records instead of delayed loading, and then adding a record, it seems the LoadOptions get missed up or it is just the DataContext locking its hooks on the object in someway.

Today I tried the above and after the SubmitChanges() on the DataContext, returned the newly added item after disposing of the DataContext.  It seems the DataContext was still tied in and I got an error saying it cannot access the DataContext after disposed.

Next step was to requery the same DataContext for the newly added item thinking the LoadOptions would kick in and load it and child classes.  I did not check to make sure it loaded the child objects as expected and it may just be tied to the DataContext, but it did not change anything, same error.

What I ened up doing was disposing of the DataContext and then creating a new one with new LoadOptions again, and this time it worked.  I may not had to have gone this drastic, but it worked and I did not have time to look into it further.

The result was to dispose and recreate the DataContext after the add.  Not sure if this is by design, perhaps a bug in the beta version or maybe there is just something I am missing.  All I know at this point is that it worked, so I could move on ;)

[Submit DIGG for this tip]


-----------
Note: Use the tips posted on this site at your own risk. The tips are posted by the public and as such may or may not be valid.

Sponsored Links
Categories
hints and tips gold divider
Sponsor Sites To Visit
The Awakening
Spirit-Filled Christianity is
more than filling a pew !

Not producing fruit?
Healing, where to turn?
Provision, where to turn?
Lost, where to turn?

It is time for --TheAwakening !
The Saints In Light
Christian Thoughts on
Various Topics - Check it Out!

Click Here
Silverlight City

Keep up with the latest in
Microsoft's Silverlight
Technology!

Click Here
Our Local Christians
Find other Christians
In your local area
Who share your beliefs!

Click Here
United Christian Voters
Tired of seeing your
Rights Vanish?
If all Christians would
Pull together, we can
bring Change Unite Now!

Click Here
Reflected Thought
Inventions ~ Ideas ~ Humor
Politics ~ Opinions ~ Thoughts
Software Development
Business And Stuff....

Click Here
XML RSS News Feed For Recently Posted Hints And Tips  RSS Feed
You can now get updates to the Recent Tips section by using RSS. The address is:

HintsAndTips.com/Rss.aspx

* Posting Tips *
To post a Tip, Recommendation or Tips Wanted, simply browse to the category you feel is a best fit for your post (click on the Recommention or Tips Wanted tab if fitting) and then click on "New Post" option.
(C) Copyright 1998-2008 All Rights Reserved By R & J Technologies - www.RJSoft.com