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));
}
