[Vuejs]-How insert multiple value in Intermediate table through API

by

0👍

Finally I am able to find the solution… 

 public async Task<Guid> CreateSchoolsAsync(SchoolsCreateVm schoolsCreateVm)
    {
        if (_GpsContext != null)
        {
          var schoolId = Guid.NewGuid();
          var schoolsEntity = new Schools()

            {
                ID = schoolId, //    1--[1,2,3]
                Name = schoolsCreateVm.Name,                     
            };
            // Here the code in which we can enter in the multiple table and Intermediate table
           var SchoolsSchoolTypeList = new List<SchoolsSchoolType>();

            foreach(var item in  schoolsCreateVm.SchoolTypeId)
            {
                SchoolsSchoolTypeList.Add(new SchoolsSchoolType
                {
                     Id = Guid.NewGuid(),
                     ShoolId = schoolId,
                     SchoolTypeId = item,
                });
            }
            await _GpsContext.School.AddAsync(schoolsEntity);
            _GpsContext.SchoolsSchoolTypes.AddRange(SchoolsSchoolTypeList);//Enter here for intermediate table that is 'SchoolsSchoolTypes'
            await _GpsContext.SaveChangesAsync();
            return schoolsEntity.ID;
        }
         return Guid.Empty;      
    }

Leave a comment