Table Of Contents
Order on Amazon
Buy it from Apress Publisher
Book covers recipes that solve common day to day data access problems like modeling, functions, stored procedure, linq to entities, esql, performance, customizing objects, POCO, ntier and leveraging Entity Framework with Asp.net
December 2010 (2)
November 2010 (2)
October 2010 (5)
September 2010 (1)
August 2010 (1)
July 2010 (3)
June 2010 (2)
May 2010 (7)
April 2010 (5)
March 2010 (6)
December 2008 (1)
August 2008 (26)
July 2008 (33)
June 2008 (31)
May 2008 (63)
April 2008 (22)
March 2008 (10)
October 2010 - Posts
Using GetObjectByKey to short circuit database call
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...
Inserting,Updating and Deleting entity using Stored Procedures
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...
Upgrading Independent Association to Foreign Key Association
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...
Thanks EF4. Now i can put my orderby clause anywhere
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...
Watch out for StartsWith when upgrading from .net 3.5 to 4.0
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...