public void Concat() { IAlias person = sql.Alias("person"); IFunction func = SqlFn.Concat(person["Name"], person["SurName"]); QueryResult result = engine.Compile(func); Assert.Equal("CONCAT(\"person\".\"name\", \"person\".\"surname\")", result.Sql); Assert.Equal(new Dictionary <string, object>(), result.Parameters); }
public void Concat() { IAlias person = sql.Alias("person"); IFunction func = SqlFn.Concat(person["Name"], person["SurName"]); QueryResult result = engine.Compile(func); Assert.Equal("\"PERSON\".\"NAME\" || \"PERSON\".\"SURNAME\"", result.Sql); Assert.Equal(new Dictionary <string, object>(), result.Parameters); }
public void Concat_With_Or() { engine.AddFunction(FunctionName.Concat, FunctionHelper.ConcatOr); IAlias person = sql.Alias("person"); IFunction func = SqlFn.Concat(person["Name"], person["SurName"]); QueryResult result = engine.Compile(func); Assert.Equal("\"person\".\"Name\" || \"person\".\"SurName\"", result.Sql); Assert.Equal(new Dictionary <string, object>(), result.Parameters); }