How to get MVC-mini-profiler working on EF 4.1 Database First
Spent better part of the day combing through SO for this. Here's the setup
- MVC 3 App using Repository pattern with 3 repositories across 2 databases.
- EF 4.1 Database first using the DBContext API for both db connections.
- Installed mvc-mini-profiler from n开发者_开发知识库uget
This is how I create my Db Context in the repository
public class TransactionRepository : BaseRepository, ITransactionRepository
{
AccountingEntities _db = new AccountingEntities();
// repository methods
}
Then in controllers
public class InvoiceController : BaseController
{
private ITransactionRepository _txnRepository;
public InvoiceController()
{
_txnRepository = new TransactionRepository();
}
public InvoiceController(ITransactionRepository t)
{
_txnRepository = t;
}
}
Finally, I've added to web.config
<system.data>
<DbProviderFactories>
<remove invariant="MvcMiniProfiler.Data.ProfiledDbProvider" />
<add name="MvcMiniProfiler.Data.ProfiledDbProvider" invariant="MvcMiniProfiler.Data.ProfiledDbProvider" description="MvcMiniProfiler.Data.ProfiledDbProvider" type="MvcMiniProfiler.Data.ProfiledDbProviderFactory, MvcMiniProfiler, Version=1.8.0.0, Culture=neutral, PublicKeyToken=b44f9351044011a3" />
</DbProviderFactories>
</system.data>
What are the next steps to profile these connections? Walk me slowly as this is my first exposure to Entity Framework, so assume very little about EF connection/context details.
I rewrote the interception code so it is way more robust.
- nuget MiniProfiler.EF (version 1.9.1)
- During App Init run:
MiniProfilerEF.Initialize();
精彩评论