EF EntityClient for performance

Earlier this week, I wrote a post discussing when I would choose querying an data through an Entity Data Model using LINQ to Entities vs. Object services + Entity SQL vs. EntityClient + Entity SQL.

One of the advantages I pointed out about using EntityClient is that it returns datareaders and does not attempt to turn the returned data into objects. In re-reading Zlatko Michailov’s EntityClient post from earlier this year, I realize that I didn’t highlight one of the most important reasons about being able to return datareaders, in case it isn’t obvious: Performance. But note that this is for reading only.

If you do not need the Entity objects materialized by object services and do not need the other benefits of object services (e.g. change tracking and DML) and just want to get your hands on the data, using Entity Client will get it to you the most quickly. While this can also be done with ADO.NET, EntityCLient gives you the benefit of querying the conceptual model rather than directly against the database schema.

  Sign up for my newsletter so you don't miss my conference & Pluralsight course announcements!  

2 thoughts on “EF EntityClient for performance

  1. Julie, i wish you are watching this. There’s a women’s conference going on in california and iam watching it thru live webcast. Speaking is jody williams, nobel laureaute from vermont. It’s 10/23/2007 20:23 hrs.

  2. Julie, i wish you are watching this. There’s a women’s conference going on in california and iam watching it thru live webcast. Speaking is jody williams, nobel laureaute from vermont. It’s 10/23/2007 20:23 hrs.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.