Asp.net c# sql server read binary sql field data in chunk

Question

I my database we have a varbinary field which store file content in byte.

As the file is big and reading all content in one shot leads to time-out so I want to read that data in chunk like we have write function in sql to write data using chunk.

Please suggest any idea?

Thanks

Pankaj · Accepted Answer · 2012-06-15 06:43:04Z

1

Have you looked at the FILESTREAM data type?

More info about how to do it http://weblogs.asp.net/aghausman/archive/2009/03/16/saving-and-retrieving-file-using-filestream-sql-server-2008.aspx

edited Jun 15, 2012 at 6:43

Pankaj

10.2k40 gold badges152 silver badges298 bronze badges

answered Jun 14, 2012 at 14:54

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

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

Comments

Marc Gravell · Accepted Answer · 2012-06-15 06:48:52Z

1

To do that via a simple SELECT ..., you can drop to ADO.NET, i.e. ExecuteReader, specifying the CommandBehaviour.SequentialAccess flag. Now you can call repeatedly the GetBytes method to read sequential chunks into a buffer. For example:

byte[] buffer = new byte[8040];
int bytes;
long offset = 0;
while((bytes = (int)reader.GetBytes(col, offset, buffer, 0, buffer.Length)) >0) {
    // TODO: do something with `bytes` bytes from `buffer`
    offset += bytes;
}

answered Jun 15, 2012 at 6:48

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Collectives™ on Stack Overflow

Asp.net c# sql server read binary sql field data in chunk

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related