Related to this thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=20109

The code provided at http://blog.rthand.com/post/2011/07/24/Integrating-MvcMiniProfiler-and-LLBLGenPro.aspx no longer runs and it seems to be an update to MvcMiniProfiler that has caused.

The problem is on the line

return ProfiledDbConnection.Get(conn);

The Get method is no longer available. I'm really keen to get this running so any help would be appreciated.

This is a breaking change for v1.9: http://code.google.com/p/mvc-mini-profiler/issues/detail?id=109

Now you have to use the constructor, instead of the Get method. This is the code to solve the issue:

public class DataAccessAdapterExtended : DataAccessAdapter
{
    protected override System.Data.Common.DbConnection CreateNewPhysicalConnection(string connectionString)
    {
        DbConnection conn = base.CreateNewPhysicalConnection(connectionString);
        return new ProfiledDbConnection(conn, MiniProfiler.Current );
    }

    protected override DynamicQueryEngineBase CreateDynamicQueryEngine()
    {
        return PostProcessNewDynamicQueryEngine(new ProfilingDynamicQueryEngine());
    }
}

Great, I'll look into that this evening when I'm working on it again.

Indeed David's change fixes the problem. I've updated my blog post as well.

I'm having some trouble with the oracle provider and StoredProcedureCall class.

    using(StoredProcedureCall call = CreateCradDalsiaPrCall(dataAccessProvider, pkSkupiny, kodCRady, posunut, datum, uziv, oz, zvacsito, strFormat))
            {
                int toReturn = call.Call(); 
                strFormat = call.GetParameterValue<System.String>(7);
                return toReturn;
            }

On the line

int toReturn = call.Call(); 

i'm getting an exception

Unable to cast object of type 'MvcMiniProfiler.Data.ProfiledDbConnection' to type 'Oracle.DataAccess.Client.OracleConnection'.

This is just happening with StoreedProcedureCall, all other queries are working just fine.

You're using v2.6 I presume? in v3 it should work as it uses the factory to create the proc commands.

I'm using the 3.1 version actually. But this error happens only when a stored procedure call is made.

Could you please post the stack trace.

It could be something inside the mvcminiprofiler, I do recall it works in our own profiler (which uses interception as well).

i'm trying to follow Miha's example in his post, but i'm missing the PostProcessNewDynamicQueryEngine method. i'm using LLBLGen version 2.5.. unfortunately

could someone help me out ?

reyrahadian wrote:

i'm trying to follow Miha's example in his post, but i'm missing the PostProcessNewDynamicQueryEngine method. i'm using LLBLGen version 2.5.. unfortunately

could someone help me out ?

I don't have v2.5 handy but I can suggest you to check the code of the mentioned method with .net reflector or any other such tool and then implement it accordingly. Just check out the code generated by LLBLGenPro - DataAccessAdapter.