Unifying BlogEngine, BlogSvc and Oxite MVC – CMS Table Name Standardization

Topics: Business Logic Layer
Feb 17, 2009 at 4:09 PM
Edited Feb 18, 2009 at 1:31 AM
Here’s discussion on Oxite table name standardization:
Oxite - Table name cleanup project

If you are a contributing to BlogEngine, BlogSvc, SubText or dasBlog, please outline your project’s current table names along with proposed updates for a standard set of table names across all CodePlex blog and CMS projects.  Common tables like “User” and “Post” will allow Web 2.0 functionality to be managed across applications without complexity.  For CodePlex projects providing custom additions, add-on tables can optionally contain the application name.  Specify which blog tables you consider custom add-ons to omit from the common table naming standard.  

This is an opportunity to improve upon the “Aspnet_Users” and “Aspnet_Roles” tables (which were not used by Oxite) by creating a standard for simple “User” and “Role” tables and relation tables like “UserRole” instead of “Aspnet_UsersRoles.”  Plural objects are now created by Visual Studio’s dynamic data wizard, so plural table names are no longer used.  This eliminates uncertainty regarding when to append "s" in relation tables and allows tables to be distinguished from dynamic objects.