コード例 #1
0
ファイル: MsSqlTestManager.cs プロジェクト: luchaoshuai/Aoite
        /// <summary>
        /// 执行与释放或重置托管资源相关的应用程序定义的任务。
        /// </summary>
        protected override void DisposeManaged()
        {
            using (var context = this.m_masterEngine.Context)
            {
                context.Open();
                context.ContextConnection.ChangeDatabase("master");
                context.Execute("ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE".Fmt(this.DatabaseName)).ToNonQuery().ThrowIfFailded();
                context.Execute("DROP DATABASE [{0}]".Fmt(this.DatabaseName)).ToNonQuery().ThrowIfFailded();
                context.Execute("DROP LOGIN [{0}]".Fmt(this.DbOwnerUser)).ToNonQuery().ThrowIfFailded();
                context.Execute("DROP LOGIN [{0}]".Fmt(this.ReadonlyUser)).ToNonQuery().ThrowIfFailded();
            }
            this.m_masterEngine = null;

            base.DisposeManaged();
        }
コード例 #2
0
ファイル: MsSqlTestManager.cs プロジェクト: luchaoshuai/Aoite
        /// <summary>
        /// 提供数据源连接字符串,初始化一个 <see cref="Aoite.Data.MsSqlTestManager"/> 类的新实例。
        /// </summary>
        /// <param name="connectionString">数据源连接字符串。</param>
        /// <param name="server">服务器地址。</param>
        public MsSqlTestManager(string connectionString, string server)
        {
            if (string.IsNullOrEmpty(connectionString))
            {
                throw new ArgumentNullException("connectionString");
            }
            if (string.IsNullOrEmpty(server))
            {
                throw new ArgumentNullException("server");
            }

            m_masterEngine = new MsSqlEngine(connectionString);
            var dbDire = GA.FullPath("_databases");

            GA.IO.CreateDirectory(dbDire);
            this.DatabaseName = Guid.NewGuid().ToString();
            this.DbOwnerUser  = Guid.NewGuid().ToString();
            this.ReadonlyUser = Guid.NewGuid().ToString();
            var sql = @"CREATE DATABASE [{0}]
 ON  PRIMARY ( NAME = N'{0}', FILENAME = N'{1}\{0}.mdf' , SIZE = 5120KB , FILEGROWTH = 1024KB )
 LOG ON ( NAME = N'{0}_log', FILENAME = N'{1}\{0}_log.ldf' , SIZE = 2048KB , FILEGROWTH = 10%)";

            using (var context = m_masterEngine.Context)
            {
                context.Open();
                context
                .Execute(sql.Fmt(this.DatabaseName, dbDire))
                .ToNonQuery()
                .ThrowIfFailded();
                CreateUser(this.DatabaseName, this.DbOwnerUser, false, context);
                CreateUser(this.DatabaseName, this.ReadonlyUser, true, context);
            }

            this.Manager = new DbEngineManager();
            this.Manager.Add(Db.NameWithDefualtEngine, this.Engine = new MsSqlEngine(server, this.DatabaseName, this.DbOwnerUser, "123456"));
            this.Manager.Add(Db.NameWithReadonlyEngine, new MsSqlEngine(server, this.DatabaseName, this.ReadonlyUser, "123456"));
        }