All About Data

EF query execution pattern. Usage of sp_executesql vs direct execution of sql statement

This was posted in an internal discussion. The question was that it was observed that sometimes in...

Date: 07/12/2010

ObjectSet vs ObjectQuery in Entity Framework v 4

I was a little curious about this change in EFv4 and wanted to understand why this was done. So here...

Date: 07/06/2010

Displaying WCF Data Service data in local reports

Its been sometime that I have blogged. I recently got asked by one of my peers on how to display the...

Date: 11/20/2009

Referring ADO.Net Entity project in a different project

QuickPost: I just now answered a question on the forum about one of the errors that might take you a...

Date: 09/03/2009

Using EntityBag with EntityFramework over WCF

I was going through the article published in MSDN by Daniel Simmons about the N-Tier Patterns...

Date: 08/28/2009

TechEd@Hyderabad-Day2

Could not post the details yesterday coz I was tired attending many sessions. Here are the major...

Date: 05/15/2009

TechEd@Hyderabad-Day1

Today I attended TechED-09. Here are the updates from the sessions I attended and some of the...

Date: 05/13/2009

Getting Started With EntityClient in EntityFramework

In this post I am going to illustrate how to use EdmGen and EntityClient to program with Entity...

Date: 11/10/2008

Retrieving Identity or AutoGenerated Column in ADO.NET

I recently handled an issue where customer was facing difficulty in picking up the Auto Generated...

Date: 10/31/2008

Web Client Software Factory-The Web Patterns

This post is in continuance with the last post  I had on WCSF. In this post I will briefly...

Date: 09/06/2008

Web Client Software Factory-The Concept

In this series, I will help you get started with WCSF developed by Patterns and Practices team at...

Date: 09/06/2008

File IO System in .NET

I am preparing for MCTS Exam 70-536: Microsoft .NET Framework 2.0 - Application Development...

Date: 07/24/2008

Demystifying SQL-Oracle Distributed Query Issues

While running the following query distributed query select * from openrowset...

Date: 05/21/2008

C# 3.0 Features Basics For LINQ PART II

Continuing from part 1, here I will go one more step further and explain the language constructs...

Date: 03/22/2008

C# 3.0 Features Basics For LINQ - PART 1

The 'var' Keyword Type inferred at compile time Can only be defined within method scope Mostly used...

Date: 03/22/2008

SSIS Service fails with error "Access denied" at startup

Recently I got an issue where we were unable to start the SQL Server Integration Services(SSIS)...

Date: 03/06/2008

Indications that we are leaking connections

We get a lot of queries from developers around the following error while they are using ADO.NET...

Date: 03/02/2008

SSL in Microsoft SQL Server JDBC 1.2 driver

One of the major difference between Microsoft JDBC Driver 1.1 and Driver 1.2 is its feature for SSL....

Date: 02/03/2008

About Me

I work with the SQL Developer Support group in Microsoft. We handle issues that our customer's face...

Date: 10/12/2007