SQL Tab

Dec 4, 2013 at 2:49 PM
Hi Joe,

Just came across the module today and loved it!

Question: Do you foresee adding the "SQL" tab to the Glimpse panel? I think you need to add the Glimpse.Ado package but I'm not sure.

It would be quite handy to have a SQL profiling tool like that for DNN.

Thanks,
Aderson
Coordinator
Dec 4, 2013 at 3:07 PM
There are a couple of reasons why we don't want to include the Glimpse.ADO package for you. Firstly, it won't catch a lot of the SQL activity (from http://getglimpse.com/Help/ADO-Integration):
To retrieve data for the SQL tab, Glimpse attaches itself by providing its own GlimpseDbProviderFactory which wraps the standard ones. This lets it collect information about how you're using your data connections.

If you're not using an ADO connection that uses the DbProviderFactories class, Glimpse won't collect any data for the SQL tab (out of the box).

You can fix this by manually providing a Glimpse-wrapped IDbConnection.
Secondly, it will cause errors with using Entity Framework (from https://github.com/Glimpse/Glimpse/wiki/Sql-tab#relevant-packages):
Note: If you just download the ADO package, but you are running Entity Framework you will have an exception raised. We have tried our best to make this not the case, but this is a limitation enforced on us by Entity Framework. So good rule of thumb, if you are using Entity Framework download the relevant EF package not just the ADO package.
So, you're free to add that package yourself (so long as the DLL is in the bin folder, Glimpse will find it), if it'll be helpful for your modules, but we won't be able to include it for you automatically. We may add the ability in the future to turn it (and other optional plugins) on and off through the module's UI.

Thanks for the input!
Dec 4, 2013 at 5:14 PM
Much appreciated the fast reply Brian.

Cheers,
Aderson
Oct 27, 2014 at 11:01 PM
I was also looking for the SQL tab - thanks for the explanation Brian