public static void DeleteSnapshot()
        {
            StructuremapMvc.End();

            var contextDB = new MainModuleContext();
            contextDB.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, @"
                USE master
                DROP DATABASE SigcomtDB_Snap;
            ");
        }
        public static void GenerarSnapShotDB(TestContext testContext)
        {
            Database.SetInitializer<MainModuleContext>(null);
            PersistenceConfigurator.Configure("SIGCOMT");

            StructuremapMvc.Start();

            var contextDB = new MainModuleContext();
            contextDB.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, @"
                IF DB_ID('SigcomtDB_Snap') IS NOT NULL
                    DROP DATABASE SigcomtDB_Snap;

                CREATE DATABASE SigcomtDB_Snap ON
                    ( NAME = SigcomtDB, FILENAME = 'D:\Temp\SigcomtDB_Snapshot.ss' )
                 AS SNAPSHOT OF SigcomtDB;
            ");
        }