private static List <Column> GetInsertColumns(SqlInsertSpecification spec, Table table)
{
if (spec.TargetColumns == null)
{
return(table.Columns);
}
var columns = new List <Column>( );
var columnRefs = spec.TargetColumns as SqlColumnRefExpressionCollection;
foreach (var columnRef in columnRefs)
{
var column = table.Columns.FirstOrDefault(c => c.Name == columnRef.ColumnName.Value);
if (column == null)
{
throw new SqlInvalidColumnNameException(columnRef.ColumnName.Value);
}
columns.Add(column);
}
return(columns);
}
public override void Visit(SqlInsertSpecification codeObject)
{
}
private Table GetInsertTable(Dictionary <string, Table> tables, SqlInsertSpecification spec)
{
var target = spec.Target as SqlTableRefExpression;
return(Helper.GetTableFromObjectId(target.ObjectIdentifier, tables, ((MemoryDbConnection)_Command.Connection).TempTables));
}
