MiniProfiler监听dbContext.Database.SqlQuery执行的SQL语句
如果用到MiniProfiler,相信大家已经对MiniProfiler有过了解了,并且网上也有好多大神详细解说MiniProfiler的用法,
但是用起来的时候会发现,linq to sql可以监听到,但是用SQL语句写的就监听不到了。
下面直接讲解解决方法:MiniProfiler监听dbContext.Database.SqlQuery执行的SQL语句
using StackExchange.Profiling;
using StackExchange.Profiling.Data;
using StackExchange.Profiling.Helpers.Dapper;
string strsql = @"SELECT * FROM yyterminal.`tbl_terminal_loginlog` a WHERE a.`TERMINAL_SN`=@TERMINAL_SN ORDER BY a.`LOGIN_DATE` DESC LIMIT 0,1";
using (MiniProfiler.Current.Step("根据地理位置"))
{
using (var conn = new ProfiledDbConnection(dbContext.Database.Connection, MiniProfiler.Current))
{
conn.Open();
var model = conn.Query<TerminalProductmanufacturer>(strsql, new MySqlParameter("@TERMINAL_SN", TERMINAL_SN)).FirstOrDefault();
conn.Close();
return model;
}
}