title: Linq to Xml : Exception -The ' ' character, hexadecimal value 0x20, cannot be included in a name
body: <p>This is my Entity Class with an Entity :</p>
  
  <pre><code>[Table(Name = "CLINICAL_ITEM_MASTER")]
  public class ClinicalItemMaster
  {
      [Column]
      public int CLIENT_INPUT_MHS_ID { get; set; }
      [Column]
      public Guid CLIENT_INPUT_MHS_GUID { get; set; }
      [Column]
      public string ITEM { get; set; }
      [Column]
      public int ITEM_ID { get; set; }
      [Column]
      public string ITEM_NUMBER { get; set; }
      [Column]
      public string CATEGORY { get; set; }
      [Column]
      public string DESCRIPTION { get; set; }       
      [Column]
      public DateTime? CREATE_DTTM { get; set; }
      [Column]
      public DateTime? UPDATE_DTTM { get; set; }
  }
  </code></pre>
  
  <p>And Here I am accessing that Database Table data using Linq to XML(SQL) approach :</p>
  
  <pre><code>private XElement GetClinicalItemMaster()
  {
      try
      {
          using (MyDatabase db = new MyDatabase())
          {
              return new XElement("CLINICALITEMMASTER",
                     from cim in db.TblClinicalItemMaster                           
                     select new XElement("Record",
                         new XElement("CLIENT_INPUT_MHS_ID", cim.CLIENT_INPUT_MHS_ID),
                         new XElement("CLIENT_INPUT_MHS_GUID", cim.CLIENT_INPUT_MHS_GUID.ToString()),
                         new XElement("ITEM ", cim.ITEM),
                         new XElement("ITEM_ID ", cim.ITEM_ID),
                         new XElement("ITEM_NUMBER ", cim.ITEM_NUMBER.ToString()),
                         new XElement("CATEGORY ", cim.CATEGORY.ToString()),
                         new XElement("DESCRIPTION ", cim.DESCRIPTION),
                         new XElement("MFG_CODE ", cim.MFG_CODE)      ));
          }
  </code></pre>
  
  <p>But here I am getting this error:</p>
  
  <blockquote>
    <p>The '[white space]' character, hexadecimal value 0x20, cannot be included in a name.</p>
  </blockquote>
  
  <p>The column is <code>cim.ITEM</code>, as per my analysis its a Non-Nullable column but While getting data from DataBase getting Null(The data per this column is Null)</p>