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