Sachin Rekhi's Ramblings : Data Generation
Tags: Data Generation

• Disabling triggers to support data generation
  

  Jamie Laflen, Tech Lead for database unit testing, has developed a code sample to show you how to automatically disable triggers to support data generation.

   

  The scenario is that you have delete or insert triggers defined on your database that inhibit proper test data generation. So this sample code will allow you to modify your database unit test setup such that before generating test data, the triggers will be disabled and then re-enabled after the data has been appropriately generated. This is an important scenario that customers have been running into when attempting to generate data for, say, the AdventureWorks database that has delete triggers defined.

   

  To use the sample code, replace your existing DatabaseSetup.cs in your test project with the code found below. You will have to update the namespace, etc. to be appropriate for your test project. The sample code uses SMO to determine what insert and delete triggers exist in your database and then appropriately disables them. Make sure you thus add the appropriate reference to SMO to your test project.

   

  //-----------------------------------------------------------------------

  //  This file is part of:

  //  Visual Studio Team Edition for Database Professionals

  //

  //  Copyright (C) Microsoft Corporation.  All rights reserved.

  //

  //  This source code is intended only as a supplement to Microsoft

  //  Development Tools and/or on-line documentation.  See these other

  //  materials for detailed information regarding Microsoft code samples.

  // 

  //  THIS CODE AND INFORMATION ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY

  //  KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE

  //  IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A

  //  PARTICULAR PURPOSE.

  //-----------------------------------------------------------------------

  using System;

  using System.Collections.Generic;

  using System.Data;

  using System.Data.Common;

  using System.Configuration;

  using System.Data.SqlClient;

  using System.Diagnostics;

  using Microsoft.VisualStudio.TestTools.UnitTesting;

  using Microsoft.VisualStudio.TeamSystem.Data.UnitTesting;

  using Microsoft.SqlServer.Management.Smo;

  using Microsoft.SqlServer.Management.Common;

   

  namespace TestProject1

  {

      [TestClass()]

      publicclass DatabaseSetup