/// <summary>
/// List
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="whereStr"></param>
/// <returns></returns>
public static List <T> GetList <T>(string whereStr = "")
{
var sqlCondition = string.IsNullOrWhiteSpace(whereStr) ? "" : $" where {whereStr}";
return(DBContext.Query <T>($@"SELECT * FROM {typeof(T).Name} {sqlCondition}").ToList());
}
/// <summary>
/// Model
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="whereStr"></param>
/// <returns></returns>
public static T GetModel <T>(string whereStr = "")
{
var sqlCondition = string.IsNullOrWhiteSpace(whereStr) ? "" : $" where {whereStr}";
return(DBContext.Query <T>($@"SELECT * FROM {typeof(T).Name} {sqlCondition}").FirstOrDefault());
}
