Bltoolkit Manage DbManager in repository pattern (ASP.Net)

Question

I'm using bltoolkit in my ASP.Net application , I use repository pattern to manage my data access layer. foreach operation i open a new DbManager . I cannot find a way to open and dispose the DbManager Object per request or session . any ideas

Answer 1

IMHO, best way of usage:

    public IEnumerable<int> GetMyTableIds()
    {
        using (var dbManager = new DbManager("database"))
        {
            return dbManager.GetTable<MyTable>()
                     .Select(table => table.Id)
                     .ToArray();
        }
    }

Call of

new DbManager("database")

can be extracted to factory.

Or you may use thread static variables

static class DbManagerContainer
{
   [ThreadStatic]
   public static DbManager DbManager;
}

public void Request_Start()
{
   DbManagerContainer.DbManager = new DbManager("database");
}

public void Request_End()
{
   if (DbManagerContainer.DbManager == null)
   {
     //Write warn to log. This is not normal case.
   }
   else
   {
      DbManagerContainer.DbManager.Dispose();
      DbManagerContainer.DbManager = null;
   }
}