public System_User FirstOrDefault(Expression <Func <System_User, bool> > expression) { return(_excuteEntity.Excute(connection => { return connection.QuerySet <System_User>() .Where(expression) .Get(); })); }
public T GetByID(TKey id) { return(_excuteEntity.Excute(connection => { return connection.QuerySet <T>() .Where(x => x.PKID.Equals(id)) .Get(); })); }
public T Get(int id) { return(_excuteEntity.Excute(connection => { var attrs = typeof(T).GetCustomAttributes(typeof(MappingTableAttribute), true); var attr = (MappingTableAttribute)attrs.FirstOrDefault(); var sql = $"select * from {attr.TableName} where PKID = {id}"; Console.WriteLine(sql); return connection.Query <T>(sql); }).FirstOrDefault()); }