Asynchronously Insert (Save) data in multiple tables using Entity Framework in ASP.Net Core MVC

Hi skaushik,

Check this example. Now please take its reference and correct your code.

1. You need to create two classes as per the Columns in the Json string.

2. Read the Json string and convert it to class object.

3. Add the record to database using loop.

Namespaces

using System.IO;
using System.Threading.Tasks;
using Newtonsoft.Json;
using Microsoft.AspNetCore.Hosting;

Controller

public class HomeController : Controller
{
    private IHostingEnvironment Environment;
    public HomeController(IHostingEnvironment _environment)
    {
        Environment = _environment;
    }
    // GET: /Home/
    public async Task<IActionResult> Index()
    {
        string path = Path.Combine(this.Environment.WebRootPath, "Json.txt");
        string json = System.IO.File.ReadAllText(path);
        EmployeeDetails employeeDetails = JsonConvert.DeserializeObject<EmployeeDetails>(json);
        InsertEmployeeDetails(employeeDetails);
        return View();
    }

    public static async Task InsertEmployeeDetails(EmployeeDetails employeeDetails)
    {
        using (var db = new EmployeeEntities())
        {
            Employee emp = new Employee();
            emp.EmployeeId = employeeDetails.EmployeeId;
            emp.Name = employeeDetails.Name;
            emp.Designation = employeeDetails.Designation;
            // Add to Employee Table.
            db.Employees.Add(emp);

            foreach (AddressDetails address in employeeDetails.Address)
            {
                Contact contact = new Contact
                {
                    AddressId = address.AddressId,
                    EmployeeId = address.EmployeeId,
                    Address = address.Address,
                    AddressType = address.AddressType
                };
                // Add each Address to Contact Table.
                db.Contacts.Add(contact);
            }
            await db.SaveChangesAsync();
        }
    }

    public class EmployeeDetails
    {
        public int EmployeeId { get; set; }
        public string Name { get; set; }
        public string Designation { get; set; }
        public List<AddressDetails> Address { get; set; }
    }

    public class AddressDetails
    {
        public int AddressId { get; set; }
        public int EmployeeId { get; set; }
        public string Address { get; set; }
        public string AddressType { get; set; }
    }
}