public string UPDATE(ColumnPairCollection pairs) { var L1 = pairs .Where(column => !ik.Contains(column.ColumnName)) .Where(column => !pk.Contains(column.ColumnName)) .Where(column => !ck.Contains(column.ColumnName)) .Select(p => $"{p.ColumnName.ColumnName()} = {p.Value.ToScript()}"); string update = string.Join(",", L1); return(template.Update(update, WHERE(pairs))); }
public string INSERT(ColumnPairCollection pairs, bool InsertWithoutColumns = false) { var L1 = pairs .Where(column => !ik.Contains(column.ColumnName)) .Where(column => !ck.Contains(column.ColumnName)); var x1 = L1.Select(p => p.ColumnName.ColumnName()); var x2 = L1.Select(p => p.Value.ToScript()); if (InsertWithoutColumns) { return(template.Insert(string.Join(",", x2))); } else { return(template.Insert(string.Join(",", x1), string.Join(",", x2))); } }
private string WHERE(ColumnPairCollection pairs) { var L1 = pairs.Where(p => pk.Contains(p.ColumnName)).ToArray(); return(string.Join <ColumnPair>(" AND ", L1)); }