public override string ToSql(ExpressionSqlBuilder builder) { StringBuilder sb = new StringBuilder(); sb.Append("CREATE VIEW "); sb.Append(Table.ToSql(builder)).Append(" "); if (Columns.Count > 0) { sb.Append("("); for (int i = 0; i < Columns.Count; i++) { if (i != 0) { sb.Append(", "); } var c = Columns[i]; sb.Append(ParserUtils.TableToStrEscape(c)); } sb.Append(") "); } sb.Append("AS "); sb.Append(AsSelect.ToSql(builder)); return(sb.ToString()); }
public override string ToSql(ExpressionSqlBuilder builder) { return(" " + SelectOperationToString(Operation) + " " + Select.ToSql(builder)); }