Reading data from Excel sheet using entity framework

Question

We have some info that is contained within an excel sheet. the excel sheet contains two columns; customer name + customer balance. Now I need to display this info inside my asp.net mvc view, basically to query the excel sheet based on the customer name and display its total balance inside my view.

In this way we will be uploading the excel sheet inside our system each month or each day , and we will be querying the excel sheet instead of the DB. So is this possible using EF ? or it is better to exact the data from the excel sheet and add it to Datable inside the database? Thanks

Solution

You can use LinqToExcel , this provides normal linq structure to query excel sheets