/// <summary>
/// Converts the query expression.
/// </summary>
/// <returns>The query expression.</returns>
protected virtual QueryExpression ConvertQueryExpression()
{
var query1 = _expression1.ConvertQueryExpression();
var query2 = _expression2.ConvertQueryExpression();
return(QueryExpression.Concat(query1, _operatorType, query2));
}
public void Can_Write_Concat_Function()
{
var queryExpression = QueryExpression.Select(
new[] { QueryExpression.Concat(QueryExpression.Column("Column1"), QueryExpression.Column("Column2")) }
);
var sql = TestHelpers.ConvertToSql(queryExpression);
Assert.AreEqual("SELECT CONCAT([Column1], [Column2]);", sql);
}
public virtual async Task Concat_SelectStrings()
{
using (var queryResult = await DataProvider.ExecuteReaderAsync(
QueryExpression.Select(QueryExpression.Concat(
QueryExpression.Value("Hello"), QueryExpression.Value(" "), QueryExpression.Value("World")
))
))
{
Assert.IsTrue(queryResult.HasRows);
Assert.IsTrue(await queryResult.ReadAsync());
Assert.AreEqual("Hello World", queryResult.GetString(0));
}
}
public void Can_Select_Concat_Values()
{
using (var dataProvider = Sqlite3DataProvider.InMemory())
{
using (var queryResult = dataProvider.ExecuteReader(QueryExpression.Select(
projection: new[] { QueryExpression.Concat(
QueryExpression.Value("Hello"),
QueryExpression.Value(" "),
QueryExpression.Value("World")
) }
)))
{
Assert.IsTrue(queryResult.HasRows);
Assert.IsTrue(queryResult.Read());
Assert.AreEqual("Hello World", queryResult.GetString(0));
}
}
}