public void HashTest() { var builder1 = new Builder(this.ctx); builder1.SELECT("*").FROM("Foo").WHERE("Id", 1); var builder2 = new Builder(this.ctx); builder2.SELECT("*").FROM("Foo").WHERE("Id", 1); Assert.Equal(builder1.Hash, builder2.Hash); }
public void ParametersTest() { var builder = new Builder(this.ctx); builder.SELECT("*").FROM("Foo").WHERE("Id", 1); Assert.Equal(3, builder.Parameters.Count); Assert.Equal("["+this.ctx.DatabaseName+"].[dbo].[Foo]", ((SqlTable)builder.Parameters["@p0p"]).Value); Assert.Equal("[Id]", ((SqlId)builder.Parameters["@p1p"]).Value); Assert.Equal(1, builder.Parameters["@p2p"]); }
public void SqlTest() { var builder = new Builder(this.ctx); builder.SELECT("*").FROM("Foo").WHERE("Bar = 'Hello'"); var expected = new StringBuilder(); expected.AppendLine("SELECT * "); expected.AppendLine("FROM @p0p "); expected.Append("WHERE Bar = 'Hello' "); Assert.Equal(expected.ToString(), builder.Sql); }
public void _Test() { var builder = new Builder(this.ctx); builder .SELECT("Foo") ._("Bar") .FROM("Baz") .WHERE("Abc = '123'") ._("Xyz = '987'") ; var expected = new StringBuilder(); expected.AppendLine("SELECT Foo , Bar "); expected.AppendLine("FROM @p0p "); expected.Append("WHERE Abc = '123' AND Xyz = '987' "); Assert.Equal(expected.ToString(), builder.Sql); }
public void _IFTest() { var builder = new Builder(this.ctx); var abc = true; var xyz = false; builder .SELECT("*") .FROM("Baz") .WHERE() ._IF(abc, "Abc = '123'") ._IF(xyz, "Xyz = '987'") ; var expected = new StringBuilder(); expected.AppendLine("SELECT * "); expected.AppendLine("FROM @p0p "); expected.Append("WHERE Abc = '123' "); Assert.Equal(expected.ToString(), builder.Sql); }