Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I log all SQL statements in ObjectContext

Tags:

c#

.net

winforms

I need to do a log of all SQL statements done. I'm using EF5 and this is my context constructor

public partial class Entities : ObjectContext
{
    public const string ConnectionString = "name=Entities";
    public const string ContainerName = "Entities";

    #region Constructors

    public Entities()
        : base(ConnectionString, ContainerName)
    {
        this.ContextOptions.LazyLoadingEnabled = true;
    }

Update:

This works fine for me: http://efwrappers.codeplex.com/

like image 352
Douglas Franco Avatar asked Sep 18 '25 16:09

Douglas Franco


1 Answers

something like this:

context.Database.Log = Console.Write; 

for more info:

http://msdn.microsoft.com/en-us/data/dn469464.aspx

like image 107
Z.D. Avatar answered Sep 21 '25 06:09

Z.D.