How to execute a stored procedure in Silverlight with WCF RIA!

See more:

WCF

Silverlight

service

, +

Can someone help me on this: I have created a stored procedure in SQL Server and i want to expose it in Silverlight so i can execute it from there. The Stored procedure is used to update a value of a primary key, which Entity Framework(in Silverlight) does not support. Here is the Strored procedure:

CREATE PROCEDURE [dbo].[ReplaceFieldAgent]

@CurrentBeneficiaryID varchar(50),
@NewBeneficiaryID varchar(50)
AS
BEGIN

Update FieldAgent Set Beneficiary_ID = @NewBeneficiaryID Where Beneficiary_ID = @CurrentBeneficiaryID

END