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