title: Upload CSV File then Mapped to Tables in Database
body: <p>How can we upload a CSV file through web(ASP.NET MVC C#) and mapped the column in CSV table to our tables in database</p>
  
  <p>Example:</p>
  
  <pre><code>CSV File:
  Username,Address,Roles,Date
  </code></pre>
  
  <p>How to add all the value in 'Username' column to User Table, Name Column ?</p>
  
  <p>Value in 'Address' column to AddrDet Table, Address Column?</p>
  
  <p>Value in 'Roles' column to RolesDet Table, Roles Column?</p>
  
  <p>AND choose the CSV column to be added to database? (So not all column in CSV will be taken)</p>
  
  <p>using ASP.NET MVC C#</p>
  
  <p>Because all I know is when the CSV uploaded, it will create DataTable specially for CSV and all the column in CSV will be uploaded</p>
  
  <p>Thank You</p>
  
  <p>I'm using MVC and EF DB FIRST</p>