How to convert stored procedure in LINQ or lambda

[zleug]

Hi All.

How to convert SQL stored procedure

CREATE Procedure [dbo].[sp_InsertEmployee]
(
@EmployeeId uniqueidentifier
, @name nvarchar(255)
, @Description nvarchar(500)
, @IsActive bit
, @CreatedOn datetime
, @ Id int Output
)
AS

INSERT INTO EmployeeTracking.dbo.Employees
(
EmployeeId
, Name
, Description
, IsActive
, LName
, CreatedOn
)
VALUES
(
@EmployeeId
, @name
, @Description
, @IsActive
, @CreatedOn
)

SELECT @Id = @@IDENTITY


to LINQ or Lambda? Thanks.

Continue reading...