asp.net core webAPI

Question

How to store image in database using asp.net core api?

Vishal Yelve · Accepted Answer

Hi Tahir,
I am saving file at location and saving file name in db.
[Route("SaveFile")]
[HttpPost]
public JsonResult SaveFile()
{
try
{
var httpRequest = Request.Form;
var postedFile = httpRequest.Files[0];
string filename = postedFile.FileName;
var physicalPath = _env.ContentRootPath + "/Photos/" + filename;
using (var stream = new FileStream(physicalPath, FileMode.Create))
{
stream.CopyTo(stream);
}
return new JsonResult(filename);
}
catch (Exception)
{
return new JsonResult("anonymous.png");
}
}
You can refer to my code --> https://github.com/vyelve/.NETCoreWebAPICRUD
OR
[BindProperty]
public IFormFile ImageFile { get; set; }
public string Msg { get; set; }
public static readonly List ImageExtensions = new() { ".JPG", ".BMP", ".PNG" }; //to restrict file extensions
if (HttpContext.Request.Form.Files.Count > 0)// check if the user uploded something
{
ImageFile = HttpContext.Request.Form.Files.GetFile("file_Main");
if (ImageFile != null)
{
var extension = Path.GetExtension(ImageFile.FileName);//get file name
if (ImageExtensions.Contains(extension.ToUpperInvariant()))
{
using var dataStream = new MemoryStream();
await ImageFile.CopyToAsync(dataStream);
byte[] imageBytes = dataStream.ToArray(); // you can save this to your byte array variable and remove the 2 lines below
string base64String = Convert.ToBase64String(imageBytes);
User.UserPicture = base64String; // to save the image as base64String
}
else
{
Msg = "image format must be in JPG, BMP or PNG"; //Custom error message
return Page();
}
}
}
}

Sachin Singh · Answer

1. use below classes
public class Attachment
{
[Key]
public int id { get; set; }
[Column(TypeName = "nvarchar(50)")]
public string FileName { set; get; }
[Column(TypeName = "nvarchar(50)")]
public string Description { set; get; }
[Column(TypeName = "varbinary(MAX)")]
public byte[] attachment { set; get; }
}
public class AttachmentViewModel
{
public string FileName { set; get; }
public string Description { set; get; }
public IFormFile attachment { set; get; }
public List attachments { get; set; }
}
2. create following extension methods (use for professional projects)
public static string GetContenttype(string fileName)
{
var provider =
new Microsoft.AspNetCore.StaticFiles.FileExtensionContentTypeProvider();
string contentType;
if (!provider.TryGetContentType(fileName, out contentType))
{
contentType = "application/octet-stream";
}
return contentType;
}
public static string CreateUniqueFileExtension(string fileName)
{
fileName = Path.GetFileName(fileName);
return Path.GetFileNameWithoutExtension(fileName)
+ "_"
+ Guid.NewGuid().ToString().Substring(0, 4)
+ Path.GetExtension(fileName);
}
public static byte[] GetByteArrayFromImage(IFormFile file)
{
using (var target = new MemoryStream())
{
file.CopyTo(target);
return target.ToArray();
}
}
3. use below code in your api method
var uniqueFileName = SPClass.CreateUniqueFileExtension(model.attachment.FileName);
var uploads = Path.Combine(_hostingEnvironment.WebRootPath, "attachment");
var filePath = Path.Combine(uploads, uniqueFileName);
model.attachment.CopyTo(new FileStream(filePath, FileMode.Create));
//save the attachment to the database
Attachment attachment = new Attachment();
attachment.FileName = uniqueFileName;
attachment.Description = model.Description;
attachment.attachment = SPClass.GetByteArrayFromImage(model.attachment);
_appContext.attachments.Add(attachment);
_appContext.SaveChanges();
//where model is viewModel as parameter of your api