/// <summary>
/// Specifies the target table to update.
/// </summary>
/// <param name="dbUpdateQuery">The target <see cref="DbUpdateQuery"/></param>
/// <param name="targetSelector">A <see cref="Func{T,TResult}"/> used to
/// specify the <see cref="DbExpression"/> that represents the target table or view.</param>
/// <returns><see cref="DbUpdateQuery"/></returns>
public static DbUpdateQuery Update(this DbUpdateQuery dbUpdateQuery, Func <DbExpressionFactory, DbExpression> targetSelector)
{
return(Update(dbUpdateQuery, targetSelector(DbExpressionFactory)));
}
/// <summary>
/// Specifies the target table to update.
/// </summary>
/// <param name="dbUpdateQuery">The target <see cref="DbUpdateQuery"/></param>
/// <param name="target">The <see cref="DbExpression"/> that represents the target table or view.</param>
/// <returns><see cref="DbUpdateQuery"/></returns>
public static DbUpdateQuery Update(this DbUpdateQuery dbUpdateQuery, DbExpression target)
{
dbUpdateQuery.QueryExpression.Target = target;
return(dbUpdateQuery);
}
public void ShouldTranslateUpdateExpressionWithAliasedTarget()
{
if (GetType() == typeof(SQLiteExpressionSyntaxTests))
return;
var dbUpdateQuery = new DbUpdateQuery();
var expression = dbUpdateQuery.Update(e => e.Table("SomeTable", "t0"))
.Set(e => e.Column("SomeColumn"), 1)
.Where(e => e.Column("SomeColumn") == e.Constant(2));
var result = QueryTranslator.Translate(expression);
Assert.AreEqual(UpdateExpressionWithAliasedTargetSyntax.Clean(), result.Sql.Clean());
}
public void ShouldTranslateUpdateExpressionWithFromClause()
{
if (GetType() == typeof(SQLiteExpressionSyntaxTests))
return;
var dbUpdateQuery = new DbUpdateQuery();
var expression = dbUpdateQuery.Update(e => e.Table("SomeTable", "t0"))
.Set(e => e.Column("SomeColumn"), 1)
.From(e => e.Table("SomeTable", "t0")).InnerJoin(e => e.Table("SomeOtherTable","t1"), e=> e.Column("t0","Id") == e.Column("t1","Id"))
.Where(e => e.Column("t0","SomeColumn") == e.Constant(2));
var result = QueryTranslator.Translate(expression);
Assert.AreEqual(UpdateExpressionWithFromClauseSyntax.Clean(), result.Sql.Clean());
}
public void ShouldTranslateUpdateExpression()
{
var dbUpdateQuery = new DbUpdateQuery();
var expression = dbUpdateQuery.Update(e => e.Table("SomeTable"))
.Set(e => e.Column("SomeColumn"), 1)
.Where(e => e.Column("SomeColumn") == e.Constant(2));
var result = QueryTranslator.Translate(expression);
Assert.AreEqual(UpdateExpressionSyntax.Clean(), result.Sql.Clean());
}
