CODEWITHSUNDEEP
c#sqlsql-serverentity-framework
user840718
user840718

Reputation: 1611

Convert user-defined function to stored procedure for EF

This is my user-defined function used in a project:

CREATE FUNCTION [dbo].[Encrypt]
(
@Password nvarchar(4000)
)
RETURNS varbinary(4000)
AS
BEGIN
SELECT @Password = CONVERT(nvarchar(4000),@Password);
RETURN HashBytes('SHA1', @Password);
END
GO

I need Entity Framework so, it's possible find a way to convert this one in a stored procedure in SQL Server 2012 Express?

Upvotes: 0

Views: 125

Answers (1)

M.Ali
M.Ali

Reputation: 69554

Procedure Definition

CREATE PROCEDURE [dbo].[usp_Encrypt]
@Password   nvarchar(4000), 
@HashedPass varbinary(4000) OUTPUT
AS
BEGIN
 SET NOCOUNT ON;
   SET @HashedPass = HashBytes('SHA1',CONVERT(nvarchar(4000),@Password));
END

EXECUTE PROCEDURE

DECLARE @RtnHashedPass varbinary(4000);

EXECUTE [dbo].[usp_Encrypt]
@Password   = 'myPassword'
@HashedPass = @RtnHashedPass OUTPUT

SELECT @RtnHashedPass  --<-- Do what ever you want to do with this value

Upvotes: 1

Related Questions