Unblockable SqlBulkCopy many tables in ASP.NET MVC

asp.net-mvc multithreading sqlbulkcopy

Question

I need to use SqlBulkcopy to copy numerous tables from one database to another from an ASP.NET MVC application.

I do not trust users since the procedure takes longer than two minutes.

Which method, even if the user closes the window, is the best for completing the complete process?

Thank to everybody.

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

Accepted Answer

In an ASP.NET application, avoid such processes. To comprehend why, read this piece. Use a Windows service, a scheduled console program, or something similar to do this action in a separate process from your 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