CODEWITHSUNDEEP
asp.net-mvcdatabase-designc#-4.0orm
TedOnTheNet
TedOnTheNet

Reputation: 1102

How to do deal with an evolutionary design of a web-site database?

I am about to start my first project on an ASP.NET MVC 3 web-site. This site will have data storage and I am wondering what's the best way to deal with the evolutionary design of the database behind the web-site - after the site launches, it will be extended and it will keep on growning thus database refactoring will be an issue. What's the best way to deal with this "problem"? I was thinking of using an ORM like NHibernate or Entity Framework, but neither of them support evolutionary database design.

Any help is appreciated.

Upvotes: 2

Views: 151

Answers (1)

Michael Maddox
Michael Maddox

Reputation: 12489

Are you looking for migrations support for .NET primarily?

https://stackoverflow.com/questions/313/net-migrations-engine

https://stackoverflow.com/questions/8033/database-migration-library-for-net

.NET migrations: Setup and migrate multiple databases at runtime

I can assure you that developers are doing evolutionary database design with both NHibernate and Entity Framework, so it's entirely possible. Maybe you want a highly tooled, automated process though?

Upvotes: 2

Related Questions