OpenAccess and MiniProfiler

10 posts, 0 answers
  1. Peter
    Peter avatar
    4 posts
    Member since:
    May 2009

    Posted 15 Jul 2012 Link to this post

    I tried to enable OpenAccess for usage with MiniProfiler (http://miniprofiler.com/).

    MiniProfiler provides a "ProfiledDbProviderFactory" which wraps the calls to the underlying DbProviderFactory. To enable the DbProviderFactory I added the following lines to web.config (like in this article: http://www.telerik.com/help/openaccess-orm/openaccess-tasks-deployment-resolving-ado-net-driver.html):

    <system.data>
        <DbProviderFactories>
          <remove invariant="StackExchange.Profiling.Data.ProfiledDbProvider" />
          <remove invariant="System.Data.SqlClient" />
          <add
            name="StackExchange.Profiling.Data.ProfiledDbProvider"
            invariant="System.Data.SqlClient"
            description="StackExchange.Profiling.Data.ProfiledDbProvider"
            type="StackExchange.Profiling.Data.ProfiledDbProviderFactory, StackExchange.Profiling, Version=1.9.0.0, Culture=neutral, PublicKeyToken=b44f9351044011a3" />
        </DbProviderFactories>
      </system.data>

    On debugging I see the correct DbProviderFactory set in myDomainService.DataContext.database.BackendConfiguration.BackendInfo.ProviderFactory

    But no calls to the database are profiled by MiniProfiler.

    Any tipps on how to integrate MiniProfiler into OpenAccess?

  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 18 Jul 2012 Link to this post

    Hello Peter,

    I am afraid that OpenAccess ORM cannot be used with MiniProfiler, it cannot run with wrapped ADO provider.

    Actually you could use the OpenAccess Profiler and Tuning Advisor in order to profile the performance of your application. It will provide you with similar information.

    Hope that helps.

    Regards,
    Damyan Bogoev
    the Telerik team
    OpenAccess ORM Q2'12 Now Available! Get your hands on all the new stuff.
  3. DevCraft banner
  4. Patrice Boissonneault
    Patrice Boissonneault avatar
    28 posts
    Member since:
    Nov 2009

    Posted 02 Nov 2012 Link to this post

    That is unfortunate, I would like to see this feature too.
  5. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 07 Nov 2012 Link to this post

    Hi Patrice,

    Could you please provide us with a feature list, which shows the missing functionality in the OpenAccess ORM logging?

    We will consider it as a future improvement in the product.

    I am looking forward to hearing from you.

    Regards,
    Damyan Bogoev
    the Telerik team
    Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
  6. Bryan
    Bryan avatar
    1 posts
    Member since:
    Jun 2012

    Posted 07 Feb 2013 Link to this post

    I too would like to see the ability to integrate with MiniProfiler.
  7. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 11 Feb 2013 Link to this post

    Hello Bryan,

    Currently an integration with the MiniProfiler is not on our to-do list.

    If this is important to you, please feel free to add an entry to our Ideas & Feedback portal.


    All the best,
    Damyan Bogoev
    the Telerik team
    Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.
  8. Joshua
    Joshua avatar
    5 posts
    Member since:
    Jul 2012

    Posted 17 Apr 2013 Link to this post

    The OA Profiler is great for tuning Query performance in isolation, however; it falls short when devs want to monitor app performance as a whole.  In addition, MiniProfiler allows anyone to keep tabs on app performance, not just developers with the profiler installed.

    The missing feature is Context, which can only be provided by something running in app.  Its not that the OA profiler isn't great, it is :), the issue is that it does not provide the same answers, and passive perf monitoring, MiniProfiler does. 

    -Josh
  9. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 22 Apr 2013 Link to this post

    Hello Josh,

    You are correct, the target of the OpenAccess Profiler is measuring query performance and suggesting optimizations to the domain model and the way it is used.
    Integration with MiniProfiler seems useful, however it is currently with low priority in our backlog. We will need to get more requests for it before the implementation is started, as it would require exposing some internal parts of our API and other not so trivial changes.
    Thank you for your feedback.

    Greetings,
    Alexander
    the Telerik team
    Using Encrypted Connection Strings with Telerik OpenAccess ORM. Read our latest blog article >>
  10. Primoz Krajnik
    Primoz Krajnik avatar
    1 posts
    Member since:
    May 2006

    Posted 23 Apr 2013 Link to this post

    +1

    Dear Telerik friends, here's my vote to climb MiniProfiler up the backlog.


    Thanks,
    primož
  11. Joshua
    Joshua avatar
    5 posts
    Member since:
    Jul 2012

    Posted 23 Apr 2013 Link to this post

    Hi All,
    I added the request to the feedback portal.  Make sure to place your votes here: http://feedback.telerik.com/Project/114/Feedback/Details/46909-enable-integration-with-miniprofiler

    -Josh
Back to Top
DevCraft banner