October 2010 - Posts

0
Comments

Using GetObjectByKey to short circuit database call by zhirani

There are several ways to query for a single entity using Linq such as First or Single. For instance in the code below we are retrieving customer based on CustomerID If you execute the above code 5 times with the same object context, EF will execute the...
0
Comments

Inserting,Updating and Deleting entity using Stored Procedures by zhirani

If you have used entity framework with stored procedure, you would realize it has a great designer and runtime support. Yes there are few gotchas and loose ends that needs to be fixed but it does the job 99% of the time. In this blog, I will show you...
0
Comments

Upgrading Independent Association to Foreign Key Association by zhirani

In EF when you want to define a relationship between two entities, you typically use an association. An association can be many-to-many, 1.. 0..1, many-to-1 etc. Typically you would have tables in the database which are related to each other using foreign...
1
Comments

Thanks EF4. Now i can put my orderby clause anywhere by zhirani

Well most folks wouldn’t have a clue as to what the title of my posting says. This is a problem that stems from EF v1  but is now solved for the most part. in EF4.0. In version 1 of EF, it was recommended that you put your order by operation as the...
0
Comments

Watch out for StartsWith when upgrading from .net 3.5 to 4.0 by zhirani

Currently I am working on .net 3.5 project so i am having to live with Entity Framework. v1. Anyways i was working on a linq query that was making use of StartsWith operator. For some reason based on which page you are coming from the value passed in...
More Posts