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
Anonymous User
11-Dec-2014Use this to convert the image:
pass "binary" to your method as "imagebinary" parameter
Anonymous User
11-Dec-2014consider changing your proc to this: