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