public virtual async Task Crud_Update() { using (var tempTable = await DataTestHelpers.CreateAutoIncrementTable(DataProvider)) using (var queryResult = await DataProvider.ExecuteReaderAsync( new CompositeQueryExpression( QueryExpression.Insert( tempTable.TableName, new[] { "Data" }, new object[] { 1 } ), QueryExpression.Update( QueryExpression.Table(tempTable.TableName), QueryExpression.Compare(QueryExpression.Column("Id"), ComparisonOperator.AreEqual, QueryExpression.Value(1)), QueryExpression.Assign(QueryExpression.Column("Data"), QueryExpression.Value(5)) ), QueryExpression.Select( new[] { QueryExpression.Column("Data") }, from: QueryExpression.Table(tempTable.TableName), where : QueryExpression.Compare(QueryExpression.Column("Id"), ComparisonOperator.AreEqual, QueryExpression.Value(1)) ) ))) { Assert.IsTrue(queryResult.HasRows); Assert.IsTrue(await queryResult.ReadAsync()); Assert.AreEqual(5, queryResult.GetInt32(0)); } }
private IEnumerable <AssignColumnExpression> GetAssignColumnExpressions() { foreach (var fieldAssignment in _fieldAssignments) { yield return(QueryExpression.Assign(fieldAssignment.Column.ColumnName, fieldAssignment.ValueExpression)); } }