C# - How to read an sql file and execute queries ?

Advertisement

I have a .SQL file (about 200mb) which has only insert statements for a particular database table. I want to read about a 10,000 lines at a time and then execute them in bulk. After that, the next 10,000...until the last insert. How do I do this ?

I am using c#, .NET 3.5 and visual studio 2008