Difference between Native SQL and Entity SQL

Question

I have gone through an article of using EntityConnection, EntityCommands for executing Entity sql queries. But I was unable to understand that Why are we using Entity sql? Why not directly using the Classes and objects for processing CRUD operations on database?

Or If we want to execute sql queries then why we are using Entity Sql , why not directly Ado.net ?

Is there any performance difference or something else? I have already gone through the page http://msdn.microsoft.com/en-us/library/bb738573.aspx. But I want answer in a more simpler way. Can you please answer me?

Thanks

Henk Holterman · Accepted Answer · 2012-08-17 06:45:04Z

3

Why not directly using the Classes and objects for processing CRUD operations on database?

That is (should be) the way for almost all operations. But sometimes there is a need for accessing the db more directly and precisely.

If we want to execute sql queries then why we are using Entity Sql , why not directly Ado.net ?

E-SQL will still let you work with entities (instead of Rows). This is much easier and more powerful, consider inheritance for example.

E-SQL is also supposed to be independent of the actual database, ie the same for Oracle etc. I have no experience with this yet.

Is there any performance difference or something else?

It can be used to improve performance, yes. But not automatically.

answered Aug 17, 2012 at 6:45

Henk Holterman

276k33 gold badges353 silver badges540 bronze badges

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

2 Comments

Jayant Varshney Over a year ago

Hi Henk, thanks for the beautiful answer. can you please explain "E-SQL will still let you work with entities (instead of Rows)" that you have used in your answer?

Henk Holterman Over a year ago

Like I said, data is returned as objects. And you can use TypeOf<T> in queries.

Ladislav Mrnka · Accepted Answer · 2012-08-17 06:46:43Z

3

The main difference

SQL is database dependent query language working on storage (relational) objects - tables / rows
ESQL is database independent query language working on conceptual (EDMX) objects - entities

ESQL was created prior to LINQ. In some scenarios ESQL offers more functionality than LINQ.

answered Aug 17, 2012 at 6:46

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Collectives™ on Stack Overflow

Difference between Native SQL and Entity SQL

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related