CODEWITHSUNDEEP
c#entity-frameworkms-accessormoledb
Ian Vink
Ian Vink

Reputation: 68740

ORM and Microsoft Access options

Our ASP.NET MVC site uses SQL Server and the Awesome LLBLGen ORM tool to write the Entity Framework for it. Perfect.

We just got a requirement that we need to allow the users to upload an Access 2000 database with just dumb tables. Then update those tables and let the user download the Access file again. No flexibility :(

I am not allowed to alter the Access table to link it to SQL or add objects like procs.

Am I forced to use System.Data.OleDb and raw sql to modify the Access tables ( "Update table blah blah...")? We've been using ORMs for so long we don't know our options.

Upvotes: 1

Views: 1245

Answers (1)

Ian Vink
Ian Vink

Reputation: 68740

I found that the Dapper project, open source, worked for our simple needs.

Upvotes: 1

Related Questions