Upload image file in entity framework database

Question

How to insertupdate and delete image in MVC using Entity framework database.Help me with details code please!

Prakash Joshi · Answer

You can do something like below create a model like this public class AdminDetailsViewModel { public int AdminID { get; set; } [Display(Name = Admin Name)] [Required(ErrorMessage = Name is Required)] public string AdminName { get; set; } [Display(Name = Admin Photo)] public byte[] AdminImage { get; set; } } create a class like ImageRepository whic uses DbContext class public class ImageRepository { private readonly ERPDbContext db = new ERPDbContext(); public int UploadImageInDatabase(HttpPostedFileBase file AdminDetailsViewModel viewmodel) { viewmodel.AdminImage = ConvertToByte(file); var model = new AdminDetailsModel { AdminName = viewmodel.AdminName AdminImage = viewmodel.AdminImage }; db.AdminDetails.Add(model); int i = db.SaveChanges(); if (i == 1) { return 1; } else { return 0; } } private byte[] ConvertToByte(HttpPostedFileBase file) { byte[] imageByte = null; BinaryReader rdr = new BinaryReader(file.InputStream); imageByte = rdr.ReadBytes((int)file.ContentLength); return imageByte; } } create your controller like this [HttpPost] public ActionResult Create(AdminDetailsViewModel viewmodel) { if (ModelState.IsValid) { viewmodel.CreatedDate = DateTime.Now; HttpPostedFileBase file = Request.Files[ImageData]; ImageRepository IR = new ImageRepository(); int i = IR.UploadImageInDatabase(file viewmodel); if (i == 1) { return RedirectToAction(Index); } } return View(viewmodel); } Its not full code but i think u get some idea