コード例 #1
0
        public void Try_Create_Bacpac()
        {
            var dbName            = "BacpacTestDb";
            var resultingFilePath = "NsagaCreated.bacpac";

            try
            {
                // Arrange
                SqlHelpers.ExecuteSql(ConnectionString, $"Create database {dbName}");
                var sql = $@"use {dbName}
                GO
                create table [{dbName}].[dbo].[Table1] (id int null, name nvarchar(max) null);
                Go
                insert into [{dbName}].[dbo].[Table1] (id, name) values (42, 'Ultimate Question of Life');
                Go";
                context.ExecuteSqlCommand(ConnectionString, sql);

                // Act
                SqlBacpacImpl.CreateBacpacFile(context, ConnectionString, dbName, resultingFilePath);

                // Assert
                File.Exists(resultingFilePath).Should().BeTrue();
            }
            finally
            {
                SqlHelpers.DropDatabase(ConnectionString, dbName);
                File.Delete(resultingFilePath);
            }
        }
コード例 #2
0
 public void Try_Restore_Bacpac()
 {
     try
     {
         SqlBacpacImpl.RestoreBacpac(context, ConnectionString, "NSaga", GetBacpacFilePath());
         SqlHelpers.DbExists(ConnectionString, "Nsaga").Should().BeTrue();
     }
     finally
     {
         SqlHelpers.DropDatabase(ConnectionString, "Nsaga");
     }
 }