How to post data into a foreign Key table

Tochinicky Onyeamah

8y824.NET

Please i need help, i have two tables User and ExistingUser

i have a foreign key UserId in the ExistingUser table,

And on the user interface i can search for the names from the User Table,

how can i post the name into the UserId(FK)column in the ExistingUser table.

i'm using asp.net core 2.0 mvc

[HttpPost]
public async Task Existing(BigView big)
{
if (!ModelState.IsValid)
{
return View();
}
var student = (from p in _context.Users where p.UserId== p.UserId select p).First();
_context.ExistingUser.Add(big.ExistingUser);
await _context.SaveChangesAsync();
return RedirectToAction("Existing");
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tochinicky Onyeamah8y ago
the User table is for first registration for the user,
UserId is the PK in User table and a foreign key in ExistingUser Table,
so what i did i searched for the user's name(autopopulate) from the User table but i'm unable to post the searched name into the ExistingUser so that it can be registered as a FK in the ExistingUser table, i'm a newbie @Sakthivel Ganesan
Sakthivel Ganesan8y ago
i have two tables User and ExistingUser

Q: Why two tables? Can't User table take care of both?

how can i post the name into the UserId(FK)column in the ExistingUser table.

Q: What do you mean by post name into UserId column. I believe UserID is a numeric field. How would you add a string into it? Am I missing something here.