Exemplos de UnitTests.ORM.Parameters BetweenParameter em C# (CSharp)

Exemplo n.º 1

Arquivo: BetweenParameter.cs Projeto: JaCraig/Craig-s-Utility-Library

 public void Creation()
 {
     var TestObject = new BetweenParameter<int>(10, 12, "ID");
     Assert.Equal("ID", TestObject.ID);
     Assert.Equal(10, TestObject.Min);
     Assert.Equal(12, TestObject.Max);
     Assert.Equal("@", TestObject.ParameterStarter);
     Assert.Equal("ID BETWEEN @IDMin AND @IDMax", TestObject.ToString());
     Assert.Equal(DbType.Int32, TestObject.DatabaseType);
     Assert.Equal(ParameterDirection.Input, TestObject.Direction);
     var Batch = new Utilities.ORM.Manager.QueryProvider.Manager(Utilities.IoC.Manager.Bootstrapper.ResolveAll<IQueryProvider>()).Batch(TestDatabaseSource);
     Batch.AddCommand(null, null, "SELECT * FROM TestTable", CommandType.Text, TestObject).Execute();
 }

Exemplo n.º 2

        public void Creation()
        {
            var TestObject = new BetweenParameter <int>(10, 12, "ID");

            Assert.Equal("ID", TestObject.ID);
            Assert.Equal(10, TestObject.Min);
            Assert.Equal(12, TestObject.Max);
            Assert.Equal("@", TestObject.ParameterStarter);
            Assert.Equal("ID BETWEEN @IDMin AND @IDMax", TestObject.ToString());
            Assert.Equal(DbType.Int32, TestObject.DatabaseType);
            Assert.Equal(ParameterDirection.Input, TestObject.Direction);
            var Batch = new Utilities.ORM.Manager.QueryProvider.Manager(Utilities.IoC.Manager.Bootstrapper.ResolveAll <IQueryProvider>()).Batch(TestDatabaseSource);

            Batch.AddCommand(null, null, "SELECT * FROM TestTable", CommandType.Text, TestObject).Execute();
        }