utiliser une PS avec Linq
bonjour,
je cherche comment utiliser ma PS dans mon code c# en utilisant LINQ : voilà ma PS :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| ALTER proc [dbo].[uploadImage]
@ppr int ,
@imagename varchar ,
@imagecontent varchar,
@imagebinary image
as
begin tran
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 |
Merci
