Today I was tackling with a problem. It was about inserting and updating 200000 records of data. I just wanted to find a solution rather than writing Store Procedure. I just searched on the web and found a library named Z.BulkOperation
I dare say I had never seen handling this amount of data nicely in application level without even using a line of SQL code, it's awesome!
Fire up visual studio and a simple console or MVC application and install the package via:
PM> Install-Package Z.BulkOperations...