//string _skip; //string _take; public SqlTemplateBuilder(SqlTableInfo tableInfo) { _columns = tableInfo.ColumnInfo.Select(c => $"[{c.Name}]").Aggregate((a, b) => $"{a}, {b}"); _tableInfo = tableInfo; _identity = tableInfo.ColumnInfo .Where(c => c.Identity) .Select(c => $"[{c.Name}] = @{c.Name}") .Aggregate((a, b) => $"{a} AND {b}"); }