Esempi in C# (CSharp) per BatchQuery.GetCommand

Esempio n. 1

File: BatchTests.cs Progetto: 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);
        }

Esempio n. 2

File: BatchTests.cs Progetto: 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);
        }