Styjun

Trying to upload a file as part of a form and store it in a folder in wwwroot then store the url for the file in a sql server database table along with the other details of the form? If anyone has any ideas it would be greatly appriciated

You could use IFormFile to receive the file.And then save the file path url to your database using EF core. Remember to create a myFiles folder where to save uploaded files under wwwroot firstly.

You could refer to the tutorial of File uploads in ASP.NET Core

Below is a simple demo:

Models:

public class Engineer

 public int Id get; set; 
 public string Name get; set; 
 public string FilePath get; set; 

public class EngineerVM

 public string Name get; set; 
 public IFormFile File get; set; 

View:

@model EngineerVM
<form method="post" enctype="multipart/form-data" asp-controller="Home" asp-action="Index">
<div class="form-group">
 <div class="col-md-10">
 <input type="text" asp-for="Name" />
 </div>
 <div class="col-md-10">
 <p>Upload one or more files using this form:</p>
 <input type="file" name="file"/>
 </div>
</div>
<div class="form-group">
 <div class="col-md-10">
 <input type="submit" value="Save" />
 </div>
</div>
</form>

Controller:

public class HomeController : Controller

 private readonly IHostingEnvironment _hostingEnv;
 private readonly ApplicationDbContext _context;

 public HomeController(IHostingEnvironment hostingEnv,ApplicationDbContext context)
 
 _hostingEnv = hostingEnv;
 _context = context;
 

 [HttpPost]
 [ValidateAntiForgeryToken]
 public async Task<IActionResult> Index(EngineerVM engineerVM)
 
 if (engineerVM.File != null)
 
 //upload files to wwwroot
 var fileName = Path.GetFileName(engineerVM.File.FileName);
 var filePath = Path.Combine(_hostingEnv.WebRootPath, "images", fileName);

 using (var fileSteam = new FileStream(filePath, FileMode.Create))
 
 await engineerVM.File.CopyToAsync(fileSteam);
 
 //your logic to save filePath to database, for example

 Engineer engineer = new Engineer();
 engineer.Name = engineerVM.Name;
 engineer.FilePath = filePath;

 _context.Engineers.Add(engineer);
 await _context.SaveChangesAsync();
 
 else
 

 
 return View();