Upload image file in entity framework database

Question

How to insert,update 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

Upload image file in entity framework database

Answers (1)