Inserting data from csv files into SQL Server from C#.3 different ways.

There are 3 different ways you could insert data in bulk to the SQL Server database tables from your C# application.

BULK INSERT 
               http://msdn.microsoft.com/en-us/library/ms188365(v=sql.105).aspx

BCP
               http://msdn.microsoft.com/en-us/library/ms162802.aspx

SQLBULKCOPY
               http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

Examples to follow in future posts.