Last post Nov 24, 2015 10:42 AM by jimmy69
Nov 23, 2015 11:57 AM|jimmy69|LINK
is it possible to use access as database with entity framework ?
I've search on internet but nothing exist ..?!
Any idea ?
I would like to create a little project (management of person, contact, meeting, ..) for someone
Nov 23, 2015 12:28 PM|sreejukg|LINK
You can use the third party providers out there to use access with entity framework.
Nov 23, 2015 12:29 PM|uid895650|LINK
Entity Framework does not support OLEDB connections, so your connection string will not work. It is practically impossible to get Entity Framework to collaborate with MS Access. You will either need to dump the MS Access part of your design, or the
Entity Framework part.
However, in the past I have used Dapper as our ORM with repositories when working with MS Access. It's fantastic. So looking at a 3rd party is your best bet if you really need to stick with MS Access e.g. https://jetentityframeworkprovider.codeplex.com/
The closest you could get using MS Access is using strongly typed datasets and Linq-to-DataSet http://msdn.microsoft.com/en-us/library/bb386977.aspx
Or, considering going with SQL Express instead (it's free) http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx
Hope this helps.
Nov 24, 2015 10:42 AM|jimmy69|LINK
thanks for your time that's exactly what I want ..
I've just to realize a little project 3 tables in some forms ..