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