Charles Baldo
asked on
Need LINQ that does stored procedure
Hello
I have this as a stored procedure
CREATE PROCEDURE [dbo].[spCreateInvoiceRece ipt]
AS
BEGIN
SET NOCOUNT ON;
declare @id bigint
INSERT INTO InvoiceReceipt (CreateDate)
VALUES (getdate())
SET @id=SCOPE_IDENTITY()
update InvoiceReceipt set ReceiptNumber=@id where id=@id
END
How can I do this with Entity Frameworks LINQ?
I have this as a stored procedure
CREATE PROCEDURE [dbo].[spCreateInvoiceRece
AS
BEGIN
SET NOCOUNT ON;
declare @id bigint
INSERT INTO InvoiceReceipt (CreateDate)
VALUES (getdate())
SET @id=SCOPE_IDENTITY()
update InvoiceReceipt set ReceiptNumber=@id where id=@id
END
How can I do this with Entity Frameworks LINQ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome, glad to assist..
ASKER