What generates the SQL in Entity Framework?

Question

I have tried to find this answer but cannot. What is generating the underlying SQL when using EF? Is it EF or the provider you are using? Also, is there any way to provide hints in order to change the way the SQL is generated?

Thanks in advance

Justin Niessner · Accepted Answer · 2010-10-18 12:41:39Z

4

Entity Framework takes your LINQ queries and examines them using Expression Trees.

The provider then uses those Expression Trees to generate the appropriate SQL statements.

MSDN has a very good explanation of Expression Trees and how they work.

answered Oct 18, 2010 at 12:41

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

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

Comments

Nix · Accepted Answer · 2010-10-18 12:54:14Z

0

The only way you can generate "hints" is through the way you write your LINQ statements. The Provider is what generates the SQL.

If you decide you want to write your own proivider check out re-linq. White paper on re-linq (explains a lot about what it is..

edited Oct 18, 2010 at 12:54

answered Oct 18, 2010 at 12:40

Nix

58.8k31 gold badges154 silver badges206 bronze badges

Collectives™ on Stack Overflow

What generates the SQL in Entity Framework?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related