Welcome to MSDN Blogs Sign in | Join | Help

Wriju's BLOG

.NET and everything

Browse by Tags

All Tags » ADO.NET Entity Framework   (RSS)
ADO.NET Entity Framework v2 : ExecuteStoreQuery
There is now an option in ADO.Net Entity Framework v2 for us to execute store query, IEnumerable < Customer > custs = ctx.ExecuteStoreQuery< Customer >( "SELECT * FROM Customers" , null ); foreach ( var c in custs) { Console .WriteLine(c.CustomerID); Read More...
ADO.NET Entity Framework : Working with Stored Procedure – The Video
In my previous text based blog I had promised to share the recording. Here it is and I am using Silverlight Streaming Namoskar!!! Read More...
ADO.NET Entity Framework : Editing a detached Object
In Layered scenario, you might need to pass an object to another method while updating. Carrying open Context is not good however you may try the below approach by using “ CreateEntityKey ”. But this will not work if you have configured your edmx with Read More...
Data Services (aka Astoria) : CRUD (Select / Insert / Update / Delete )
Creating Astoria is very easy and many of you might have tried that out. What important for us is to work with that data. If you are developing Visual Studio Solution then things are quite obvious as mentioned below, Either you will have Astoria or you Read More...
ADO.NET Entity Framework and Data Services Case Study
Story of Misys Healthcare Systems is very interesting. They have increased 60% of their development process while migrating their apps to ASP.NET Ajax using Entity Framework and Data Services. Full story at http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000002427 Read More...
ADO.NET Entity Framework vs LINQ to SQL
I have been getting a continuous request on what we should be using? LINQ to SQL or ADO.NET Entity Framework? I have posted few articles on that, please feel free to visit Choosing between ADO.NET Entity Framework and LINQ to SQL Choosing between LINQ Read More...
ADO.NET Entity Framework Resources
Compiled Resources http://www.renaissance.co.il/downloads/Entity%20Framework%20Essential%20Resources.pdf Articles Next-Generation Data Access: Making the Conceptual Level Real http://msdn.microsoft.com/en-us/library/aa730866(VS.80).aspx The ADO.NET Entity Read More...
Choosing between ADO.NET Entity Framework and LINQ to SQL
As part of my day to job I come across a very common question from the developer community that one should be using LINQ to SQL (L2S) or ADO.NET Entity Framework (EF). Earlier I have posted a blog containing the features http://blogs.msdn.com/wriju/archive/2009/01/05/choosing-between-linq-to-sql-and-entity-framework.aspx Read More...
ADO.NET Entity Framework : Working with Stored Procedure
Here we go, I generally get questions from developers that if they will have to scrub the existing powerful stored procedure they have written by investing time and money. The answer to that is “NO”. You must enjoy using it as it has its own power. So Read More...
ADO.NET Entity Framework : Paging EntitySQL
Paging in EntitySQL is really easy to achieve. You have got two important sub-clauses (or query operators) are available, SKIP and LIMIT. So your paging EntitySQL query would ideally look like, "SELECT VALUE e FROM NorthwindEntities.Customers AS e ORDER Read More...
ADO.NET Entity Framework : Using EntityClient and EntitySQL
Using Entity Framework with LINQ is simple and fun stuff. But if you are concerned about the performance and comfortable writing ADO.NET like code then EntityClient is for you. It resides under System.Data.EntityClient namespace. If you are using it you Read More...
ADO.NET Data Services Resources
Help yourself by exploring below resources on ADO.NET Data Services (aka "Project Astoria"). Data Platform Developer Center - Data Services page Data services conceptual documentation on MSDN Data services API reference documentation on MSDN Read More...
ADO.NET Entity Framework : Learn EntitySQL
I am pretty sure that many of you do not want to learn EntitySQL J . But for those who would may follow the below links Entity SQL Overview An overview of Entity SQL. Entity SQL Reference Provides syntax for the Entity SQL functions and operators. Namoskar!! Read More...
LINQ to Entity : Supported and Unsupported Methods
There is a correction for this Post , so do I have changed the title. Thanks to Chris Love who pointed me the faults with earlier post, I got few question on some of the popular paging methods of LINQ which does not work on LINQ to Entity. This is by Read More...
ADO.NET Entity: LINQ to Entity with Relationship
Relationship and getting data from Entity Framework using Northwind database Simple Query using ( NorthwindEntities ctx = new NorthwindEntities ()) { var query = from o in ctx.Orders select o.OrderID; foreach ( var k in query) { Console .WriteLine(k); Read More...
More Posts Next page »
Page view tracker