14
I am in search of an good approach to import data from ms access and bind it to any Model of an MVC pattern
Here is the approach which we are thinking to following
Approach 1 :
- Open Ms Access file
- Open database
- Open all tables
- Import data of all tables and bind them to an model
- Close all tables
- Close database
- Close file
Approach 2 :
- Connect Ms Access Database in Asp.Net MVC
- Open the database
- pass an query
- fetch data and bind it to model
- close database
Which approach is better and how I can Implement it?
UPDATE: I have implemented Approach 2 and its works fine , does anyone know how to implement Approach 1