protected virtual string GetStatementSql(InsertStatement statement) { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO "); sb.Append(GetSql(statement.Identifier)); if (statement.Columns.Count > 0) { sb.Append(Environment.NewLine); sb.Append(" ("); int columnCount = statement.Columns.Count; for (int i = 0; i < columnCount; i++) { sb.Append(GetSql(statement.Columns[i])); sb.Append(i == (columnCount - 1) ? ", " : ""); } sb.Append(")"); } sb.Append(Environment.NewLine); sb.Append(" VALUES "); int rowCount = statement.Values.Count; for (int j = 0; j < rowCount; j++) { sb.Append("("); List <IExpression> expr = statement.Values[j]; int columnCount = expr.Count; for (int i = 0; i < columnCount; i++) { sb.Append(GetSql(expr[i])); sb.Append(i == (columnCount - 1) ? ", " : ""); } sb.Append(")"); sb.Append(j == (rowCount - 1) ? "," + Environment.NewLine : ""); } sb.Append(';'); return(sb.ToString()); }
protected virtual string GetStatementSql (InsertStatement statement) { StringBuilder sb = new StringBuilder (); sb.Append ("INSERT INTO "); sb.Append (GetSql (statement.Identifier)); if (statement.Columns.Count > 0) { sb.Append (Environment.NewLine); sb.Append (" ("); int columnCount = statement.Columns.Count; for (int i=0; i<columnCount; i++) { sb.Append (GetSql (statement.Columns[i])); sb.Append (i == (columnCount - 1) ? ", " : ""); } sb.Append (")"); } sb.Append (Environment.NewLine); sb.Append (" VALUES "); int rowCount = statement.Values.Count; for (int j=0; j<rowCount; j++) { sb.Append ("("); List<IExpression> expr = statement.Values[j]; int columnCount = expr.Count; for (int i=0; i<columnCount; i++) { sb.Append (GetSql (expr[i])); sb.Append (i == (columnCount - 1) ? ", " : ""); } sb.Append (")"); sb.Append (j == (rowCount - 1) ? "," + Environment.NewLine : ""); } sb.Append (';'); return sb.ToString (); }