public Page <User> GetUsersPageByEmail(string emailToMatch, string applicationName, int pageIndex, int pageSize)
 {
     using (var session = OpenSesion())
     {
         IQuery <FindByEmailSubstring, Page <User> > query = new UsersColumnMatchedToSubstring(session);
         var page =
             query.Execute(new FindByEmailSubstring(emailToMatch, applicationName, pageIndex + 1, pageSize));
         return(page);
     }
 }
 public Page<User> GetUsersPageByUsername(string usernameToMatch, string applicationName, int pageIndex,
     int pageSize)
 {
     using (var session = OpenSesion())
     {
         IQuery<FindByUsernameSubstring, Page<User>> query = new UsersColumnMatchedToSubstring(session);
         var page =
             query.Execute(new FindByUsernameSubstring(usernameToMatch, applicationName, pageIndex + 1, pageSize));
         return page;
     }
 }