title: VB.Net Lambda query
body: <p>I know I can change a query like this</p>
  
  <pre><code>Dim myList As List(Of Tickets) = (From a In db.myTable
                    Where a.ID = id AndAlso a.IsOnline = True).ToList
  </code></pre>
  
  <p>to lambda</p>
  
  <pre><code>Dim myList as List(of Tickets) = db.Where(Function(x) x.ID = id ANDAlso a.IsOnline = true).ToList
  </code></pre>
  
  <p>How do I write the lambda version and tell it to create a new object with the results?? like this:</p>
  
  <pre><code>Dim myList As List(Of Tickets) = (From a In db.myTable
                               Where a.ID = id AndAlso a.IsOnline = True
                               Select New TicketType With {
                                         .Id = a.rsID.ToString,
                                         .Title = a.rsTitle}).ToList
  </code></pre>