forum

Home / DeveloperSection / Forums / Use stored procedure in c# using LINQ to SQL

Use stored procedure in c# using LINQ to SQL

Anonymous User 2952 11-Dec-2014

I'm looking for how to use a stored procedure using Linq-to-SQL in C#. 

This is my stored procedure: 

ALTER PROCEDURE [dbo].[uploadImage] @ppr INT,
    @imagename VARCHAR,
    @imagecontent VARCHAR,
    @imagebinary IMAGE
AS
BEGIN TRANSACTION
IF EXISTS (
        SELECT ImageID
        FROM [ImageStorage]
        WHERE ImageID = (
                SELECT codeimg
                FROM Agent
                WHERE PPR = @ppr
                )
        )
BEGIN
    --select ImageBinary from [ImageStorage] where ImageID = ( select codeimg from Agent where PPR=@ppr)
    UPDATE ImageStorage SET ImageName =@imagename,
        ImageContentType = @imagecontent,
        ImageBinary =@imagecontent
    WHERE imageID = (
            SELECT codeimg
            FROM Agent
            WHERE PPR= @ppr
            )
END
ELSE
    INSERT INTO ImageStorage (
        ImageName,
        ImageContentType,
        ImageBinary
        )
    VALUES (
        @imagename,
        @imagecontent,
        @imagebinary
        )
COMMIT

Thank you


Updated on 11-Dec-2014
I am a content writter !

Can you answer this question?


Answer

2 Answers

Liked By