I take it you're after storing the data not in a single text column but properly interpreted to separate columns. If this is true you can interpret the data either in your application or in the database.
For example you can read the CSV using File.ReadAllLines and then using string.Split, you can split the data on each row. After that you can store the data into proper tables and columns.
On the other hand you can do the splitting also in SQL Server, for example you can create a small stored procedure which would have a varchar parameter for the csv data and the procedure would essentially do the same things.
The third option could be that you read the file using SQL Server and insert the data directly from the CSV file to the tables. For this you could use OPENROWSET. For an example, see;
http://www.databasejournal.com/features/mssql/article.php/10894_3331881_2[
^]