Home / Questions / 210168
Accepted
Wilmilcard
Asked: 2020-11-03 05:28:23 +0800 CST 2020-11-03 05:28:23 +0800 CST

What is the best way to store an image in SQL database?

  • 772

I have a UWP app and I want to display images, but those images have to be saved in the database, I don't want to use a storage URL, I want to not de-serialize them, upload them serialized to the database and fetch and de-serialize them. I just don't know what type of field to use and what can be serialized.

c#

1 Answers

  1. Best Answer

    If you use one you webapicould send the serialized image to base64, using something like this

    string base64String = Convert.ToBase64String(imageBytes);

    then by having the image string you could put it as part of the json that you send when invoking the webapi

    On the webapi side you would use

    byte[] array = Convert.FromBase64String(imageString);

    to have the byte array that you would use in the parameter of the INSERT that you would make in the db (or in the property of the class if you use entity framework)

    If you use any library to serialize how to be you json.netcould apply something like this

    How do I Serialize object to json using json.net which contains an image property

    basically it is a converter class that tells you in the serialization how to treat the image property

    public class ImageConverter : JsonConverter
{
    //implementacion
}

    you use it in class

    public class Person
{
    [JsonConverter(typeof(ImageConverter))]
    public Image photo { get; set; }
}
    • 0