Browse by Tags
All Tags »
ADO.NET (RSS)
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...
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...
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...
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...
Most of the transactional scenario, you may need to add the transaction to some table for ref. many apps does it for admin perspective. Problem You can do it in LINQ to SQL with ChangeSet but the problem is with Inserts. It does not give you the Identity
Read More...
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...
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...
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 Resources http://msdn.microsoft.com/en-us/library/cc907912.aspx Overview: ADO.NET Data Services http://msdn.microsoft.com/en-us/library/cc956153.aspx ADO.NET Data Services Team Blog http://blogs.msdn.com/astoriateam/ Phani Raj’s
Read More...
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...
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...
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...
Many of you might be following John Papa’s article on Data and related topics. Myself have came across many of his and are still following. I would like to share a list of articles by him published in MSDN Magazine and available online for you.
Read More...
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...
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...
