insert data to multiple table in same time

Question

I need to make multiple insert to multiple table have relation with each other

what i need actually when user click submit

Save the following data

Name,Email,Salary,DistrictId in table Employee

EmployeeId,CourseId in table EmployeeCourse

EmployeeId,LanaguageId,LevelId in table EmployeeLangage

what i write in create function in empcourse controller

my code attached with message

my interface and Relation diagram is

Attachment: code.rar

ahmed salah · Answer

i try with this : Employee emp = new Employee(); emp.Name = form[Name].ToString(); emp.Salary =Convert.ToInt32(form[Salary ]); emp.Email = form[Email].ToString(); emp.DistrictId = Convert.ToInt32(form[ DistrictId]); var coursesId = form[Courses]; string[] coursesIds = null; if (coursesId != null) { coursesIds = coursesId.Split(''); } List courses = new List (); foreach (var item in coursesIds) { Empcourse ecour = new Empcourse(); ecour.EmployeeId = emp.Id; ecour.CourseId = Convert.ToInt32(item); courses.Add(ecour); } // emp.EmployeeCourses=courses emp.EmployeeCourses=courses; db.Employees.Add(emp); db.SaveChanges(); but i face problem in this line emp.EmployeeCourses=courses; how to assign list to object it give me this error cannot implicity convert convert System.collection.Generic.list to System.collection.Generic. Icollection

ahmed salah · Answer

if i write stored procedure in database what i write all id identity create proc joinemployee ( @Id int @Name nvarchar(50)  @Email nvarchar(50) @districtid int @CourseId int @LanaguagId int @Levelid int ) as insert into employee(@Name @Email@districtid) insert into employeecourse(@Id@CourseId) insert into employeelang(@Id@LanaguagId@Levelid) are my stored procedure true or what

ahmed salah · Answer

my EF diagram found in interface not have stored procedure Are i delete it and recreate again or what i do

Bikesh Srivastava · Answer

Create a procedure and write insert query for all table . and call procedure on .cs page ..try this..

Manas Mohapatra · Answer

Create a model(class) CustomEmployee which will be consist of Employee properties Name Id Salary DistsrictId EmployeeCourse and EmployeeLanguage type. public class CustomEmployee { public int Id { get; set; } public string Name { get; set; } public int DistsrictId { get; set; } public EmployeeCourse EmpCourseObj { get; set; } public EmployeeLanguage EmpLangObj { get; set; } } Next in Controller you will receive CustomEmployee model. Create a stored procedure(SP) and pass all parameters like EmpId Salary DistsrictId LangId CourseId etc..In SP write logic to insert records in individual tables.

ahmed salah · Answer

can you help me what i need actually insert Save the following data NameEmailSalaryDistrictId in table Employee EmployeeIdCourseId in table EmployeeCourse EmployeeIdLanaguageIdLevelId in table EmployeeLangage and write it in Create http post [ HttpPost ] public ActionResult Create ( Customemployee cemp ) { r eturn View (); }

Vinay Singh · Answer

Hi Prepare the model class as per you table structure and then assign the data as per the model and save the data into table as per table values