SqlBulkCopy multiple tables in ASP.NET MVC unblockable

Question

I have to make a multiple copy of tables from one database to other with SqlBulkcopy from an ASP.NET MVC application.

The process takes more than 2 minutes, and I do not trust users.

Which is the best way to do the entire process, even if the user closes the window?

Darin Dimitrov · Accepted Answer · 2011-12-21 08:39:04Z

2

Don't do such processes in an ASP.NET application. Read this article to understand why. So do this task in a separate process than your application: a Windows service, a scheduled console application, ...

answered Dec 21, 2011 at 8:39

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

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

1 Comment

cdiazal Over a year ago

Thanks a lot, I have read It and looks like I am going to make it in a different way. Also I have found an answer made by you that matches to my actual question stackoverflow.com/questions/3637649/…

Collectives™ on Stack Overflow

SqlBulkCopy multiple tables in ASP.NET MVC unblockable

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related