Click here to Skip to main content
11,495,534 members (64,967 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# entity
Hi,

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
Posted 16-Aug-12 21:15pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Comments
ricksvarshney at 21-Aug-12 4:34am
   
thanks, It is really appreciable
Arunprasath Natarajan at 21-Aug-12 5:36am
   
u r welcome...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Dnyaneshwar@Pune 692
1 CHill60 318
2 Sascha Lefèvre 265
3 Nakul Chaudhari 236
4 Sergey Alexandrovich Kryukov 230
0 Sergey Alexandrovich Kryukov 10,322
1 OriginalGriff 8,821
2 Sascha Lefèvre 3,889
3 Maciej Los 3,422
4 Richard Deeming 2,560


Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 17 Aug 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100