Last post Jul 09, 2010 10:59 AM by TimSaunders
Jul 08, 2010 09:14 PM|TimSaunders|LINK
I am working on a web-based system where the end-user needs to be able to define the properties of a Widget (color, width, height, etc.) and then the user needs to be able add/edit/delete Widgets with the properties that were defined.
Take Homes for example: The user needs to define a Category named "Homes" and then setup the properties of a Home (Sq. Feet, Bedrooms, Bathrooms, Lot Size, etc). Now, someone can go in and start entering the homes into the site.
It would be nice if the system would:
Instead of having a table for Homes and a table for Cars and a table for Network Devices, I want to have one set of tables hold Categories, CategoryProperties, CategoryPropertyValues or something like that.
I would assume that NewEgg or other sites like that are developed this way. It just seems crazy to create separate code for separate Categories of items.
There has to be something like this available, but I cannot seem to find the right words to use in Google to find it. It may be that one of the eCommerce solutions would allow this, but I am not overly familiar with them.
Can anyone point me in the right direction?
Thanks in advance!
Jul 09, 2010 05:01 AM|formationusa|LINK
besides the adventureworks database, checkout this website, it is full of different realworld database schemas :
I hope this helps
Jul 09, 2010 10:59 AM|TimSaunders|LINK
That is a cool site. But, what I am looking for is a "Starter Kit" that has the ASP.Net pages and database structure with it. This would think that this would exist somewhere.