<p>This Linq to SQL query ...</p>

<pre><code>    Return (From t In Db.Concessions Where t.Country = "ga" Select t.ConcessionID, t.Title, t.Country)
</code></pre>

<p>... is generating this SQL:</p>

<pre><code>SELECT [t0].[ConcessionID], [t0].[Title], [t0].[Country]
FROM [dbo].[Concessions] AS [t0]
WHERE [t0].[Country] = ga
</code></pre>

<p>... when what I want is</p>

<pre><code>WHERE [t0].[Country] = 'ga'
</code></pre>

<p>Any ideas why?</p>

the select should be
```
```
Select New With {t.ConcessionID, t.Title, t.Country}
```
```
rather than
```
```
Select t.ConcessionID, t.Title, t.Country
```
```
you need to create a new instance of an anonymous type to contain the fields.