Data Dude: Could not load file or assembly System.Data.SqlServerCe, Version=


Hi You may get this error from Visual Studio, after successfully installing data dude GDR 1 or GDR 2, when you try to work with the dude (create new data dude project, for example). Could not load file or assembly 'System.Data.SqlServerCe, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Data dude GDR 1 & 2 require installation of Microsoft SQL Server Compact Edition 3.5 SP1 .This requirement is NOT documented in the GDR download page,And when you install the GDR without it, the installation succeeds, but the dude will raise this error when you try...
no comments

Flexible Dude for data compare


 Hi, In my previous post I offered a utility that makes data dude's schema compare output more flexible,especially when we try to run the script on a database at a customer's site.Now I'd like to modify the generated script from data compare, just a little bit. Data dude generated this INSERT TABLE statement:INSERT INTO . (, , , ) VALUES (8, 2, NULL, N'Hi') What if we have primary keys on FieldA and FieldB, and we already have one row containing those values? Here's my console application that generates the requested statements. This console application gets 2 arguments: First one is the name of...
no comments

Flexible Dude for schema compare


 Hi, One of the fantastic features in data dude (Visual studio team system data base edition, is the abilty to compare between schemas (by schema compare) and to generate sql script to modify the schema to be equal to the compared one. There's one issue: the script will work well as long we execute it on a database with the *exact* schema like the one we used  for the comparison.That's the way it works. Microsoft calls it "Declarative Database Development" approach. It means we should not mess with terrifying scenarios where we don't know for sure how the schema looks like...
one comment

Manage IIS virtual directories and application pools using C#


 Hi We can manage IIS using c# code, it's a good option to automate our modifications on the IIS servers. A great and inspiring code by Robbe Morris for that can be found here. Here's in brief - how to manage the IIS: using System.DirectoryServices; // of course ... How to connect IIS:DirectoryEntry iisServer = new DirectoryEntry("IIS://" + myServerName + "/W3SVC/1");   How to manage virtual directories: Get root of virtual directories (the web site):DirectoryEntry folderRoot = iisServer.Children.Find("Root", "IIsWebVirtualDir"); Locate a virtual dir under it:DirectoryEntry myVirDir = folderRoot.Children.Find(myVirtualDirectoryName, "IIsWebVirtualDir"); or create it: folderRoot.Children.Add(myVirtualDirectoryName, "IIsWebVirtualDir"); Set the virtual directory path:myVirDir.Properties.Insert(0, realPath); Set Windows authentication:myVirDir.Properties =true; Set Anonymous access:myVirDir.Properties = true;myVirDir.Properties...
tags: , ,

Hi everyone


 Hi everyone, welcome to my new blog.My name is Dan Morgenstern, a senior consultant in SRL Team. With this blog I'll share with you insights, tips & guidance regarding to Team system world & development .Hope you'll enjoy it as I will.Dan Morgenstern