public User GetById(int id)
        {
            var user = this.connection.Query <User>(UserQuery.GetById(), new { UserId = id }, this.transaction).FirstOrDefault();

            return(user);
        }