ASP. NET MVC Image使用Entity Framework在数据库上上传和创建记录

Question

好吧，我使用Xamarin工作，我有一个使用实体框架的WebAPI。我已经可以将图像从手机发送到网络服务，但我想在数据库上正确创建所有关系的记录，所以基本上我有3个表要工作，如下所示：

1. 图像
2. 发生图像
3. 发生

模型图

在我的WebAPI中，我有两个控制器，一个用于处理图像上载，另一个用于处理事件。我试图在创建occurrenceimage记录时设置自定义ID，但没有成功。

ImageUploadController。cs

[HttpPost]
        public HttpResponseMessage UploadImage(string imageName)
        {
            var result = new HttpResponseMessage(HttpStatusCode.OK);
            if (Request.Content.IsMimeMultipartContent())
            {
                Request.Content.LoadIntoBufferAsync().Wait();
                Request.Content.ReadAsMultipartAsync(new MultipartMemoryStreamProvider()).ContinueWith((task) =>
                {
                    MultipartMemoryStreamProvider provider = task.Result;
                    foreach (HttpContent content in provider.Contents)
                    {
                        Stream stream = content.ReadAsStreamAsync().Result;
                        Image image = Image.FromStream(stream);
                        var testName = content.Headers.ContentDisposition.Name;
                        String filePath = HostingEnvironment.MapPath("~/Images/");
                        string nameImg = imageName + Guid.NewGuid();
                        String fullPath = Path.Combine(filePath, nameImg + ".jpg");
                        image.Save(fullPath);
                        AddImageToDb(nameImg);
                    }
                });

                return result;
            }
            else
            {
                throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotAcceptable, "This request is not properly formatted"));
            }

        }

        private void AddImageToDb(string imageName)
        {
            VisitDatabase.Image image = new VisitDatabase.Image()
            {
                urlImage = imageName + ".jpg"
            };

            OccurenceImage occurenceImage = new OccurenceImage()
            {
               idOccurence = 18,
               Image = image,

            };
            db.Image.Add(image);
            db.OccurenceImage.Add(occurenceImage);
            db.SaveChanges();
        }

发生控制器。cs公司

[ResponseType(typeof(ActiveCitizen))]
        public IHttpActionResult PostOccurence(ActiveCitizen json)
        {
            Citizen citizen;
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }
            ActiveCitizen activeCitizen = json;
            var query = (from c in db.Citizen
                where c.ccbi == activeCitizen.NumDocument
                select c.idCitizen).SingleOrDefault();
            Address address = new Address()
            {
                lat = 12,
                lon = 12,
                street = "Rua do Santuario",
                postalCode = "4490-554",
                locality = "Barcelos"
            };


            OccurenceType occurenceType = new OccurenceType()
            {
                title = activeCitizen.Description,               
            };
            if (query == 0)
            {
                citizen = new Citizen()
                {
                    ccbi = activeCitizen.NumDocument,
                    nif = activeCitizen.NIF,
                    Contact = new Contact()
                    {
                        name = activeCitizen.Name,
                        email = activeCitizen.Email,
                        phone = activeCitizen.Phone
                    },
                    Address = address
                };
            }
            else
            {
                citizen = db.Citizen.Find(query);
            }                   

            Occurence occurence = new Occurence()
            {
                solved = 0,
                occurenceDateTime = new DateTime(2017, 5, 23),
                Address = address,
                OccurenceType = occurenceType,
                Citizen = citizen
            };

            db.Address.Add(address);
            db.OccurenceType.Add(occurenceType);
            if (query == 0)
            {
                db.Contact.Add(citizen.Contact);
                db.Citizen.Add(citizen);
            }           
            db.Occurence.Add(occurence);
            db.SaveChanges();
            return CreatedAtRoute("DefaultApi", new { id = occurence.idOccurence }, activeCitizen);
        }

提前感谢！

Answer 1

上面的代码是正确的，似乎问题出在表occurrenceimage中，字段idoccurrenceimage标识规范被禁用，只需要启用，并且工作正常。我希望这能帮助其他有这种新手问题的人！