title: LINQ to SQL: how to set a caption for columns(alias) of table in Lambda Express
body: <p>I use the SQL Management Studio for create database
  I create a table and create columns of table
  Names of columns are on the English language like "test_ID"</p>
  
  <p>in the server side when  run a query(linq to sql)  and got the dataTable result
  server send  that dataTable to client side</p>
  
  <p>In the side client, I set the dataTable to a DataGridView<br>
  When  DataGridView show that table, caption  columns are same names columns  that I create in the SQL  management for my table</p>
  
  <p>but I want show a another text(caption ) for columns with another language (for example my column name is “Test_Id” but a caption text for column that i want show to the DGV is “شمارنده”  In the Farsi language)</p>
  
  <p>and I don’t set text Columns(or caption ) in the client side, I want set a label text(caption ) for all columns in the SQL management.</p>
  
  <p>in the T-SQL  under syntax is true</p>
  
  <pre><code>select yourFirstColumn as TheColumnNameYouWant1, yourSecondColumn as TheColumnNameYouWant2
  from yourTable
  </code></pre>
  
  <p>but i whant a Answer In the linq express (Lambda express)
  like sample code:</p>
  
  <pre><code>var obj2 = GP.TestTables.Select(x =&gt; new {  x.name  });
  </code></pre>
  
  <p>i can alias column like this</p>
  
  <pre><code>var obj2 = GP.TestTables.Select(x =&gt; new {  **alias1** = x.name  });
  </code></pre>
  
  <p>but Without combine works  sample </p>
  
  <pre><code>var obj2 = GP.TestTables.Select(x =&gt; new { ***name of company*** =  x.name  });
  </code></pre>
  
  <p>How can I do that?</p>