title: MVC Database Model Dynamic Properties
body: <p>He guys, so I need a little help with my database model for an mvc project I am working on. </p>
  
  <p>Here is the situation:</p>
  
  <p>I have a table called dbo.Clients that has the columns ClientName, PlanName, PlanPrice, PlanStartDate, PlanEndDate, and IsArchived.</p>
  
  <p>For the fields ClientName, and IsArchived are only going to have one value in them that is subject to change. However, each client will have multiple PlanName, PlanPrice, PlanStartDate, and PlanEndDate values. </p>
  
  <p>I have a ClientModel, ClientViewModel, ClientRepository, ClientService, and ClientController set up that successfully puts values into the database from the view.</p>
  
  <p>The problem:</p>
  
  <p>The way that I have done this is that I can only use one value for PlanName, PlanPrice, PlanStartDate, and PlanEndDate. For example lets say a client has bought Plan 1 and Plan 2 but I cannot store more than 1 plan.</p>
  
  <p>What I want to do is make another table called Plans but I'm not quite sure how to use that in the MVC way to storing multiple values per client. </p>