ASP.net RESTful Web API & SPA Angular JS app

Could someone suggest the best design pattern for the following scenario:

• Single Page Application in ASP.net using angular JS
• Needs Web API RESTful Interface
• Needs to manage CRUD on SQL tables that change often (i.e. unable to generate models/ controllers that match the schema)
• Need to be able to specify which CRUD options are available on a given schema.
• Needs user management

I would normally use MVC, however I am not sure this is sensible or possible given the schema of the database can change from day to day. This isn’t too dissimilar to what I need to achieve: https://www.tablesmarteditor.com/ , however code wise is unsuitable to the above scenario.

Advice on how to tackle the above would be greatly appreciated.