Browse by Tags
All Tags »
Data Access »
Performance (
RSS)
EFProf – Profiler Tool for Entity Framework One of the important tools in your tool arsenal when you develop with an ORM tool is a profiler. Like SQL profiler to a SQL Server DBA an Entity Framework profiler is a must have tool to Entity Framework developer. The main reasons to acquire such a tool are to understand what is going on underneath the hood in the query engine and for performance tuning. If you think that you can use Entity Framework without knowing what it is committing to database then...
Using Stub Entities in Entity Framework Screencasts Today I recorded my first two screencasts (one in English and one in Hebrew) about how to use stub entities in Entity Framework in order to produce better performance by reducing database round trips. The link to the English version can be found here . The link to the Hebrew version can be found here . You can also download the screencasts in the details tab if you like. Enjoy!
CompiledQuery in Entity Framework There are times when we want to make optimizations on some piece of code. If we want to reduce the cost of executing a query in Entity Framework we can use a CompiledQuery to the rescue. Yesterday I used added a compiled query to a code base which was executing multiple times. This reduced the execution time of the repeating queries. In the post I’ll explain what are CompiledQueries and how to use them. CompiledQuery CompiledQueries are a delegate which store a compiled...
Setting an EntityReference Using an EntityKey in Entity Framework Yesterday I got a question in my blog concerning the ability to set a reference to an entity in Entity Framework by using a foreign key that exists in my hand. The answer is described in this post. Setting an EntityReference Using an EntityKey Sometimes you want to set an EntityReference but you don’t have that entity in the ObjectContext but you have its key. One solution for this problem is to load the entity and then to set the...
Disabling Change Tracking in Entity Framework Entity Framework came along with a very helpful change tracking system. But with great power comes great responsibility. The responsibility of the developers is to make sure that the change tracking option will not be responsible to bad performance. How to Disable the Change Tracking Option In Entity Framework , change tracking is being done by the ObjectStateManager . The ObjectStateManager maintains object state and identity management for entity type...
Eager Loading and Lazy Loading in ADO.NET Data Services In today’s post I’m going to explain how to achieve eager loading and lazy loading functionality with A DO.NET data services .NET clients. What are Eager Loading and Lazy Loading? Lazy loading is a design pattern that is commonly used to defer initialization of an object up until it is needed by the program. The gains of using the pattern include efficiency (if it’s used right) and sometime performance. Eager loading is the opposite pattern...
Batching in ADO.NET Data Services In the last post I’ve written about performing CRUD operations with the ADO.NET data services . In today’s post I’m going to explain how to batch these operations into one HTTP request in order to increase performance. The Consuming Code I’m using the same data service from my last post but I changed the consuming code to the following: static void Main( string [] args) { // build the proxy ...