public static string KeyValueTypeQueryGenerator <TSource>(IDbContextS04 dbContext, string id, IEnumerable <string> title) where TSource : IBaseEntity
{
var tableName = dbContext.GetTableName <TSource>();
var Cid = dbContext.GetColumnName <TSource>(id);
string CTitle = string.Empty;
List <string> titleColumns = new List <string>();
if (title.Count() == 1)
{
CTitle = $"[{dbContext.GetColumnName<TSource>(title.Single())}]";
}
else
{
foreach (string c in title)
{
titleColumns.Add(dbContext.GetColumnName <TSource>(c));
}
CTitle = string.Join(" , ' ' ,", titleColumns.Select(x => $"[{x}]"));
}
return($"SELECT CONCAT([{Cid}],'') Id ,CONCAT({CTitle}) Title FROM {tableName}");
}
public static string RemoveAll <TSource>(IDbContextS04 dbContext) where TSource : IBaseEntity, class
