protected override Expression VisitInsert(DbInsertExpression insert)
{
this.Write("INSERT INTO ");
this.WriteTableName(insert.Table.Name);
this.Write("(");
for (int i = 0, n = insert.Assignments.Count; i < n; i++)
{
DbColumnAssignment ca = insert.Assignments[i];
if (i > 0)
{
this.Write(", ");
}
this.Write(ca.Column.Name);
}
this.Write(")");
this.WriteLine(Indentation.Same);
this.Write("VALUES (");
for (int i = 0, n = insert.Assignments.Count; i < n; i++)
{
DbColumnAssignment ca = insert.Assignments[i];
if (i > 0)
{
this.Write(", ");
}
this.Visit(ca.Expression);
}
this.Write(")");
return(insert);
}
protected override Expression VisitUpdate(DbUpdateExpression update)
{
this.Write("UPDATE ");
this.WriteTableName(update.Table.Name);
this.WriteLine(Indentation.Same);
bool saveHide = this.HideColumnAliases;
this.HideColumnAliases = true;
this.Write("SET ");
for (int i = 0, n = update.Assignments.Count; i < n; i++)
{
DbColumnAssignment ca = update.Assignments[i];
if (i > 0)
{
this.Write(", ");
}
this.Visit(ca.Column);
this.Write(" = ");
this.Visit(ca.Expression);
}
if (update.Where != null)
{
this.WriteLine(Indentation.Same);
this.Write("WHERE ");
this.Visit(update.Where);
}
this.HideColumnAliases = saveHide;
return(update);
}
