title: Cross Apply LINQ-TO-SQL
body: <p>There are following tables:</p>
  <pre><code>create table Table_A (
      Id int primary key identity,
      Status int not null
  )
  
  create table Table_B (
      Id int primary key identity,
      Value varchar(80) not null
  )
  
  create table Table_C (
      Id int primary key identity,
      Time datetime not null
  )
  </code></pre>
  <p>I would like to write the following query in LINQ-to-SQL using lambda notation:</p>
  <pre><code> select * from TABLE_A a
   cross apply (
      select top 1 c.Time from TABLE_B b
      inner join TABLE_C c on c.Id = b.Id
      where b.Id = a.Id
      order by c.Time asc
   ) d
   where a.Status = 10 and d.Time &gt; '2021-03-09'
  </code></pre>
  <p>How would I do this?</p>