How to read blob data from SQL Server Image field using Dapper?

Question

I need to read blob data into a memory stream from an Image type column from an SQL Server database. How can I do this using Dapper?

I was reading the Dapper manual but was unable to find information about this.

UPDATE: I need to read the data from the database (from a query). All the links suggested so far has information about how to store the blob in the database.

Did you go through the following link : dapper-tutorial.net/knowledge-base/9634587/… — Rasanjana N
– Rasanjana N, Commented Feb 4, 2019 at 23:50
Yes I saw both but neither seems to be relevant. I need to read from the server using a query. The links explain how to do it when need to update and insert above 8k data. — RM.
– RM., Commented Feb 5, 2019 at 8:08
image is the deprecated name for varbinary(max). Don't use image — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Feb 5, 2019 at 8:34
@AmitJoshi that question has no relevant answer. It's far too old anyway - Dapper went through a lot of changes in the last 7 years — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Feb 5, 2019 at 8:37
@RasanjanaN that's just a reposting of a very old SO question with no relevant answer. That site is NOT an official Dapper site — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Feb 5, 2019 at 8:39

µBio · Accepted Answer · 2019-08-08 13:26:00Z

2

Figured it out. The result dynamic type is a byte[].

var row = con.QueryFirst("SELECT BLOBFIELD FROM TABLE WHERE ID = 1");

byte[] bytes = drawings.BLOBFIELD;
using (var stream = new System.IO.FileStream(@"C:\Temp\Test.dat", System.IO.FileMode.CreateNew))
  stream.Write(bytes, 0, bytes.Length);

edited Aug 8, 2019 at 13:26

µBio

10.8k6 gold badges41 silver badges56 bronze badges

answered Feb 5, 2019 at 8:27

RM.

2,04323 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Panagiotis Kanavos Over a year ago

In other words, create an object with a byte[] field. The rest of the code isn't relevant. This won't work with large binaries though

RM. Over a year ago

@PanagiotisKanavos how it can be made to work with large binaries?

Collectives™ on Stack Overflow

How to read blob data from SQL Server Image field using Dapper?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related