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