generate sql query from entity framework

Question

I am trying to generate sql query using .ToTraceString() in entity framework 3,5; but I am getting the following error

Cannot convert type 'System.Collections.Generic.List to 'System.Data.Objects.ObjectQuery'

I have the following code I need to generate sql query

                  customers= ent.Customer
                      .Include("UserType")
                      .Include("User")
                      .Where(c => c.Enabled == true)
                  .ToList<Customer>();

How to get sql query generated by entity framework. I don't have sql profiler.

Many thanks

Pavel Krymets · Accepted Answer · 2012-02-18 07:33:50Z

1

Try not to call ToList() prior calling ToTraceString() because when you do you have list returned which doesn't have ToTraceString() method

answered Feb 18, 2012 at 7:33

Pavel Krymets

6,3041 gold badge24 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

generate sql query from entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related