I have attached a file with the DDL so you guys can create a little schema.

I have also attached a screen shot of where the finish info is coming from, The color picker is primitive and is, for now, only to demonstrate that I am not supplying per-defined finish / color data to the user.

The thing to note is that each horizontal, vertical, jamb, each piece of the elevation can be any color and the user building the elevation has much control over what they're building.

In a perfect world it would be nice to have a finish datatype that could easily be mapped to my c# code, "Like I've got it below"

You'll also notice the in my finish table that the fields left,right, top, bottom now should make since since a bay has a left,right,top,bottom, and a door has a left, right, top, but no bottom, and the leaf to the door has a left, right, top, bottom, ect..

I have all the data packaged up perfectly coming from the client i just need for it to make since in the database as well. I am using the new webAPI in .net and MVC 4.5. This data comes from the client as JSON and maps perfectly into my classes.

Below is a few classes that show how the finish object as a property to the bay object.

public class Elevation

{

public int ID { get; set; }

public String Name { get; set; }

public Size Size { get; set; }

public ICollection<Bay> Bays { get; set; }

}

public class Bay

{

public int ID { get; set; }

public int Position { get; set; }

public Siteline Siteline { get; set; }

public Finish Finish { get; set; }

public Size Size { get; set; }

public Glass Glass { get; set; }

public ICollection<Horizontal> Horizontals { get; set; }

public Door Door { get; set; }

}

public class Finish

{

public string Left { get; set; }

public string Right { get; set; }

public string Top { get; set; }

public string Bottom { get; set; }

}

Here is a link to a few demo videos that i posted on youtube last week. I am not here to try to promote anything, but if it can help you guys help me approach this correctly that makes since.

http://www.youtube.com/user/storefrontsystem

In a nutshell what is the best approach for my finish table entity, so that it makes since when mapping the data to my c# code that i've provided.

Thank you very much! As always... 😉