If you want to use MSAccess, do not use EF. If you want to use EF, do not use MSAccess. Entity Framework does not support Access. But you can upgrade to SQL Express (for free) and use EF for your applications. SQL Express is free and sufficient for small databases.
Alternatively, if you want a desktop database, you can use SQLite.NET for sqlite supports EF.
source
share