Is it wise to dispose of my DBContext object before page render?

Question

I am using DBContext extensivly in my asp.net web site project. What I typically do is I have an instance of the dbcontext that is available to the page class and I instantiate that on page load and use it throughout the code, I am not disposing of it however. Would it be wise for me to use the Pre_Render event on the page to dispose of the dbcontext (I would assume that it is done being used at that point?)

Thanks for any tips.

SOLUTION

So I ended up writing a little extension class for my Dotnetnuke modules that handles my dbcontext for me, seems to work good, but I have only rolled it out in a few modules so far.

public class ModuleExt : PortalModuleBase
{
    private BPEntities _ent;
    public BPEntities ent 
    {
        get{
            if (_ent == null)
            {
                _ent = new BPEntities();
            }
            return _ent;
        }
    }
    protected void Page_PreRender(object sender, EventArgs e)
    {
        ent.Dispose();
    }
}

This will enable me to just go ahead an use the ent object (my DBContext) and not worry about disposing as it is done for me on pre render.

IronMan84 · Accepted Answer · 2013-04-18 13:35:24Z

You may certainly do that, if you wish, but you'll need to keep one thing in mind: If you ever, at any point, want to reference a child object/collection from that object you'll need to make sure that it's hydrated before you dispose of the context. Otherwise, you will get a exception telling you that the context has been disposed already.

Some people will say to just have a single context through the application, and that is certainly a valid approach as well, but I much prefer what you're doing right now. I don't like having database connections open all of the time.

Cool, All of my classes extend the same base class (I am working with DotNetNuke modules) so I wrote a quickie extension class for the module base class (see above)

Happy Coding

Friday, September 27, 2013

good and cheap company

Wednesday, September 25, 2013

fluent api

Monday, September 23, 2013

good games

Friday, September 20, 2013

chinese food

Tuesday, September 17, 2013