Sandeep Kumar

Sandeep Kumar

  • 1k
  • 627
  • 49.9k

how to write linq query of the below sql query

Jun 6 2023 8:39 AM

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT 
      B.[LabId]
      ,[TrayNo]
      ,B.[BoxNo]
      ,B.[RackNo]
      ,M.id,M.Id
     
  FROM [BV_OCM].[dbo].[TblBatch] B INNER JOIN [BV_OCM].[dbo].[MstRackBox] M ON B.RackNo = M.RackNo and B.[BoxNo]=M.[BoxNo] where B.Id=85
 


Answers (1)