Recent Posts

0
Comments

Configuring Existing DataBase with Many-to-Many using Code First by zhirani

With CTP5 of Code First, you can easily map existing database schema to classes in your project.  It allows you to configure what class and property gets mapped to what table and column in the database. Code First gives you two options to configure...
0
Comments

Builder Methods to create dynamic esql queries by zhirani

In the current project, I am working on,  I make use of esql heavily. One of the reason is because I am still using EF v1 which has limited support for linq queries. The second reason is, if you have dynamic queries which are build on what user selects...
0
Comments

Filtering and Ordering Include by zhirani

Lot of times in your application, you have a requirement to eagerly load related collection but you want to load the collection partially and also have the data sorted when before it is materialized at the client layer. Currently in EF, there is no direct...
1
Comments

Binding Stored Procedure Result from Entity Framework to ObjectDataSource Control by zhirani

Not too long ago someone asked me how can they bind data returned from stored procedure to a gridview control. There are several ways to achieve that. You can either use EntityDataSource or ObjectDataSource Control. I find it easier to use ObjectDataSource...
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...
1
Comments

Which one is faster SingleOrDefault or FirstOrDefault by zhirani

Generally, I don't see too much performance problem whether you use Single Or First. However if you have a table with lots of columns like 300 you might notice slight improvement if you use FirstOrDefault. Before we go deeper into the performance difference...
More Posts Next page »