I am currently working on a migrating and older version of Microsoft Project server, Project Central 2000. The goal is to extract all the task with their assigned resources from the database. The data model seemed a bit confusing for… Read moreMigrate Microsoft Project Central 2000

I am so disappointed with TFS 2010. Ok, the new functions are really cool but NO tooling for migrating existing projects. Microsoft – what were you thinking? I suppose that it would be a little task for a TFS engineer… Read moreMigrating Projects to TFS 2010

The Microsoft unit testing framework comes with the MSTest.exe to run tests from command-line. This only works on machines that have Visual Studio installed. With some tweaks you can make it run on a computer without Visual Studio (see here)…. Read moreRun MSTests without Visual Studio 2008

Ok, validating an email address should not be difficult. You look up the definition in the RFC and write a little regular expression. Here is what I could extract from RFC 822: address        =  mailbox                      ; one addressee                  / … Read moreValidating Email Addresses

My favourite way to clean up database tables is with a little stored procedures that runs from an async database command. It is a bit old fashioned but LinqToSql does not have any built-in async support. I want avoid that… Read moreDataContext.Connection.ConnectionString – No Password

Here is a suggestion on how you easily can create integration tests when working with LINQ to SQL and the MSTest unit test framework. I use transactions to roll-back the changes made during the test run. The preparation of the… Read moreLINQ to SQL unit testing

I like working with unit tests but I find it quite hard to implement fast and isolated tests in real world software. I got some great guidance on this topic attending this years EMEA Tech Ed. Pass dependent classes via… Read moreDesign for testability

I used Linq first time in my life this week – wow! It creates some trouble for my brain to write lambda expressions but I am getting the hang of it. I noticed one odd thing so far. Using Linq… Read moreLinq NullReferenceException on foreign key