Asp.Net MVC Create/Update/Delete with composite key

Question

I'm not sure how to use composite key.

My Categories table has CategoryId (PK,FK), LanguageId (PK,FK), CategoryName

CategoryId | LanguageId | CategoryName
1          | 1          | Car
1          | 2          | Auto
1          | 3          | Automobile
etc.

I'm following this design

The default action looks like

//
// GET: /Category/Edit/5

public ActionResult Edit(int id)
{
    return View();
}

and ActionLink

<%= Html.ActionLink("Edit", "Edit", new { id= item.CategoryId }) %>

Should I use something like

<%= Html.ActionLink("Edit", "Edit", new { id= (item.CategoryId + "-" + item.LanguageId) }) %>

so the url is

/Category/Edit/5-5

and

//
// GET: /Category/Edit/5-5

public ActionResult Edit(string id)
{
    // parse id

    return View();
}

or change the route to something like

/Category/Edit/5/5

Or there is some better way?

I tried to construct a key like this, and while it worked initially, it gave me problems later on in POST actions. It tried to push the constructed key into the id field of my model, I think because of a MVC automatism, which was wrong, and gave me an invalid ModelState. — Kai Hartmann
– Kai Hartmann, Commented Dec 21, 2017 at 13:06

nubm · Accepted Answer · 2010-04-04 23:27:46Z

4

Well, it's easier than I thought :-) Just put 2 parameters into RouteValues in ActionLink so it generates a query string.

<%= Html.ActionLink("Edit", "Edit", new { id= item.CategoryId, lang= item.LanguageId }) %>

The url will be Category/Edit/1?lang=3

So it's more about routing than anything else in my question. More on this

answered Apr 4, 2010 at 23:27

nubm

1,1532 gold badges14 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Paul-Sebastian Manole Over a year ago

Also, for your controller, you have to update it to something like this: db.NewArticleRequests.Find(id, userId); instead of db.NewArticleRequests.Find(id);. In my case, as I was writing my app, I decided to add userId to the PK of the table, along the previous bare Id so this generated an error on both EF and ASP.NET MVC controller actions that requested entities by PK.

Kai Hartmann Over a year ago

Very nice. This works much better than constructing a key and using that as the id Parameter.

Sorush Over a year ago

What is the shape of the controller?

user1228 · Accepted Answer · 2010-04-04 20:24:19Z

0

Yes, there is a better way. You can also determine the user's language and culture from the request to determine which record from your database to use. And I wouldn't come up with a random scheme like 1 = english 2 = german. Use the standard culture identifiers.

answered Apr 4, 2010 at 20:24

user1228

1 Comment

nubm Over a year ago

You are right. I understand that I can use ie. website.com/en/... But what if I need to see all languages for CategoryName at once in my administration?

Collectives™ on Stack Overflow

Asp.Net MVC Create/Update/Delete with composite key

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related