Support to Microsoft Access database for Entity Framework in VS2008 ?
-
Hi, Does anyone know what I should install for having support to Microsoft Access database in Entity Framework in Visual Studio 2008 ? Currently, I see only SQL Server and SQL Server Compact Edition as available database type when I want to add an "ADO.NET Entity Data Model". Thanks, Fred
-
Hi, Does anyone know what I should install for having support to Microsoft Access database in Entity Framework in Visual Studio 2008 ? Currently, I see only SQL Server and SQL Server Compact Edition as available database type when I want to add an "ADO.NET Entity Data Model". Thanks, Fred
Access is not supported by the Entity Framework. You can use just about any other database, except Access. You can find providers for 3rd party databases here[^].
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
Hi, Does anyone know what I should install for having support to Microsoft Access database in Entity Framework in Visual Studio 2008 ? Currently, I see only SQL Server and SQL Server Compact Edition as available database type when I want to add an "ADO.NET Entity Data Model". Thanks, Fred
-
There's an upgrade-wizard in your Access-database that converts your database to SQL Server. You can then use SQL Server Express (a free download) in combination with VS2k8 and the EF. HTH,
I are troll :)
Thanks, but this feature appears only in Access 2007, not in Access 2003. Thanks for the tips. But the idea is to use a database in a file, so my program would be easy to install for each user. What do you think of using SQL Server Compact Edition instead ? It seems to be greater than Access.
-
Thanks, but this feature appears only in Access 2007, not in Access 2003. Thanks for the tips. But the idea is to use a database in a file, so my program would be easy to install for each user. What do you think of using SQL Server Compact Edition instead ? It seems to be greater than Access.
WolveFred2 wrote:
this feature appears only in Access 2007, not in Access 2003
The feature is older then Access 2007. Might it be that you haven't installed all wizards during the installation of Office 2003?
WolveFred2 wrote:
What do you think of using SQL Server Compact Edition instead ? It seems to be greater than Access.
I'd recommend SQLite :) SQL CE is missing some features that you may have grown accustomed to in Access. OTOH, installing a SQL Server instance might be overkill if you're just going to save a bit of data locally.
I are troll :)
-
WolveFred2 wrote:
this feature appears only in Access 2007, not in Access 2003
The feature is older then Access 2007. Might it be that you haven't installed all wizards during the installation of Office 2003?
WolveFred2 wrote:
What do you think of using SQL Server Compact Edition instead ? It seems to be greater than Access.
I'd recommend SQLite :) SQL CE is missing some features that you may have grown accustomed to in Access. OTOH, installing a SQL Server instance might be overkill if you're just going to save a bit of data locally.
I are troll :)
SQL Lite ? Does this work whith Entity Framework ? For Access, I didn't use specific features. I prefere having a DBMS that looks like SQL Server.
-
SQL Lite ? Does this work whith Entity Framework ? For Access, I didn't use specific features. I prefere having a DBMS that looks like SQL Server.
Site says:
Support for the ADO.NET 3.5 Entity Framework Supports nearly all the entity framework functionality that Sql Server supports, and passes 99% of the tests in MS's EFQuerySamples demo application.
You might want to stick to SQL CE, as this already shows up default in your IDE :)
I are troll :)