select as field in Linq
<p>I am new to linq and trying to convert following sql query to linq;</p>

<pre><code>  select c.ClientID , c.ClientName 
  , ISNULL((select 1 from clientcontactaccess cca 
        where cca.clientid = c.clientid and ClientContactID = 2141  ), 0) 'ClientAccess'
  from Clients c
  where c.GroupID = 1
</code></pre>

<p>I have tried this so far but don't know where to include where clause;</p>

<pre><code> Dim query = (From c In db.Client Select New With _
               {Key .ClientID = c.ClientID, _
                 Key .ClientName = c.ClientName, _
                 Key .ClientAccess = (From cca In db.ClientContactAccess Where cca.ClientID = c.ClientID And cca.ClientContactID = _contactID)})
</code></pre>

<p>Updated:</p>

<p>I have managed to come this far but clientAccess field returns no value. I need to return either 1 or 0.</p>

<pre><code>  Dim query = (From c In db.Client Where c.GroupID = 1 Select New With _
               {Key .ClientID = c.ClientID, _
                 Key .ClientName = c.ClientName, _
                 Key .ClientAccess = (From cca In db.ClientContactAccess Where cca.ClientID = c.ClientID And cca.ClientContactID = _contactID)})
</code></pre>