File upload MVC Core EntityFrameworkCore mysql please help

Question

I am new to mvc and entity framework core. I have been struggling with file upload to mysql cpanel server. Please refer or assist me in this regard. File upload is on a form.

Leah Kunkie · Answer

The application does save files but not on the server. Which data type supports IFormFile? How do i change the code to store to the database? Below is my code: My model namespace EmpApp.Models { public class UserViewModel { [Required(ErrorMessage = "Please select a file.")] [DataType(DataType.Upload)] public IFormFile Photo { get; set; } } } View @model EmpApp.Models.UserViewModel asp-action="Index" asp-controller="UserView" enctype="multipart/form-data"> Controller namespace EmpApp.Controllers { public class UserViewController : Controller { private readonly IHostingEnvironment environment; private readonly AppDataContext context; public UserViewController(AppDataContext context, IHostingEnvironment environment) { this.environment = environment; this.context = context; } public IActionResult Index() { var model = new UserViewModel(); return View(model); } [HttpPost] [ValidateAntiForgeryToken] public async Task Index(UserViewModel userViewModel) { if (ModelState.IsValid) { var formFile = userViewModel.Photo; if (formFile == null || formFile.Length == 0) { ModelState.AddModelError("", "Uploaded file is empty or null."); return View(viewName: "Index"); } var uploadsRootFolder = Path.Combine(environment.WebRootPath, "~/uploads/"); if (!Directory.Exists(uploadsRootFolder)) { Directory.CreateDirectory(uploadsRootFolder); } var filePath = Path.Combine(uploadsRootFolder, formFile.FileName); using (var fileStream = new FileStream(filePath, FileMode.Create)) { await formFile.CopyToAsync(fileStream).ConfigureAwait(false); } RedirectToAction("Index"); } return View(viewName: "Index"); } } } my database table

Madan Shekar · Answer

go through bellow blog https://www.c-sharpcorner.com/article/asp-net-mvc-form-with-file-upload/ if it helps mark as a answer.

Leah Kunkie · Answer

Thanks Madan, Please refer me to a source.

Madan Shekar · Answer

Hi, You have to follow normal appraoch only create one folder inside your solution and store all images to there. save image name in Database. login to your Cpanel and particular fileupload folder set permision or write access. That's it