Guerrilla SQL Server 2005 class

I happened to go to one of the class from a mentoring company. It was presented by Bob Beauchemin-Niels Berglund-Dan Sullivan. Boy! they were great! I was just in time for the ADO.Net presentation that Bob made. He talked about top 3 features that he liked in ADO.Net1. Provider Factory – He talked at great…

0

Notification Support in SqlClient Managed Provider

After a brief hiatus, let me start with blogging the new Notification support in SqlClient MP that is introduced in Whidbey. There are scenarios in which an application would store a cache of data obtain from a DB Server and then re-query from the same cache to save round-trips to the server (for better performance). Typically,…

5

Enumerating SQL Servers

Continuing with the discussion on enumeration, I will go over ways to enumerate active SQL servers on the network in this blog. Pre-Whidbey, to get list of active servers on the network, we could have done Inter-Op calls to server enumeration APIs in OleDb. If we wanted to write only managed code,we could have broad-casted…

8

Using Provider Factories

There are situation in real world; when you dont want to write code, dependent on just one of the managed provider. This also helps to easily move from using one provider to another if the code design changes in the future. Pre-Whidbey, the only way to do this was to write your own wrapper classes…

8

Provider Enumeration in Whidbey

I have been wanting to post for a long time now, and have finally decided to FIGHT my slackness. I will continue with my views on some of the new features in ADO.Net for Whidbey. I will start with talking about a new feature in Whidbey – Provider Enumeration. Pre-Whidbey there was no way to know…

3

Typed XML in ADO.Net v2.0

In the earlier sections, we have been looking at Untyped XML which are different from Typed XML. Typed XML data type is an XML defined with an associated xml schema in Sql Server 2005. You may ask if there is anything different on how Typed XML are exposed via ADO.Net 2.0. The answer is a heart-warming NO!. Typed…

0

XML Data type in ADO.Net v2.0 – Part II

In this section we will look at ways ADO.Net v2.0 (Code named ‘Whidbey’) allows us to insert/delete/update Xml data values in a table containing Xml column in SQL Server 2005 (Code named ‘Yukon’).  With earlier versions of the .Net Framework (1.0 and 1.1) the System.Data.SqlClient namespace will consume and emit XML as String values.Because of…

6

XML Data type in ADO.Net v2.0 – Part I

After a long hiatus, let me start with how the new XML data type in SQL Server 2005 is exposed via ADO.Net 2.0. I will discuss this new data type in following parts: XML data type in SQL Server 2005 – A brief Introduction : You can consider this as a crash course on XML…

8

Welcome!

Inspired by my colleagues here, I have taken into blogging. I had wanted to do it for a long time now. With the beta release 2.0 version of the Microsoft .Net framework (code named ‘Whidbey’), its a opportune moment to blog on some of the exciting features of ADO.Net ‘Whidbey’ that I know about. Welcome to my blog! Disclaimer:…

4