title: linq to sql vb.net case statements to add other test
body: <p>It there a way to add other test to may request :</p>
  
  <pre><code>Dim exceptBanned = (From c In query _
  Where Not bannedCCList.Contains(c.Field(Of String)("N°Reçu")) _
        Group c By c!code_projet _
        Into nb = Count(CInt(c("code_projet"))), ca = Sum(CDec(c("Prix") + CDec(c("tva")))) _
        Select nb, ca).ToList
  </code></pre>
  
  <p>I want to add other test to my query , below what i have tried but  unfortunately it doesn't work :</p>
  
  <pre><code>   If tf = 1 Then
      exceptBanned = exceptBanned.Where(Function(c) c!type.Equals("Transfert 
      acompte") = False) 
  else
     exceptBanned = exceptBanned.Where(Function(c) c!type.Equals("Transfert 
      acompte") = True) 
  end if
  </code></pre>
  
  <p>Thank in advance</p>