public void Creation() { Utilities.SQL.MicroORM.Command Object = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3); Assert.Equal("SELECT * FROM Table", Object.SQLCommand); Assert.Equal(CommandType.Text, Object.CommandType); Assert.Equal(4, Object.Parameters.Count); Assert.Contains(new Parameter <object>("0", (object)0), Object.Parameters); Assert.Contains(new Parameter <object>("1", 1), Object.Parameters); Assert.Contains(new Parameter <object>("2", 2), Object.Parameters); Assert.Contains(new Parameter <object>("3", 3), Object.Parameters); }
public void Creation() { Utilities.SQL.MicroORM.Command Object = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3); Assert.Equal("SELECT * FROM Table", Object.SQLCommand); Assert.Equal(CommandType.Text, Object.CommandType); Assert.Equal(4, Object.Parameters.Count); Assert.Contains(new Parameter<object>("0", (object)0), Object.Parameters); Assert.Contains(new Parameter<object>("1", 1), Object.Parameters); Assert.Contains(new Parameter<object>("2", 2), Object.Parameters); Assert.Contains(new Parameter<object>("3", 3), Object.Parameters); }
public void Equality() { Utilities.SQL.MicroORM.Command Object1 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3); Utilities.SQL.MicroORM.Command Object2 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3); Utilities.SQL.MicroORM.Command Object3 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2); Utilities.SQL.MicroORM.Command Object4 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1); Utilities.SQL.MicroORM.Command Object5 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0); Utilities.SQL.MicroORM.Command Object6 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text); Utilities.SQL.MicroORM.Command Object7 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.StoredProcedure, "@", 0, 1, 2, 3); Utilities.SQL.MicroORM.Command Object8 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table2", CommandType.Text, "@", 0, 1, 2, 3); Assert.Equal(Object1, Object2); Assert.NotEqual(Object1, Object3); Assert.NotEqual(Object1, Object4); Assert.NotEqual(Object1, Object5); Assert.NotEqual(Object1, Object6); Assert.NotEqual(Object1, Object7); Assert.NotEqual(Object1, Object8); }
public void Equality2() { Utilities.SQL.MicroORM.Command Object1 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 1, 1); Utilities.SQL.MicroORM.Command Object2 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 1, 2); Assert.NotEqual(Object1, Object2); }
public void SelectTest() { Utilities.SQL.MicroORM.Command BuiltCommand = Utilities.SQL.SQLCommand.Select("Test").Distinct().Where("Value1=@0", "@", "Test").Build(); Assert.Equal("SELECT DISTINCT * FROM Test WHERE Value1=@0", BuiltCommand.SQLCommand); Assert.Contains(new StringParameter("0", "Test"), BuiltCommand.Parameters); }