如何使用Linq在一个表中插入和更新另一个表

我有以下linq表达式,我正在尝试使用新创建的AdressID在to address表和Update customer表中创建新记录,如何创建新地址获取新AddressID并更新customer表

 if (request == null)
                throw new ArgumentNullException(nameof(request));
            if (request.AddressToCreate == null)
                throw new ArgumentNullException(nameof(request.AddressToCreate));     

            var address = Mapper.Map<Address>(request.AddressToCreate);
            address.CreatedBy = request.AddressToCreate.CreatedBy;
            address.CreatedDate = SystemClock.UtcNow;
            address.UpdatedBy = request.AddressToCreate.UpdatedBy;
            address.UpdatedDate = SystemClock.UtcNow;

              await Context.AddAsync(address);

            var rps = Context.Customers .Where(rc => rc.ID == request.ID).SingleOrDefault();
                    rps.AddressID = request.AddressToCreate.ID;

            await Context.SaveChangesAsync();

但是request.AddressToCreate.ID;返回0,我如何修改代码以获得新的AddressID

转载请注明出处:http://www.mingyanggongyi.com/article/20230526/1426759.html