public ActionResult Index()
 {
     ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";
     using (var userContext = new UsersContext()) {
         var sss = userContext.UserProfiles.AsQueryable().Take(10);
         ViewBag.S = sss;
     }
     return View();
 }
 public ActionResult About()
 {
     ViewBag.Message = "Your app description page.";
     using (var userContext = new UsersContext()) {
         var newUser = new UserProfile {
             UserName = Guid.NewGuid().ToString()
         };
         userContext.UserProfiles.Insert(newUser);
     }
     return View();
 }
        public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl)
        {
            string provider = null;
            string providerUserId = null;

            if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) {
                return RedirectToAction("Manage");
            }

            if (ModelState.IsValid) {
                // Insert a new user into the database
                using (UsersContext db = new UsersContext()) {
                    UserProfile user = db.UserProfiles.AsQueryable().FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
                    // Check if user already exists
                    if (user == null) {
                        // Insert name into the profile table
                        db.UserProfiles.Insert(new UserProfile { UserName = model.UserName });

                        OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName);
                        OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false);

                        return RedirectToLocal(returnUrl);
                    } else {
                        ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name.");
                    }
                }
            }

            ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName;
            ViewBag.ReturnUrl = returnUrl;
            return View(model);
        }