Save and retrieve image (binary) from SQL Server using Entity Framework 6

by

Convert the image to a byte[] and store that in the database.

Add this column to your model:

public byte[] Content { get; set; }

Then convert your image to a byte array and store that like you would any other data:

public byte[] ImageToByteArray(System.Drawing.Image imageIn)
{
    using(var ms = new MemoryStream())
    {
        imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Gif);
    
        return ms.ToArray();
    }
}

public Image ByteArrayToImage(byte[] byteArrayIn)
{
     using(var ms = new MemoryStream(byteArrayIn))
     {
         var returnImage = Image.FromStream(ms);

         return returnImage;
     }
}

Source: Fastest way to convert Image to Byte array

var image = new ImageEntity()
{
   Content = ImageToByteArray(image)
};

_context.Images.Add(image);
_context.SaveChanges();

When you want to get the image back, get the byte array from the database and use the ByteArrayToImage and do what you wish with the Image

This stops working when the byte[] gets to big. It will work for files under 100Mb

More Related Contents:

  1. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  2. Entity Framework Core: A second operation started on this context before a previous operation completed
  3. LINQ To Entities does not recognize the method Last. Really?
  4. Bulk-deleting in LINQ to Entities
  5. .Net and Bitmap not automatically disposed by GC when there is no memory left
  6. How to do a Bulk Insert — Linq to Entities
  7. EF Data Context – Async/Await & Multithreading
  8. Entity-framework code is slow when using Include() many times
  9. The operation cannot be completed because the DbContext has been disposed using MVC 4
  10. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  11. Converting long string of binary to hex c#
  12. Can we have table without primary key in entity framework?
  13. ASP.NET Core API only returning first result of list
  14. DbContext discard changes without disposing
  15. C# binary literals
  16. User in Entity type MVC5 EF6
  17. Converting a byte to a binary string in c#
  18. Max return value if empty query
  19. Group by with multiple columns using lambda
  20. Working with SQL views in Entity Framework Core
  21. Keyword Not Supported: Metadata
  22. C# – Convert WPF Image.source to a System.Drawing.Bitmap
  23. Entity Framework Code First: How can I create a One-to-Many AND a One-to-One relationship between two tables?
  24. Entity Framework: Duplicate Records in Many-to-Many relationship
  25. Register AspNetCore 2.1 Identity system with DbContext interface
  26. The entity type ‘IdentityUserLogin’ requires a primary key to be defined [duplicate]
  27. Use both AddDbContextFactory() and AddDbContext() extension methods in the same project
  28. How to use String property as primary key in Entity Framework
  29. c# Bitmap.Save transparancy doesn’t save in png
  30. WPF – converting Bitmap to ImageSource

Leave a Comment