My task is to create a model and database for web API and CRUD purposes, one of the model properties is the photo of a car. While hardcoding data for database migration, how to set that property as a photo and save a photo path to SQL database. Later I have to manipulate with the Postman to make CRUD and API manipulations with that photo and also the other properties of that car. What is the easiest solution? I have found some info about IFormFile and byte but not sure how to do that correctly. I am using asp.net core 2.2. Thank you!
            Asked
            
        
        
            Active
            
        
            Viewed 6,273 times
        
    1
            
            
        - 
                    Are you going to store the file in SQL Server FileStream? – William Xifaras May 20 '19 at 19:50
- 
                    Not sure what is best option. Is it better like that? It's up to me how to store it. – Ivan May 20 '19 at 20:00
- 
                    FileStream enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Is it your best option? Opinions will vary, but its a good option if you are using SQL Server. But it only applies to SQL Server (Windows only). Are you using Azure? – William Xifaras May 20 '19 at 20:09
- 
                    I understand, no not using azure. I read a lot about file stream and I know what is the usage of it but, don't know to apply it correctly – Ivan May 20 '19 at 20:24
- 
                    You will have to read the docs on it. It's not hard to set up. If you plan on using it, going from IFormFile to FileStream is simple. – William Xifaras May 20 '19 at 20:25
- 
                    https://learn.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server?view=sql-server-2017 – William Xifaras May 20 '19 at 20:27
- 
                    @Ivan this can be of help too https://stackoverflow.com/questions/35379309/how-to-upload-files-in-asp-net-core – David Zagi May 20 '19 at 20:43
- 
                    [This repo in GitHub](https://github.com/LazZiya/FileUpload) shows how to use drag & drop upload, delete files and resize images – LazZiya May 21 '19 at 04:31
1 Answers
6
            You could try to follow steps below :
1.Add a new folder to the project and call it wwwroot , and create images folder and Cars subfolder in wwwroot folder.
2.Model
public class Car
{
    public int Id { get; set; }
    public string CarName { get; set; }
    public string ImagePath { get; set; }
}
public class CarViewModel
{
    public string CarName { get; set; }
    public IFormFile Image { get; set; }
}
3.Controller
 [Route("api/[controller]")]
[ApiController]
public class CarsController : ControllerBase
{
    private readonly IWebHostEnvironment _hostingEnv;
    private readonly WebAPIDbContext _context;
    
    public CarsController(WebAPIDbContext context, IWebHostEnvironment hostingEnv)
    {
        _hostingEnv = hostingEnv;
        _context = context;
    }
    [HttpPost]
    public async Task<ActionResult> Post([FromForm] CarViewModel carVM)
    {
        if (carVM.Image != null)
        {
            var a = _hostingEnv.WebRootPath;
            var fileName = Path.GetFileName(carVM.Image.FileName);
            var filePath = Path.Combine(_hostingEnv.WebRootPath, "images\\Cars", fileName);
            using (var fileSteam = new FileStream(filePath, FileMode.Create))
            {
                await carVM.Image.CopyToAsync(fileSteam);
            }
            
            Car car = new Car();
            car.CarName = carVM.CarName;
            car.ImagePath = filePath;  //save the filePath to database ImagePath field.
            _context.Add(car);
            await _context.SaveChangesAsync();
            return Ok();
        }
        else
        {
            return BadRequest();
        }
    }
}
 
    
    
        user3235789
        
- 3
- 2
 
    
    
        Xueli Chen
        
- 11,987
- 3
- 25
- 36
- 
                    
- 
                    @Ivan , I am glad to help you resolve the issue . Could you mark my reply as an answer? This will help other people who have the same doubts to find the answer quicly .Thanks a lot ! – Xueli Chen May 29 '19 at 01:21
- 
                    @XueliChen IHostingEnvironment is marked deprecated in Core 5, and that we're supposed to use IWebHostingEnvironment - can you update your solution to show it's usage without getting a CS0051 error? – Robert Achmann Feb 19 '21 at 16:56
