Two Ways to Design a Database for a .NET-based CMS

When developing a .NET-based content management system, there are a many ways to logically set up your database. However, in most cases, one of two approaches will work. The first, the fixed data model, uses the approach that the content you will display will always contain the same data elements. This approach works well if you are modeling your CMS after a newspaper or magazine, and it's easy to develop. The second approach, the template data model, is a template-driven system where the data elements are chosen based on the Web page template selected. This system provides more flexibility.

This article from Builder.com and author Stephen Fraser takes a look at how both of these approaches will work with a simple CMS that displays news articles for a company Web site.