Syed Ali

Syed Ali

  • NA
  • 47
  • 2.8k

Ms access database and ORM in C#

Jun 25 2019 9:07 AM
Hi, I have to work with the legacy application built using .Net and MS access database. Currently data reterival speed is very slow which needs to be upgraded.
I Searched for the options of using ORMs with MS Acess. EntityFramework was my first choice but sadly it not compatible with Ms Access database first. NHibernate and Dapper are the two left options. With dapper once cannot use LINQ, but according to Users of dappers its very fast for reterving the data. Though i have not tried it yet

Now i would like know the your suggestion regarding my situation. Main task is to increase the reterival speed. Can stored procedures be an option?

Thanks 

Answers (1)