Unblockable SqlBulkCopy many tables in ASP.NET MVC

asp.net-mvc multithreading sqlbulkcopy

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.

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

Thanks all!!

1
0
12/20/2011 4:52:07 PM

Accepted Answer

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, ...

2
12/21/2011 8:39:04 AM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow