This was posted in an internal discussion. The question was that it was observed that sometimes in the generated sql it appeared that EF was very decisive between directly executing the query and sometimes using sp_executesql. Before I go ahead and...

I was a little curious about this change in EFv4 and wanted to understand why this was done. So here is what I was able to understand Background Lets take a look at the following code for querying the EntitySet in EF v3.5 using (NorthwindEntities...

Its been sometime that I have blogged. I recently got asked by one of my peers on how to display the data from DataService on a local report and how to pass a parameter . Its relatively easy to do this , the steps would be Make a connection to the DataService...

QuickPost: I just now answered a question on the forum about one of the errors that might take you a while to figure out. Assume the following scenario, you have a Data Model Project designed as class library for EntityFramework and you have a middle...

I was going through the article published in MSDN by Daniel Simmons about the N-Tier Patterns http://msdn.microsoft.com/en-us/magazine/dd882522.aspx and came across the EntityBag implementation. So I went through couple of posts by Daniel on the EntityBag...

Could not post the details yesterday coz I was tired attending many sessions. Here are the major points from the sessions I attended SQL Server 2008 -Beyond Relational Data by Praveen Srivatsa, Asthrasoft Consulting XML Feature We deal with most of the...

Today I attended TechED-09. Here are the updates from the sessions I attended and some of the interesting things I found out ASP.NET 4.0 Features from Stephen Walther, Program Manager, ASP.NET Source based development, more focus on a neater...

In the previous post I explained how to use a Stored Procedure in Entity Framework that returns an Entity Type. However, if you try to map a stored procedure that is of a scalar type or returns an Array or List type then this won't work automatically...

Entity framework supports stored procedure. In this post I will explore how we can use stored procedures in entity framework. I have created a Windows based application with Northwind database model(EDMX) . And have the Customer and Orders table selected...

In this post I am going to illustrate how to use EdmGen and EntityClient to program with Entity Framework. EdmGen is utility shipped with Entity Framework for creation of the artifacts required for Entity Model Mapping viz the CSDL(Conceptual Schema Definition...

I recently handled an issue where customer was facing difficulty in picking up the Auto Generated primary key column in DataAdapter.Update() call. Looking around on the internet I saw many posts on the forums regarding how to get this value. So thought...

This post is in continuance with the last post  I had on WCSF. In this post I will briefly elaborate on various patterns in web development  and the general terms used to help you understand WCSF in a comprehensive way.   The View Presenter...

In this series, I will help you get started with WCSF developed by Patterns and Practices team at Microsoft. If you are a web developer then this Software Factory will be of great help for you in your upcoming web projects. Let me start of with the...

I am preparing for MCTS Exam 70-536: Microsoft .NET Framework 2.0 - Application Development Foundation and came across the File IO System. So taking this opportunity here to post few details on the I/O streams to help understand the workings, specially...

While running the following query distributed query select * from openrowset ('OraOLEDB.Oracle','oradb';'scott';'pwd1234$', 'select * from emp') I got the following error message : Msg 15281, Level 16, State 1, Line 1 SQL Server blocked access to STATEMENT...

Continuing from part 1, here I will go one more step further and explain the language constructs basics in C# 3.0 which will help us in writing a LINQ query. Lambda Expression Explained In C# 2.0 you can write anonymous delegate methods that helps in...

The 'var' Keyword Type inferred at compile time Can only be defined within method scope Mostly used when you need a variable for anonymous types which can only be resolved at compile time e.g. LINQ queries Auto Implemented properties This feature eases...

Recently I got an issue where we were unable to start the SQL Server Integration Services(SSIS) service and was failing with the error of "Access Denied". If you do a default installation then the SSIS service runs under NT AUTHORITY\Network Service....

We get a lot of queries from developers around the following error while they are using ADO.NET "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were...

One of the major difference between Microsoft JDBC Driver 1.1 and Driver 1.2 is its feature for SSL. If you want to connect to SQL Server 2005 using SSL then you can do this today with the driver. The process to get this done is documented in the help...

I work with the SQL Developer Support group in Microsoft. We handle issues that our customer's face on implementing the following line of technologies :- ADO.NET, DataControls in Web/Windows application, MS XML, Database Drivers, SQL Server programming...