asp.net dynamic data with access

Question

can you use ms access as the backend of a asp.net dynamic data project website. Any links or examples?

If you're using an MDB as a back end, it's not ACCESS -- it's only JET. — David-W-Fenton
– David-W-Fenton, Commented Nov 16, 2008 at 20:58

hangy · Accepted Answer · 2008-11-15 22:19:35Z

1

At first I thought that this should be possible, because .NET generally supports ODBC and thus connecting to a MS Access database. Linq to SQL and the ADO.NET Entity Framework seem to be the most popular data providers for ASP.NET Dynamic Data. However, there seem to be some issues which require modifications to the data providers in order to make them compatible to EF, and Linq 2 Sql supports MS SQL Server only. Because of that, just MS SQL Server and MS SQL Server Compact seem to support EF at this moment. There is one last hope, though. According to this post on the Microsoft forums, you could implement your own Entity Framework Provider to support Access or ODBC in general.

answered Nov 15, 2008 at 22:19

hangy

10.9k6 gold badges46 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fionnuala Over a year ago

There is a thread here stackoverflow.com/questions/194528/…

Collectives™ on Stack Overflow

asp.net dynamic data with access

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related