public static string Count(string EntityName, IDynamicQueryBase paramData)
{
StringBuilder query = new StringBuilder(200);
query.Append($"SELECT Count(1) FROM [{EntityName}]");
if (!string.IsNullOrWhiteSpace(paramData.WhereString))
{
query.Append(" where " + paramData.WhereString);
}
return(query.ToString());
}
public static string Count <T>(IDynamicQueryBase paramData) where T : IEntity, new()
{
T target = new T();
StringBuilder query = new StringBuilder(200);
query.Append($"SELECT Count(1) FROM [{target.TableName}]");
if (!string.IsNullOrWhiteSpace(paramData.WhereString))
{
query.Append(" where " + paramData.WhereString);
}
return(query.ToString());
}
public static string Count <T>(this IDynamicQueryBase paramData, string appendWhere) where T : IEntity, new()
{
return(DynamicQuery.Count <T>(paramData, appendWhere));
}