How to pass UserProfile model to view?

Question

I am trying to implement simple membership in my application. My problem is that I want to be able to display the data in the userprofile table for the current user but I dont know how to select it from the DB

I have tried this but I am getting an error:

    UserProfile UserP = new UserProfile();

        ViewBag.Message = User.Identity.Name;
        return View();

        UserP = (from r in up.UserName
                  where up.UserName == User.Identity.Name.ToString()
                  select r).ToList().FirstOrDefault();


        return View(UserP);

Here is the error:

            Error   1   Cannot implicitly convert type 'char' to 'MvcApplication5.Models.UserProfile'   C:\Users\user\Desktop\MvcApplication5\MvcApplication5\Controllers\HomeController.cs 31  32  MvcApplication5

Answer 1

If I got you right (your code is little bit broken, it has two returns, so I assume there is just two pieces of code), try this:

UserP = (from r in up
                  where up.UserName == User.Identity.Name.ToString()
                  select r).FirstOrDefault();

Just get rid of up.UserName in your query. ToList() is also not needed.

P.S. For the future:

I also suggest you adding another column called LoweredUserName and perform checking in the following way:

where up.LoweredUserName == User.Identity.Name.ToString().ToLower()

Answer 2

Here is how you can access the UserProfile.

var context = new UsersContext();
var username = User.Identity.Name;
var user = context.UserProfiles.SingleOrDefault(u => u.UserName == username);
return View(user);

For more on customizing the UserProfile and accessing it read this article.