C# (CSharp) DbUnicorn SqlServerBatch示例

示例#1

文件： SqlServerDatabaseServer.cs 项目： kenny-evitt/DB-Unicorn

        public IDatabase CreateDatabase(string databaseName)
        {
            SqlServerBatch batch =
                new SqlServerBatch(
                    String.Format(
                        @"CREATE DATABASE {0};",
                        TransactSqlHelpers.Identifiers.ValidIdentifier(databaseName)));

            _masterDatabase.ExecuteSqlBatch(batch);

            Exception lastBatchExecutionException = batch.Executions.Last().Exception;

            if (lastBatchExecutionException != null)
                throw new ApplicationException("Database creation failed.", lastBatchExecutionException);

            return new SqlServerDatabase(this.ConnectionString(databaseName));
        }

示例#2

        public IDatabase CreateDatabase(string databaseName)
        {
            SqlServerBatch batch =
                new SqlServerBatch(
                    String.Format(
                        @"CREATE DATABASE {0};",
                        TransactSqlHelpers.Identifiers.ValidIdentifier(databaseName)));

            _masterDatabase.ExecuteSqlBatch(batch);

            Exception lastBatchExecutionException = batch.Executions.Last().Exception;

            if (lastBatchExecutionException != null)
            {
                throw new ApplicationException("Database creation failed.", lastBatchExecutionException);
            }

            return(new SqlServerDatabase(this.ConnectionString(databaseName)));
        }