If you want all the data from the excel file to go to a database dynamically the best way to be about this business is use Entity Framework Codefirst.
You can store your data in some List objects. Then you can enumerate through the list and you can insert the data in the data context object using a model object. When you save the changes to the DbContext object then entity framework will create a data for you in the background and you don't have to worry about a thing.
There are some great tutorials on Entity Framework Codefirst in:
1. pluralsight.com
2.
An article in codeguru[
^]
3.
An article in codeplex[
^]
4.
An article by Scott Guthrie[
^]
The last 2 are web based, but you will find conceptual explanation in the first two.
Submit an article or tip