c# How to upload multiple files to SQL Server database?

Question

Given:

c# WinForms application
more than 1000 .txt, .pdf, .doc files

SQL Server 2008 table

create table docs
(
    id int not null identity primary key,
    filename nvarchar(255),
    filecontent varbinary(MAX),
    filetype nvarchar(10),
)

I know how to upload file by file using INSERT or MERGE, but it is a long operation.

How to effectively fast upload many files into the table?

use SqlBulkCopy operation so that you can insert multiple records faster. — Naveen Katakam
– Naveen Katakam, Commented Jul 24, 2015 at 9:49
But the question is: how to read from source when SqlBulkCopy using? I understand if the source is another table but what if it is file directory ? — ZedZip
– ZedZip, Commented Jul 24, 2015 at 10:29

Naveen Katakam · Accepted Answer · 2015-07-24 10:53:19Z

1

use SqlBulkCopy operation so that you can insert multiple records faster.

answered Jul 24, 2015 at 10:53

Naveen Katakam

4011 gold badge9 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

c# How to upload multiple files to SQL Server database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related