How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]

by

In entity framework 6.0, the Database class has a property Action<string> Log. so setting up logging is as easy as:

context.Database.Log = Console.WriteLine;

For more advanced needs you can set up an interceptor.

More Related Contents:

  1. Fastest Way of Inserting in Entity Framework
  2. One DbContext per web request… why?
  3. Entering keys manually with Entity Framework
  4. The entity type is not part of the model for the current context
  5. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  6. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  7. LINQ to SQL multiple tables left outer join
  8. Entity Framework error: Cannot insert explicit value for identity column in table
  9. Entity Framework. Delete all rows in table
  10. Entity Framework – stored procedure return value
  11. EF 6 Parameter Sniffing
  12. The operation cannot be completed because the DbContext has been disposed using MVC 4
  13. Configure multiple database Entity Framework 6
  14. Retrieve an object from entityframework without ONE field
  15. Join and Include in Entity Framework
  16. Anonymous type result from sql query execution entity framework
  17. DbContext discard changes without disposing
  18. Can you get the DbContext from a DbSet?
  19. How to Refresh DbContext
  20. Calling a SQL User-defined function in a LINQ query
  21. NSubstitute DbSet / IQueryable
  22. Stored procedure returns int instead of result set
  23. How to use String property as primary key in Entity Framework
  24. Querying data using Entity Framework from dynamically created table
  25. Query extremely slow in code but fast in SSMS
  26. Entity-framework code is slow when using Include() many times
  27. Can we have table without primary key in entity framework?
  28. ASP.NET Core API only returning first result of list
  29. How do I extract data from a DataTable?
  30. How to include() nested child entity in linq

Leave a Comment