curd operations for save public List<int> PersonIds { get; set; }

Question

curd operations for save public List<int> PersonIds { get; set; }

Bipin 0

public class Person

{

[Key]

public int Id { get; set; }

public string Name { get; set; }

}

public class Work

{

[Key]

public int Id { get; set; }

public string WorkName { get; set; }

// Use a list of person IDs

public List<int> PersonIds { get; set; }

}

How to save one or more person to Work in C# mvc core 8

1 answer

Your answer

Answer 1

Anonymous

Hi @Bipin,

The model design for one-to-many relationship should be:

public class Person
{
    [Key]

    public int Id { get; set; }

    public string Name { get; set; }
    public int WorkId { get; set; }
    public Work Work { get; set; } = null!;
}
public class Work
{

    [Key]
    public int Id { get; set; }
    public string? WorkName { get; set; }
    public List<Person> Person { get; set; } = new List<Person>();
}

For how to save one or many Person to Work, a simple demo you could refer :

public async Task<IActionResult> Create(Work work)
{
    if (!ModelState.IsValid)
    {
        return View();
    }
    var person1 = new Person()
    { Name = "aa" };
    var person2 = new Person()
    { Name = "bb" };
    Work.Person.Add(person1);
    Work.Person.Add(person2);
    _context.Work.Add(work);
    await _context.SaveChangesAsync();

    return View();
}

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best regards,
Rena

Bipin 0 Reputation points

2024-01-03T08:37:16.62+00:00

Ok, but how to add this through Controller
AgaveJoe 30,121 Reputation points

2024-01-03T13:12:53.1333333+00:00
Ok, but how to add this through Controller

It is hard to answer this question accurately without understanding the application flow. However, this subject is covered in most, if not all, MVC tutorials that access a database.

I recommend going through the following tutorial which illustrates the MVC programming patterns form managing related data. Step 7 is what you want but you should go through the entire tutorial.

ASP.NET Core MVC with EF Core - tutorial series

Keep in mind, Visual Studio has a scaffolding feature where you can select an entity let Visual Studio create the MVC controllers and views. If you were to do this for both the Person and Work types then all you have to do is update the Person controller's Create and Edits Actions to display the work name when editing or creating a new person. Essentially the application flow assigns work to a person.

The code generator creates the following.

ViewData["WorkId"] = new SelectList(_context.Works, "Id", "Id");

Change the lines, there are four of them, to.

ViewData["WorkId"] = new SelectList(_context.Works, "Id", "WorkName");

This change displays the WorkName in the select rather than the Id.

If the user case requires adding multiple people to a work item then a different approach is required. One approach is using the Work Id in the route (URL) to the select the work item. Then designing a View that has a list of people within the work item. The trick with this approach is understanding how the model binder works. You need to make sure the input names have an index. Otherwise, the model binder will not understand how to populate the list of people.

Again, this type of information is covered in the tutorial and the official documentation.
Anonymous

2024-01-18T08:39:03.69+00:00

Hi @Bipin, Is there any update for your thread?

Share via

curd operations for save public List<int> PersonIds { get; set; }

1 answer

Your answer