/// <summary>
/// Translates the <paramref name="insertExpression"/> into a string representation.
/// </summary>
/// <param name="insertExpression">The <see cref="DbInsertExpression"/> to translate.</param>
/// <returns><see cref="DbExpression"/></returns>
protected virtual DbExpression VisitInsertExpression(DbInsertExpression insertExpression)
{
var targetExpression = Visit(insertExpression.Target);
var fromExpression = Visit(insertExpression.FromExpression);
var valuesExpression = Visit(insertExpression.Values);
var columnsExpression = Visit(insertExpression.TargetColumns);
if (!ReferenceEquals(targetExpression, insertExpression.Target))
{
insertExpression.Target = targetExpression;
}
if (!ReferenceEquals(fromExpression, insertExpression.FromExpression))
{
insertExpression.FromExpression = fromExpression;
}
if (!ReferenceEquals(valuesExpression, insertExpression.Values))
{
insertExpression.Values = valuesExpression;
}
if (!ReferenceEquals(columnsExpression, insertExpression.TargetColumns))
{
insertExpression.TargetColumns = columnsExpression;
}
return(insertExpression);
}
/// <summary>
/// Translates the <paramref name="insertExpression"/> into a string representation.
/// </summary>
/// <param name="insertExpression">The <see cref="DbInsertExpression"/> to translate.</param>
/// <returns><see cref="string"/></returns>
protected override DbExpression VisitInsertExpression(DbInsertExpression insertExpression)
{
var sb = new StringBuilder();
sb.AppendFormat("INSERT INTO {0} ", Visit(insertExpression.Target));
if (!insertExpression.TargetColumns.IsNull())
{
sb.AppendFormat("({0}) ", Visit(insertExpression.TargetColumns));
}
if (!insertExpression.Values.IsNull())
{
sb.AppendFormat("VALUES({0}) ", Visit(insertExpression.Values));
}
return(ExpressionFactory.Sql(sb.ToString().Trim()));
}
/// <summary>
/// Translates the <paramref name="insertExpression"/> into a string representation.
/// </summary>
/// <param name="insertExpression">The <see cref="DbInsertExpression"/> to translate.</param>
/// <returns><see cref="string"/></returns>
protected override DbExpression VisitInsertExpression(DbInsertExpression insertExpression)
{
var sb = new StringBuilder();
sb.AppendFormat("INSERT INTO {0} ", Visit(insertExpression.Target));
if (!insertExpression.TargetColumns.IsNull())
{
sb.AppendFormat("({0}) ", Visit(insertExpression.TargetColumns));
}
if (!insertExpression.Values.IsNull())
{
sb.AppendFormat("VALUES({0}) ", Visit(insertExpression.Values));
}
return ExpressionFactory.Sql(sb.ToString().Trim());
}
/// <summary>
/// Translates the <paramref name="insertExpression"/> into a string representation.
/// </summary>
/// <param name="insertExpression">The <see cref="DbInsertExpression"/> to translate.</param>
/// <returns><see cref="DbExpression"/></returns>
protected virtual DbExpression VisitInsertExpression(DbInsertExpression insertExpression)
{
var targetExpression = Visit(insertExpression.Target);
var fromExpression = Visit(insertExpression.FromExpression);
var valuesExpression = Visit(insertExpression.Values);
var columnsExpression = Visit(insertExpression.TargetColumns);
if (!ReferenceEquals(targetExpression, insertExpression.Target))
insertExpression.Target = targetExpression;
if (!ReferenceEquals(fromExpression, insertExpression.FromExpression))
insertExpression.FromExpression = fromExpression;
if (!ReferenceEquals(valuesExpression, insertExpression.Values))
insertExpression.Values = valuesExpression;
if (!ReferenceEquals(columnsExpression, insertExpression.TargetColumns))
insertExpression.TargetColumns = columnsExpression;
return insertExpression;
}
