SQL to LINQ Conversion

Question

Hello.. I'm new to LINQ to SQL using C#. I am wondering if this Query is convertable to LINQ ?

 

 

SET @cnt = 0;
SET @Company = @CompCode

select TOP 1 @cdate = convert(date,DateReleased) from IRForm WHERE Company = @Company
set @cdate = (select TOP 1 convert(date,DateReleased) from IRForm WHERE Company = @Company)

select TOP 1 @cnt = COUNT(Company) from IRForm WHERE Company = @Company AND convert(date,@cdate) = convert(date,@dn)
set @cnt = (select TOP 1 COUNT(Company) from IRForm WHERE Company = @Company AND convert(date,@cdate) = convert(date,@dn))



                IF (@cnt = 0)
                    BEGIN
                        INSERT INTO IRForm (
                        IR_No,
                        Subj_Desc,
                        Subj_Code,
                        Company,
                        Incident_Date,
                        Reported_By,
                        Mpad_SN,
                        User_No,
                        A_S_B,
                        Person_Involved,
                        DT_Recieved,
                        Incident_Desc,
                        OS_Name,
                        OS_Submitted)


                        VALUES (
                        @Company + FORMAT( @dn, 'yy/MM/', 'en-US' ) + '00' + CAST(@cnt + 1 as varchar(10)),
                        @Subj_Desc,
                        @Subj_Code,
                        @Company,
                        @Incident_Date,
                        @Reported_By,
                        @Mpad_SN,
                        @User_No,
                        @A_S_B,
                        @Person_Involved,
                        @DT_Recieved,
                        @Incident_Desc,
                        @OS_Name,
                        @OS_Submitted)
                    END

 If yes, please provide me an example so that I can continue learning LINQ. Thank you C# Corner.