In one of our recent projects, we decided to swap SQL Express with SQL Compact to ensure easy installation on client machines…Though the move was smooth there was one hitch….SQL Compact does not support Stored Procedures!!! And here we were with lots of medium complexity SPs with Joins and GroupBys ,OrderBy and Min Max functions! […]
Category Archives: EF 4.0
EF 4.0 Bulb Flash!:- Load only what you need!!
A small tip for those working with Entity Framework 4.0:- We all know the concept of Lazy Loading in the Entity Framework: With lazy loading enabled, related objects are loaded when they are accessed through a navigation property. With lazy loading a drawback is that an object retrieved from the database comes loaded with all […]
Bulb Flash:-Returning Complex objects from Stored Procedures in Entity Framework!
Sometimes when using the Entity Framework we decide to encapsulate a complicated piece of SQL into a stored procedure and call it directly from your code. But how to you extract the result of the Stored Proc if it returns a combination of columns from different tables? Consider the following Stored Proc which returns a […]
Introducing Code First Entity Framework 4.0!
The ADO.NET team recently came up with a new concept in OR mapping called “Code First” model in Entity Framework 4.0 In addition to supporting a designer-based development workflow, EF4 also enables a more code-centric option which we call “code first development”. Code-First Development enables a pretty sweet development workflow While using the Entity Framework, […]