This is a migrated thread and some comments may be shown as answers.
Connections, where should they be set?
2 Answers 114 Views
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Hessner
Top achievements
Rank 2
Hessner asked on 12 Nov 2008, 01:13 PM
Hi,

I have a "best practice" question:

Would like to have global database access in my code behind, without having to open a connection/create an object every time.

Today in LINQ to SQL, I open a datacontext object i Page_Load and close it again in Page_Unload.

The Page_Load/Unload are placed in a "master" class that my page inherit from.

Therefore all my "in-between" code have easy access to the data.

I know that any time consuming code will hold a connection open, and this is a drawback using this "solution".

Does OpenAccess support this approach - and what would the Page_Load/Unload code look like?

Final question,- can you suggest a method, or best practice, as simple as the one I use today?

Regards,
Bo Hessner

2 Answers, 1 is accepted

Sort by
0
Accepted
Jan Blessenohl
Telerik team
answered on 15 Nov 2008, 11:56 AM
Hi Bo,

The way to work looks good to me. We are caching the session objects anyway so that even if you do not use them, it should not be an overhead.

In the page load you can just create your business logic instance if you want to have the OpenAccess session in a DAL or create an IObjectScope object directly.

Add a variable IObjectScope to your master page.
Retrieve an ObjectScope in page load with:

- if you have the helper class: scope=ObjectScopeProvider1.GetNewObjectScope();
- if not: scope=Telerik.OpenAccess.Database.Get("DatabaseConnection1").GetObjectScope();

In the page Dispose or unload you can just dispose the scope

The code:
using System;
using Telerik.OpenAccess;

public partial class _Default : System.Web.UI.Page 
{
    private IObjectScope scope;

    protected void Page_Load(object sender, EventArgs e)
    {
        //scope = ObjectScopeProvider1.GetNewObjectScope();
        scope = Database.Get("DatabaseConnection1").GetObjectScope();
    }
    public override void Dispose()
    {
        base.Dispose();
        scope.Dispose();
    }
}

I prefer the Dispose place because here is the place where everything should be disposed :)


Best wishes,
Jan Blessenohl
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Hessner
Top achievements
Rank 2
answered on 15 Nov 2008, 12:10 PM
Super Jan!

Nice to hear, from an expert, that my way of doing things are good - I will replace my Page_Unload with the Dispose event.

Regards,
Bo Hessner 
Tags
General Discussions
Asked by
Hessner
Top achievements
Rank 2
Answers by
Jan Blessenohl
Telerik team
Hessner
Top achievements
Rank 2
Share this question
or