private List<string> StringifyValues(TableModel model) { List<string> parts = new List<string>(); foreach (Object obj in model.GetMappedColumns().Values) { StringBuilder builder = new StringBuilder(); if (obj.GetType() == typeof(String)) { builder.Append("'"); builder.Append(obj); builder.Append("'"); } else { builder.Append(obj); } parts.Add(builder.ToString()); } return parts; }
private string joinColumnValues(TableModel model) { return " (" + String.Join(",",StringifyValues(model).ToArray()) + ") "; }
public string ApplyTemplate(TableModel model) { return insert + into + model.GetTableName() + joinColumnName(model) + values + joinColumnValues(model); }
private string joinColumnName(TableModel model) { return " (" + String.Join(",",model.GetMappedColumns().Keys.ToArray()) + ") "; }
public string toInsertString(TableModel model) { return new ANSISQL().GetInsertTemplate().ApplyTemplate(model); }