当前位置: 首页>>代码示例>>C#>>正文


C# Execute.PerformDBOperationExpression类代码示例

本文整理汇总了C#中FluentMigrator.Builders.Execute.PerformDBOperationExpression的典型用法代码示例。如果您正苦于以下问题:C# PerformDBOperationExpression类的具体用法?C# PerformDBOperationExpression怎么用?C# PerformDBOperationExpression使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。


PerformDBOperationExpression类属于FluentMigrator.Builders.Execute命名空间,在下文中一共展示了PerformDBOperationExpression类的12个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: CanCreateAndDeleteTableUsingThePerformDBOperationExpressions

        public void CanCreateAndDeleteTableUsingThePerformDBOperationExpressions()
        {
            var expression = new PerformDBOperationExpression
            {
                Operation = (connection, transaction) =>
                {
                    // I know I could be using the expressions to create and delete this table,
                    // but really I just want to test whether I can execute some commands against the connection.

                    var command = connection.CreateCommand();
                    command.Transaction = transaction;
                    command.CommandText = "CREATE TABLE dbo.TestTable(TestTableID int NULL)";

                    command.ExecuteNonQuery();

                    var command2 = connection.CreateCommand();
                    command2.Transaction = transaction;
                    command2.CommandText = "DROP TABLE dbo.TestTable";

                    command2.ExecuteNonQuery();
                }
            };

            ExecuteWithSqlServer(processor => processor.Process(expression), IntegrationTestOptions.SqlServer);
        }
开发者ID:paulbatum,项目名称:fluentmigrator,代码行数:25,代码来源:PerformDBOperationTests.cs

示例2: Process

        public override void Process(PerformDBOperationExpression expression)
        {
            if (Connection.State != ConnectionState.Open) Connection.Open();

            if (expression.Operation != null)
                expression.Operation(Connection, null);
        }
开发者ID:timscott,项目名称:fluentmigrator,代码行数:7,代码来源:JetProcessor.cs

示例3: Process

        public override void Process(PerformDBOperationExpression expression)
        {
            Announcer.Say("Performing DB Operation");

            if (Options.PreviewOnly)
                return;

            if (Connection.State != ConnectionState.Open) Connection.Open();

            if (expression.Operation != null)
                expression.Operation(Connection, null);
        }
开发者ID:hazzik,项目名称:fluentmigrator,代码行数:12,代码来源:JetProcessor.cs

示例4: Process

        public override void Process(PerformDBOperationExpression expression)
        {
            Announcer.Say("Performing DB Operation");

            if (Options.PreviewOnly)
                return;

            EnsureConnectionIsOpen();

            if (expression.Operation != null)
                expression.Operation(Connection, Transaction);
        }
开发者ID:kevin3274,项目名称:fluentmigrator,代码行数:12,代码来源:PostgresProcessor.cs

示例5: CallingProcessWithPerformDBOperationExpressionWhenInPreviewOnlyModeWillNotMakeDbChanges

        public void CallingProcessWithPerformDBOperationExpressionWhenInPreviewOnlyModeWillNotMakeDbChanges()
        {
            var output = new StringWriter();

            var connection = new SQLiteConnection(IntegrationTestOptions.SqlLite.ConnectionString);

            var processor = new SqliteProcessor(
                connection,
                new SqliteGenerator(),
                new TextWriterAnnouncer(output),
                new ProcessorOptions { PreviewOnly = true },
                new SqliteDbFactory());

            bool tableExists;

            try
            {
                var expression =
                    new PerformDBOperationExpression
                    {
                        Operation = (con, trans) =>
                        {
                            var command = con.CreateCommand();
                            command.CommandText = "CREATE TABLE ProcessTestTable (test int NULL) ";
                            command.Transaction = trans;

                            command.ExecuteNonQuery();
                        }
                    };

                processor.Process(expression);

                tableExists = processor.TableExists("", "ProcessTestTable");
            }
            finally
            {
                processor.RollbackTransaction();

            }

            tableExists.ShouldBeFalse();

            output.ToString().ShouldBe(
            @"/* Performing DB Operation */
            ");
        }
开发者ID:hazzik,项目名称:fluentmigrator,代码行数:46,代码来源:SqliteProcessorTests.cs

示例6: CallingProcessWithPerformDBOperationExpressionWhenInPreviewOnlyModeWillNotMakeDbChanges

        public void CallingProcessWithPerformDBOperationExpressionWhenInPreviewOnlyModeWillNotMakeDbChanges()
        {
            var output = new StringWriter();

            var connection = new MySqlConnection(IntegrationTestOptions.MySql.ConnectionString);

            var processor = SetupMySqlProcessorWithPreviewOnly(output, connection);

            bool tableExists;

            try
            {
                var expression =
                    new PerformDBOperationExpression
                    {
                        Operation = (con, trans) =>
                        {
                            var command = con.CreateCommand();
                            command.CommandText = "CREATE TABLE processtesttable (test int NULL) ";
                            command.Transaction = trans;

                            command.ExecuteNonQuery();
                        }
                    };

                processor.Process(expression);

                var com = connection.CreateCommand();
                com.CommandText = "";

                tableExists = processor.TableExists("", "processtesttable");
            }
            finally
            {
                processor.RollbackTransaction();
            }

            tableExists.ShouldBeFalse();
        }
开发者ID:kevin3274,项目名称:fluentmigrator,代码行数:39,代码来源:MySqlProcessorTests.cs

示例7: Process

        public override void Process(PerformDBOperationExpression expression)
        {
            EnsureConnectionIsOpen();

            if (expression.Operation != null)
                expression.Operation(Connection, Transaction);
        }
开发者ID:concept-hf,项目名称:fluentmigrator,代码行数:7,代码来源:SqlServerCeProcessor.cs

示例8: Process

 public abstract void Process(PerformDBOperationExpression expression);
开发者ID:Ang3lFir3,项目名称:fluentmigrator,代码行数:1,代码来源:ProcessorBase.cs

示例9: Process

 public virtual void Process(PerformDBOperationExpression expression)
 {
     Processor.Process(expression);
 }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:4,代码来源:SqlServerSchemaDumper.cs

示例10: WithConnection

 public void WithConnection(Action<IDbConnection, IDbTransaction> operation)
 {
     var expression = new PerformDBOperationExpression { Operation = operation };
     _context.Expressions.Add(expression);
 }
开发者ID:zendever,项目名称:fluentmigrator,代码行数:5,代码来源:ExecuteExpressionRoot.cs

示例11: Process

 public override void Process(PerformDBOperationExpression expression)
 {
     throw new NotImplementedException();
 }
开发者ID:bjoern-sma,项目名称:fluentmigrator,代码行数:4,代码来源:OracleProcessor.cs

示例12: ErrorIsReturnedWhenOperationIsNull

 public void ErrorIsReturnedWhenOperationIsNull()
 {
     var expression = new PerformDBOperationExpression() { Operation = null };
     var errors = ValidationHelper.CollectErrors(expression);
     errors.ShouldContain(ErrorMessages.OperationCannotBeNull);
 }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:6,代码来源:PerformDBOperationExpressionTests.cs


注:本文中的FluentMigrator.Builders.Execute.PerformDBOperationExpression类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。