Welcome to MSDN Blogs Sign in | Join | Help

July 2004 - Posts

Tuesday, July 27, 2004 7:17 PM

Setting the IsolationLevel using the System.Transactions TransactionScope.

Traditionally distributed transactions have always run in Serializable isolation level, the safest but most expensive transaction isolation level where everything that we look at is locked from the moment we modify something and until the distributed
Posted by angelsb | 2 Comments
Tuesday, July 27, 2004 4:29 PM

Format=UserDefined UDTs in Sql Server 2005

Today I am talking about Format=UserDefined User Defined Types (UDTs). Format=Native UDTs are leaner, meaner and faster but only support blittable types as fields (no Strings!). UserDefined UDTs support any field type since they require the user to implement
Posted by angelsb | 2 Comments
Monday, July 26, 2004 6:49 PM

Getting started with Sql Server 2005 User Defined Types (UDTs)

I have really tried to start with the simplest possible UDT I could come up with. As you can see, the simplest UDT is still quite a handful, and this is still not a complete example. using System; using System.Data.Sql; // Required by SqlUserDefinedType
Posted by angelsb | 7 Comments
Thursday, July 22, 2004 11:19 AM

Whidbey ADO.NET 2.0 User Defined Types (UDTs) and Visual Studio

User Defined Types are a complicated feature, but it is hard to tell when you are using Visual Studio. All you need to do is create a Database project, connect to a Sql Server 2005 server, add a User Defined Type to your project and then click on Deploy.
Posted by angelsb | 4 Comments
Tuesday, July 20, 2004 5:12 PM

Whidbey ADO.NET 2.0 User Defined Types (UDTs) with Sql Server 2005

You can now create your own objects in managed code and install them into Sql Server 2005 as data types! I am going to spend the next week blogging about the new Sql Server 2005 User Defined Types (UDTs). This is a very powerful feature that allows you
Posted by angelsb | 4 Comments
Thursday, July 15, 2004 2:11 PM

Whidbey ADO.NET 2.0. Thoughts on how some new features can be misused.

There are a number of new features in ADO.NET 2.0 that have the _ potential to be grossly misused _ ™. Don’t get me wrong, I like the features, some of them are good and some are extremely good. The reason that I am bringing them up is because
Posted by angelsb | 4 Comments
Thursday, July 15, 2004 10:40 AM

ADO.NET Distributed transactions, loose ends.

There is still a lot of information related to using ADO.NET with System.Transactions Distributed Transactions, but in the interest of keeping the blog moving I am going to roll up most of the issues into this final post. Feel free to post questions if
Posted by angelsb | 4 Comments
Monday, July 12, 2004 8:45 PM

Whidbey ADO.NET Promotable Transactions with System.Transactions & Yukon

There is a special partnership between System.Transactions and Sql Server 2005, and no, it is not the fact that we begged the Enterprise Services team to ship this feature on whidbey and it is not (only) the fact that this is the only way to get distributed
Posted by angelsb | 23 Comments
Monday, July 12, 2004 12:20 PM

Whidbey ado.net 2.0 Manually enlisting into System.Transaction distributed transaction.

I have gone over the TransactionScope in fair detail, it is now time to look at manual enlistment, the second way to use System.Transactions Distributed Transactions with ADO.NET. Unlike the TransactionScope example wich was complete and bullet proof
Posted by angelsb | 0 Comments
Monday, July 12, 2004 10:28 AM

More setup information, straight from the source

Florin Lazar was the person that first introduced me to System.Transactions, he has a great weblog here: http://blogs.msdn.com/florinlazar/ That is full of information on how to set up your computer to use distributed transactions and really great links
Posted by angelsb | 3 Comments
Wednesday, July 07, 2004 11:47 AM

Whidbey ADO.NET 2.0 System.Transactions Distributed Transactions. TransactionScope

Let’s take a look at how the new System.Transactions Distributed Transactions work with ADO.NET 2.0. I am going to start with the best and easiest way to use distributed transactions in managed code, the TransactionScope. The following code is (or
Posted by angelsb | 11 Comments
Tuesday, July 06, 2004 11:39 AM

Whidbey ADO.NET System.Transactions Distributed Transactions

This is imo one of the best new features for ADO.NET imo and I was glad to get some feedback that expressed interest. I will blog on this feature for the rest of the week, here is how to get started. The hardest thing about this feature is without a doubt
Posted by angelsb | 14 Comments
Friday, July 02, 2004 7:31 PM

Whidbey ADO.NET beta 1 has shipped. Favorite features

Well, we have shipped whidbey beta 1. This is a great release for the ado.net team, we have managed to not break away from an existing data model while adding great new features. Everything you have will continue working as is, we have fixed old problems
Posted by angelsb | 9 Comments
Friday, July 02, 2004 3:02 PM

Welcome to this ADO.NET log, feel free to pull up a chair

Random ramblings, thats what it is all about. If you like ADO.NET just a little too much (and I am not pointing fingers here), if you can read way too long paragraphs of badly separated sentences (I have no delusions about my literary abilities) and can
Posted by angelsb | 3 Comments
 
Page view tracker