CODEWITHSUNDEEP
servicestackglimpse
Jeremy Smith
Jeremy Smith

Reputation: 1469

MVC4 + ServiceStack +....Glimpse?

I'm running ServiceStack v4 under /api in my MVC4 application. I'd like to have Glimpse profile my SQL queries. My SQL tab is disabled in the HUD.

SQL tab disabled in Glimpse HUD

Any idea how to configure this?

Upvotes: 0

Views: 373

Answers (2)

Jeremy Smith
Jeremy Smith

Reputation: 1469

The solution I chose was to override the SqlServerOrmLiteDialectProvider.CreateDbConnection()similar to this solution.

var dbFactory = new OrmLiteConnectionFactory(
                "<connection string>",
                SqlServerWithGlimpseDialectProvider.Instance);


public class SqlServerWithGlimpseDialectProvider 
    : SqlServerOrmLiteDialectProvider
{
    public new static SqlServerWithGlimpseDialectProvider Instance = new SqlServerWithGlimpseDialectProvider();

    public override IDbConnection CreateConnection(string connectionString, Dictionary<string, string> options)
    {
        return new GlimpseDbConnection(
            base.CreateConnection(connectionString, options) as System.Data.SqlClient.SqlConnection);
    }
}

SQL now profiling:

enter image description here

Upvotes: 3

nikmd23
nikmd23

Reputation: 9103

I'm no ServiceStack expert, but there are docs for getting it setup. Have you tried following these instructions?

Upvotes: 1

Related Questions