How to download file from SQL Server database chunk by chunk in asp.net core?

[pnrBehnamm]

We wrote file sharing web application, and we store data in SQL Server database. We need to download a file from database chunk by chunk, for example, each chunk is 1MB. If data is 10MB, we must download it base on ten chunks. and finally, we must merge into one file.

I found a good article. But unfortunately, it's not about downloading a file from the database. https://dejanstojanovic.net/aspnet/2018/march/download-file-in-chunks-in-parallel-in-c/

[gfoidl]

Are you aware of SqlFileStream?

BTW: nowadays I encourage you to don't store files in the SQL Server -- especially for a file sharing web application. There a (much) better solutions like blob storages, etc. that suit that needs and have an already established infrastructure. It's less effort than any self-baken solution, so you can focus on your business 😉

[TehWardy]

This feels like a stack overflow question.

[pnrBehnamm]

I didn't build an architecture of this project I must accept this some storing in database. But I have a question about the security of using SqlFileStream. I think the idea behind storing files in the database is about security concern. Can hacker access data outside of the database if we use SqlFileStream?

Thanks a lot.

[pnrBehnamm]

This feels like a stack overflow question.

Yes, exactly.

[gfoidl]

Can hacker access data outside of the database if we use SqlFileStream?

This depends on how you "expose" the stream. We don't know any details of your architecture, so it's hard to give concrete answers.

Please follow @TehWardy's advice and ask this question on SO. Here is not the proper place for this.

[javiercn]

@pnrBehnamm Thanks for contacting us.

As mentioned in the comments, this is a question better suited for stackoverflow.

[TehWardy]

@pnrBehnamm if you drop the stack overflow question link in here i know a few SQL guys who might be able to help so i'll send it their way.