title: Linq to SQL Nested Select Group by Having count
body: <p>I need convert query from sql to linq 
  Create Table History</p>
  
  <pre><code>CREATE TABLE [dbo].[History](
      [HistoryID] [int] IDENTITY(1,1) NOT NULL,
      [AuctionID] [int] NOT NULL,
      [UserName] [nvarchar](128) NULL,
      [Time] [datetime] NOT NULL,
      [Price] [decimal](18, 2) NOT NULL,
  )
  </code></pre>
  
  <p>Query</p>
  
  <pre><code>select [UserName],[Price] from [History] 
  where [Price] in 
      (SELECT [Price] FROM [History]  
      where ID=28 GROUP BY [Price]
      HAVING COUNT(*)=1) 
          Order by [Price]
  </code></pre>