I am new to ASP.NET Dynamic Data and trying to find out if Dynamic Data technology could accomadate a use-case when DB schema changes at run-time. Example: Can and how Dynamic Data application templates can pick-up a new field that was added to a DB at run-time using Transact SQL "ALTER TABLE 'table' ADD 'column' ..."  ?

le_chocolatier:

use-case when DB schema changes at run-time

DD loads the metadata at Application Start and cannot be reloaded without restarting the app.

However in the latest Preview (4) on codeplex you can a simple DD sample which uses simple classes to do the auto scaffolding.

There are new method calls that in DD Preview 4 that can be used to reset the metadata cache. MetaTable.ResetMetadata() but thats only for metadata. Since dd is based on the clr classes and not SQL directly (though you could write a provider that did that) you'd have to find some way of regenerating data model.

davidfowl:

There are new method calls that in DD Preview 4 that can be used to reset the metadata cache. MetaTable.ResetMetadata()

That's an interesting bit of news David is that new tp the refresh?

It's actually been there for a while I think we just failed to communicate it. There is MetaColumn.ResetMetadata() also.

Let me know if you need any more details on this.  I'm putting together a sample of changing metadata at runtime :).

Hope this helps

 That's cool David let me know when you have your sample ready and I have a look.