Log Queries executed by Entity Framework DbContext
Solution 1
Logging and Intercepting Database Operations article at MSDN is what your are looking for.
The DbContext.Database.Log
property can be set to a delegate for any method that takes a string. Most commonly it is used with any TextWriter
by setting it to the “Write” method of that TextWriter. All SQL generated by the current context will be logged to that writer. For example, the following code will log SQL to the console:
using (var context = new BlogContext())
{
context.Database.Log = Console.Write;
// Your code here...
}
Solution 2
You can use this line to log the SQL queries to the Visual Studio "Output" window only and not to a console window, again in Debug mode only.
public class YourContext : DbContext
{
public YourContext()
{
Database.Log = sql => Debug.Write(sql);
}
}
Solution 3
If you've got a .NET Core setup with a logger, then EF will log its queries to whichever output you want: debug output window, console, file, etc.
You merely need to configure the 'Information' log level in your appsettings. For instance, this has EF logging to the debug output window:
"Logging": {
"PathFormat": "Logs/log-{Date}.txt",
"IncludeScopes": false,
"Debug": {
"LogLevel": {
"Default": "Information",
"System": "Information",
"Microsoft": "Information"
}
},
"Console": {
"LogLevel": {
"Default": "Information",
"System": "Warning",
"Microsoft": "Warning"
}
},
"File": {
"LogLevel": {
"Default": "Information",
"System": "Warning",
"Microsoft": "Warning"
}
},
"LogLevel": {
"Default": "Information",
"System": "Warning",
"Microsoft": "Warning"
}
}
Solution 4
EF Core logging automatically integrates with the logging mechanisms of .NET Core. Example how it can be used to log to console:
public class SchoolContext : DbContext
{
//static LoggerFactory object
public static readonly ILoggerFactory loggerFactory = new LoggerFactory(new[] {
new ConsoleLoggerProvider((_, __) => true, true)
});
//or
// public static readonly ILoggerFactory loggerFactory = new LoggerFactory().AddConsole((_,___) => true);
public SchoolContext():base()
{
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseLoggerFactory(loggerFactory) //tie-up DbContext with LoggerFactory object
.EnableSensitiveDataLogging()
.UseSqlServer(@"Server=.\SQLEXPRESS;Database=SchoolDB;Trusted_Connection=True;");
}
public DbSet<Student> Students { get; set; }
}
If you would like to log to output window use this instead:
public static readonly ILoggerFactory loggerFactory = new LoggerFactory(new[] {
new DebugLoggerProvider()
});
https://www.entityframeworktutorial.net/efcore/logging-in-entityframework-core.aspx
Solution 5
If someone is using EF6.1+ there is an easy way. Check the below links for more details.
Example Code
<interceptors>
<interceptor type="System.Data.Entity.Infrastructure.Interception.DatabaseLogger, EntityFramework">
<parameters>
<parameter value="C:\Stuff\LogOutput.txt"/>
<parameter value="true" type="System.Boolean"/>
</parameters>
</interceptor>
</interceptors>
PC.
Software Engineer. Languages used: Java, C++, C#, .Net Experienced in Enterprise Web App and Mobile App Development. A part of Firefox development community.
Updated on July 09, 2022Comments
-
PC. almost 2 years
I'm using EF 6.0 with LINQ in MVC 5 project. I want to log all the SQL queries executed by the Entity Framework DbContext for debugging/performance-measurement purpose.
In Java/Hibernate, equivalent behavior can be achieved by setting the property
hibernate.show_sql=true
. Is it possible to have a similar behavior in Entity Framework? -
Al Dass over 8 yearsfyi: if you use
context.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
then it will only log when in Debug mode. Calls toSystem.Diagnostics.Debug
are ignored in Release mode. -
Andrew over 8 yearsor you can wrap this line of code into method decorated with
[Conditional("Debug")]
attribute -
Admin about 7 years@Andrew, Can you tell me where this Database.log action is invoked under the hood?
-
pingOfDoom almost 3 yearsIt seems this works but the sql queries generated are parameterized. In debug mode, how would I print the parameterized values?