title: LINQ to SQL - Get a string from a Var
body: <p>I'm new to LINQ to SQL world - So I'm sorry if the question is stupid :) - I just could not find any answer on the internet:</p>
  
  <p>I have a table with two columns - "Batch_Name" and "Batch_id".
  The user select the batch id and the application needs to return its name.</p>
  
  <p>I have this C# Code to extract the batch name according to the batch id ("myBatchNum"):</p>
  
  <pre><code>        var thisBatch = from x in gridDB.batches
                          where x.batch_id == myBatchNum
                          select new { x.batch_name };
  
  
          lblBatchName.Text = thisBatch.First().ToString();
  </code></pre>
  
  <p>This extract from the proper batch name, but when I try to display the name on a label control, I get this result ("NightBatch is the name in the DB):</p>
  
  <p>{batch_name = NightBatch }</p>
  
  <p>How do I extract the batch name from "thisBatch" properly to the label control?</p>
  
  <p>Thank you so much,
  Nim.</p>