将数据插入数据库中的两个表，并具有一到多关系的ASP.NET EF

Question

我有一个发布类

public class Post
    {
        public int Id {get; set;}
        public string Title { get; set; }
        public string Content { get; set; }
        public List<string> GalleryPaths { get; set; }
    }

和图像 class：

    public class Image
    {
        public int Id { get; set; }
        public string Path { get; set; }
        public int PostId { get; set; }
        [ForeignKey("PostId")]
        public virtual Post Post { get; set; }
    }

现在我想在我的帖子表中添加post ; 到我的图像表。

我的方法是：

public void Create(PostAddRequest model)
        {
            List<string> galleryImageFiles = new List<string>();
            if (model.GalleryImages != null)
            {
                foreach (var item in model.GalleryImages)
                {
                    galleryImageFiles.Add("/Content/img/uploads/" + Guid.NewGuid() + "_" + model.FeaturedImage.FileName);
                    item.SaveAs(System.Web.HttpContext.Current.Server.MapPath(galleryImageFiles.Last()));
                }
            }
            var post = new Post()
            {
                Title = model.Title,
                Content = model.Content,
            };
            model.FeaturedImage.SaveAs(System.Web.HttpContext.Current.Server.MapPath(featuredImageFile));
            _unitOfWork.PostRepository.AddPost(post);
            _unitOfWork.SaveChanges();

            List<Image> gallery = new List<Image>();
            foreach (var item in galleryImageFiles)
            {
                gallery.Add(new Image()
                {
                    Path = item,
                    PostId = post.Id
                });
            }
            _unitOfWork.ImageRepository.AddGallery(gallery);
            _unitOfWork.SaveChanges();
}

我对EF有些新手，想知道是否有更有效的方法可以这样做，甚至消除了imageerepository的需求？

Answer 1

我发现这个答案真的很有帮助

发布我自己的解决方案：

public void Create(PostAddRequest model)
        {
            List<string> galleryImageFiles = new List<string>();
      
            if (model.GalleryImages != null)
            {
                foreach (var item in model.GalleryImages)
                {
                    galleryImageFiles.Add("/Content/img/uploads/" + Guid.NewGuid() + "_" + model.FeaturedImage.FileName);
                    item.SaveAs(System.Web.HttpContext.Current.Server.MapPath(galleryImageFiles.Last()));
                }
            }
            var post = new Post()
            {
                Title = model.Title,
                Content = model.Content,
                GalleryPaths = new List<Image>()
            };

            _unitOfWork.PostRepository.AddPost(post);

            foreach (var item in galleryImageFiles)
            {
                post.GalleryPaths.Add(new Image()
                {
                    Path = item,
                    PostId = post.Id
                });
            }
            _unitOfWork.SaveChanges();
        }