C# (CSharp) Utilities.ORM.Manager.QueryProvider.Manager.AddCommand Exemples

Exemple #1

Fichier : AndParameter.cs Projet : modulexcite/Craig-s-Utility-Library

 public void Creation()
 {
     var TestObject = new Utilities.ORM.Parameters.AndParameter(new EqualParameter<int>(1, "Left"), new EqualParameter<int>(2, "Right"));
     Assert.Equal("(Left=@Left AND Right=@Right)", TestObject.ToString());
     IBatch 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();
 }

Exemple #2

Fichier : AndParameter.cs Projet : terrydash/Craig-s-Utility-Library

        public void Creation()
        {
            var TestObject = new Utilities.ORM.Parameters.AndParameter(new EqualParameter <int>(1, "Left"), new EqualParameter <int>(2, "Right"));

            Assert.Equal("(Left=@Left AND Right=@Right)", TestObject.ToString());
            IBatch 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();
        }

Exemple #3

Fichier : BetweenParameter.cs Projet : 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();
 }

Exemple #4

Fichier : NotEqualParameter.cs Projet : modulexcite/Craig-s-Utility-Library

 public void Creation()
 {
     var TestObject = new NotEqualParameter<int>(12, "ID");
     Assert.Equal("ID", TestObject.ID);
     Assert.Equal(12, TestObject.Value);
     Assert.Equal("@", TestObject.ParameterStarter);
     Assert.Equal("ID<>@ID", TestObject.ToString());
     Assert.Equal(DbType.Int32, TestObject.DatabaseType);
     Assert.Equal(ParameterDirection.Input, TestObject.Direction);
     Assert.Equal("ID", TestObject.FieldName);
     Assert.Equal(12, TestObject.InternalValue);
     IBatch 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();
 }

Exemple #5

        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();
        }

Exemple #6

Fichier : LikeParameter.cs Projet : JaCraig/Craig-s-Utility-Library

 public void Creation()
 {
     var TestObject = new Utilities.ORM.Parameters.LikeParameter("ASDF", "ID", 100);
     Assert.Equal("ID", TestObject.ID);
     Assert.Equal("ASDF", TestObject.Value);
     Assert.Equal("@", TestObject.ParameterStarter);
     Assert.Equal("ID LIKE @ID", TestObject.ToString());
     Assert.Equal(100, TestObject.Length);
     Assert.Equal(DbType.String, TestObject.DatabaseType);
     Assert.Equal(ParameterDirection.Input, TestObject.Direction);
     Assert.Equal("ID", TestObject.FieldName);
     Assert.Equal("ASDF", TestObject.InternalValue);
     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();
 }

Exemple #7

Fichier : NotEqualParameter.cs Projet : terrydash/Craig-s-Utility-Library

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

            Assert.Equal("ID", TestObject.ID);
            Assert.Equal(12, TestObject.Value);
            Assert.Equal("@", TestObject.ParameterStarter);
            Assert.Equal("ID<>@ID", TestObject.ToString());
            Assert.Equal(DbType.Int32, TestObject.DatabaseType);
            Assert.Equal(ParameterDirection.Input, TestObject.Direction);
            Assert.Equal("ID", TestObject.FieldName);
            Assert.Equal(12, TestObject.InternalValue);
            IBatch 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();
        }

Exemple #8

Fichier : LikeParameter.cs Projet : wagnerhsu/nuget-Craig-s-Utility-Library

        public void Creation()
        {
            var TestObject = new Utilities.ORM.Parameters.LikeParameter("ASDF", "ID", 100);

            Assert.Equal("ID", TestObject.ID);
            Assert.Equal("ASDF", TestObject.Value);
            Assert.Equal("@", TestObject.ParameterStarter);
            Assert.Equal("ID LIKE @ID", TestObject.ToString());
            Assert.Equal(100, TestObject.Length);
            Assert.Equal(DbType.String, TestObject.DatabaseType);
            Assert.Equal(ParameterDirection.Input, TestObject.Direction);
            Assert.Equal("ID", TestObject.FieldName);
            Assert.Equal("ASDF", TestObject.InternalValue);
            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();
        }