Set a foreign key ID in the AspNetUsers table by selecting the id of another table?

Question

I have added a TeamID to the AspNetUsers table. There is a Teams table and every team is giving an ID. I want users to select a Team and when they are selected the TeamID in the AspNetUsers table to be updated using an action link to do this.

[HttpPost]
        public ActionResult Select(int? id)
        {
            Team team = db.Teams.Find(id);
            if (team != null)
            {

                ViewBag.RowsAffected = db.Database.ExecuteSqlCommand("UPDATE AspNetUsers SET TeamID = {0}", team);
            }
            return View();
        }

This is the code I have tried but it does not work any suggestions or better ways to do it?

score 0 · Answer 1 · edited May 23 '17 at 10:29

That query is updating the Team column for EVERY user in your app.

You need to first get the current user (the one actually using the app), find her Id/name to use it in a WHERE clause.

UPDATE AspNetUsers SET TeamId = XXX where Id = YYYY

Too much going on for a simple answer. How to get the current User id is already answered here:

ASP.NET MVC 5 - Identity. How to get current ApplicationUser

Set a foreign key ID in the AspNetUsers table by selecting the id of another table?

1 Answers1