title: Sequence operators not supported for type 'System.String'.
body: <p>There is a composite primary key on the columns in the where condition of the below code so there can be only one possible return value. I am returning by <code>SingleOrDefault</code>  but at run time I am getting the error in the question title: "Sequence operators not supported for type 'System.String'." I'm pretty new to LINQ so might have got the syntax wrong? Any help appreciated</p>
  
  <pre><code> using (myContext Data = new myContext())
      {
          string Result = (from d in Data.myTable 
                      where d.textColumn == myDropDownList.SelectedValue &amp;&amp; d.intColumn == 1
                      select d.anotherTextColumn.SingleOrDefault()).ToString();
      }
  </code></pre>