2
Answers

stored procedure to linq

Photo of padmapriya patruni

padmapriya patruni

11y
1.2k
1
this is my stored procedure .how to write in linq
 
 
ALTER PROCEDURE [dbo].[HPMS_SelectDraftLOBReportByLOBId] (@LOBID nvarchar(20)=null ) As SET NOCOUNT ON; begin declare @err1 int     begin transaction BEGIN Select * from DraftLOB where  AssemblyId is not null and SessionId is not null and @LOBID IS NULL OR LOBId = @LOBID        order by SrNo1, SrNo2, SrNo3    END 
 

Answers (2)