Search results matching tags 'SQL Server 2008' and 'Visual Studio 2008'

.NET 3.5 Summer Class was... awesome!

Dennis van der Stelt — Mon, 17 Sep 2007 14:07:21 GMT

The weekend-after has passed and I've slept through most of it. Man did we use up some hours (some nights we went on with the training until 23:00 hours) and especially the last night when we drank past the bar its closing hours and went on in a local pub in Domburg!

But of course it wasn't about partying, but about .NET 3.5. And I really think we discussed everything there is in .NET 3.5 and even more. On the last day, we discussed Silverlight and the Entity Framework even.

The evaluations were great, with most of them replying that it was so much. But as expected, still one step ahead. Both students and us still need to think about how we are going to write our software in the future, especially when you start to realize that LINQ and the other new features is so much more then just querying a database.

Thing is, we at Class-A had a great time organizing it, preparing for it and finally presenting it. I know the students had a great time and I really hope they get the opportunity to use .NET 3.5 in their daily lives.

This week it's up to Mike, Anko and Astrid and their Business Intelligence Summer Class, going through everything that's SQL Server and accompanying products.

System.Transactions still not working

Dennis van der Stelt — Thu, 28 Jun 2007 13:25:00 GMT

UPDATE : It seems the SQL team actually have build a solution.

A while ago I wrote some articles on System.Transactions and the fact that it's almost impossible to use the Lightweight Transaction Manager (LTM) and not get bumped up to a distributed transaction and use MSDTC.

When you look at the sourcecode it's easy to see what's happening

Open a connection to MyServer with using keyword
Execute an insert statement to TestTable
Close using, but the connection stays open in the background to reply to ready-to-commit question.
Open a new connection to MyServer with using keyword
We're already using a distributed transaction

string ConnectionString = @"Data Source=MyServer;Initial Catalog=Test;Integrated Security=SSPi;";

using (TransactionScope scope = new TransactionScope())

{

using (SqlConnection conn1 = new SqlConnection(ConnectionString))

{

SqlCommand cmd1 = new SqlCommand("insert into TestTable([value]) Values ('This creates a new row')", conn1);

conn1.Open();

cmd1.ExecuteNonQuery();

Console.WriteLine("DistributedID : {0}", System.Transactions.Transaction.Current.TransactionInformation.DistributedIdentifier);

}

using (SqlConnection conn2 = new SqlConnection(ConnectionString))

{

SqlCommand cmd2 = new SqlCommand("insert into TestTable([value]) Values ('This creates a new row')", conn2);

conn2.Open(); // Promotion to MSDTC occurs!

cmd2.ExecuteNonQuery();

Console.WriteLine("DistributedID : {0}", System.Transactions.Transaction.Current.TransactionInformation.DistributedIdentifier);

}

When you look at this thread on MSDN Forums, Pablo Castro said that it's a server-side (SQL Server) fix. Florin Lazar replies that this issue will likely not be addressed in Visual Studio Orcas (VS2008 by now).

Florin is right, it still doesn't work in Visual Studio 2008.
Even worse, it's also not addressed in SQL Server 2008.

Update : Or is this the solution we've been waiting for?

So my question is, when is Microsoft going to address this issue?! When will System.Transactions work like it's supposed to?

Technorati tags: Visual Studio 2008, Orcas, SQL Server 2008, SQL Server 2005, SQL Server, Transactions

Visual Studio 2008, VS2008 Shell and SQL Server 2008

Dennis van der Stelt — Tue, 05 Jun 2007 07:51:05 GMT

At MIX07 new stuff was announced, at TechEd 2007 in Orlando names of products have been announced.

Visual Studio 2008
"Orcas" has been renamed to Visual Studio 2008. It's a bit strange so few people have yet to blog about it, the only real reference I could find was at Darryl Burling's weblog. I started searching after reading Daniel Moth's weblog.
Visual Studio 2008 Shell
This info has also been released at TechEd. From what I understand, you can integrate the VS2008 shell into your own application, enabling it the advanced IDE features that VS2008 offers you. Read more at the VS2008 Shell weblog.
SQL Server 2008
Yes, "Katmai" also got its final name. Read more at the SQL website.

According to Daryll Burling these names have nothing to do with the year, but more about the financial year these products will be released. As far as I'm know, the financial year of 2008 begins before the calendar year of 2008. Meaning VS2008 might be released in 2007, but SQL Server 2008 can't be released at the end of the year 2008. We'll see! :)

Technorati tags: Visual Studio 2008, Orcas, SQL Server 2008, Katmai, TechEd