C# (CSharp) BatchQuery.GetCommand示例

示例#1

文件： BatchTests.cs 项目： andrecarlucci/SubSonic-3.0

        public void Batch_Should_Build_Batched_SQL_With_Replaced_Command_Parameters()
        {
            BatchQuery qry = new BatchQuery(provider);
            qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(1));
            qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(2));
            qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(3));
            QueryCommand cmd = qry.GetCommand();

            Assert.Equal("@0", cmd.Parameters[0].ParameterName);
            Assert.Equal("@1", cmd.Parameters[1].ParameterName);
            Assert.Equal("@2", cmd.Parameters[2].ParameterName);
        }

示例#2

文件： BatchTests.cs 项目： npg-opsdev/SubSonic-3.0

        public void Batch_Should_Build_Batched_SQL_With_Replaced_Command_Parameters()
        {
            BatchQuery qry = new BatchQuery(provider);

            qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(1));
            qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(2));
            qry.Queue(new Select(provider).From("Products").Where("ProductID").IsEqualTo(3));
            QueryCommand cmd = qry.GetCommand();

            Assert.Equal("@0", cmd.Parameters[0].ParameterName);
            Assert.Equal("@1", cmd.Parameters[1].ParameterName);
            Assert.Equal("@2", cmd.Parameters[2].ParameterName);
        }