How to use SubSonic with MS Access database

Question

Is it possible to use subsonic with MS access MDB files?

Answer 1

Its possible, the DataProvider is here

https://github.com/subsonic/SubSonic-2.0/blob/master/SubSonic/DataProviders/AccessDataProvider.cs

together with the full project of subsonic.

Answer 2

From the looks of things, no. http://forums.subsonicproject.com/forums/t/2968.aspx Looks like an 'offline beta' was created, but looking at the thread there, looks like things ran into problems. Access really is a different animal (it's a faux-db, for goodness sakes), so anyone willing to write a DAL like Subsonic would be targeting the real deal, like Oracle, MySQL, and MS SQL. Any reason why you aren't at least using one of the Express Editions of MS SQL Server? You'll certainly get more mileage, scalibility, and compatible tools by going that road.