//Grabs all rows from the AspNetUsers database public static List <UserModel> LoadUsers() { //create sql statement to get all info from the user database string sql = @"SELECT dbo.AspNetUsers.Id, dbo.AspNetUsers.Email, dbo.AspNetUsers.UserName, dbo.AspNetUserRoles.UserId, dbo.AspNetUserRoles.RoleId FROM dbo.AspNetUsers LEFT JOIN dbo.AspNetUserRoles ON dbo.AspNetUsers.Id = dbo.AspNetUserRoles.UserId ORDER BY dbo.AspNetUserRoles.RoleId"; //executes the sql statement and returns the number of rows affected return(SqlDataAccess.LoadUserData <UserModel>(sql)); }