protected virtual Expression VisitInsert(InsertExpression node)
{
if (node.IsIdentityInsertEnabled)
{
Append("SET IDENTITY_INSERT");
Visit(node.Into);
Append("ON;\n");
}
Append("INSERT INTO");
Visit(node.Into);
if (node.Values != null)
{
var useAliasesTmp = _useAliases;
_useAliases = false;
Visit(node.Values);
_useAliases = useAliasesTmp;
}
else if (node.Select != null)
{
Append("(");
Visit(node.Select.Selection);
Append(")", false);
Visit(node.Select);
}
if (node.IsIdentityInsertEnabled)
{
Append("\n");
Append("SET IDENTITY_INSERT");
Visit(node.Into);
Append("OFF;");
}
return(node);
}
protected virtual Expression VisitInsert(InsertExpression node)
{
if (node.IsIdentityInsertEnabled)
{
Append("SET IDENTITY_INSERT");
Visit(node.Into);
Append("ON;\n");
}
Append("INSERT INTO");
Visit(node.Into);
if (node.Values != null)
{
var useAliasesTmp = _useAliases;
_useAliases = false;
Visit(node.Values);
_useAliases = useAliasesTmp;
}
else if (node.Select != null)
{
Append("(");
Visit(node.Select.Selection);
Append(")", false);
Visit(node.Select);
}
if (node.IsIdentityInsertEnabled)
{
Append("\n");
Append("SET IDENTITY_INSERT");
Visit(node.Into);
Append("OFF;");
}
return node;
}
