public override string ToStr() { StringBuilder sb = new StringBuilder(); sb.Append("update ").Append(TableClause.ToStr()); if (Set.Count > 0) { sb.Append(" SET "); for (int i = 0; i < Set.Count; i++) { var sc = Set[i]; if (i > 0) { sb.Append(", "); } sb.Append(sc.ToStr()); } } if (Where != null) { sb.Append(" where ").Append(Where.ToStr()); } AddReturningToStr(sb); return(sb.ToString()); }
public override string ToStr() { StringBuilder sb = new StringBuilder(); sb.Append("delete from ").Append(TableClause.ToStr()); if (Where != null) { sb.Append(" where ").Append(Where.ToStr()); } AddReturningToStr(sb); return(sb.ToString()); }
public override string ToStr() { StringBuilder sb = new StringBuilder(); sb.Append("insert into ").Append(TableClause.ToStr()); if (DefaultValues) { sb.Append(" DEFAULT VALUES"); } else { if (ColumnOfValues.Count > 0) { sb.Append(" ( "); for (int i = 0; i < ColumnOfValues.Count; i++) { var sc = ColumnOfValues[i]; if (i > 0) { sb.Append(", "); } sb.Append(sc.ToStr()); } sb.Append(")"); } if (Values != null && Values.Count > 0) { sb.Append(" values"); for (int i = 0; i < Values.Count; i++) { var sc = Values[i]; //sb.Append("("); if (i > 0) { sb.Append(", "); } sb.Append(sc.ToStr()); //sb.Append(")"); } } else { sb.Append(" ").Append(Select.ToStr()); } } AddReturningToStr(sb); return(sb.ToString()); }