title: cannot convert sourcetype 'System.Linq.IQueryable<string>' to target type 'string'
body: <p>In VisualStudio 2008 I get the following error on my linq query:</p>
  
  <p>cannot convert sourcetype 'System.Linq.IQueryable' to target type 'string'</p>
  
  <p>This is the query:</p>
  
  <pre><code>  var query = (from c in model.ITEMLIST
                 select new ItemList
                          {
                            LineNo = c.LINE_NO,
                            SupplierName = from s in model.VENDOR where s.ID == c.ID_VENDOR select s.NAME
                                                       });
  </code></pre>
  
  <p>If I run the same query in LinqPad it returns with success the expected result</p>
  
  <p>I am using LinqToEntity for this. 
  In another project where I am using LinqToSql I have a similar query which runs fine.</p>