title: Need recommendation for a table structure
body: <p>I have an entity which has 4 different types of property that could have only one value for each case which are boolean, decimal, string or text. I don't want to define the table with 4 boolean, decimal, nvarchar and ntext columns. What would you recommend to cover this case? </p>
  
  <p><strong>Update:</strong></p>
  
  <p>I'm using MS SQL Server.</p>
  
  <p>Here is the class definition:</p>
  
  <pre><code>public class Foo
  {
      public int Id { get; set; }
      public string Description { get; set; }
      public bool BooleanValue { get; set; }
      public decimal DecimalValue { get; set; }
      public string NVarcharValue { get; set; }
      public string NTextValue { get; set; }
  } 
  </code></pre>