padmapriya patruni

padmapriya patruni

  • NA
  • 74
  • 114.8k

stored procedure to linq

Apr 25 2014 5:00 AM
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)