使用LINQ和Entity Framework获取存储过程输出参数

本文介绍了使用LINQ和Entity Framework获取存储过程输出参数的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我已经创建了一个存储过程，该过程使用参数来创建用户.如果用户已经存在，则将输出参数设置为用户已经存在"，并且仅执行其他操作.

I've created a stored procedure that takes parameters to create a user. If the user already exists it sets the output parameter to 'User already exists' and does nothing more.

现在，我已将此函数(InsertNewUser)映射到我的实体框架，并按如下方式调用它:

Now I've mapped this function (InsertNewUser) to my Entity Framework and am calling it like so:

context.InsertNewUser(email, name, passwordhash, salt, ???)

???是我遇到麻烦的地方.在存储过程中，此参数是OUTPUT参数.我尝试声明一个字符串，然后传入"out definedString"，但这是不正确的.

The ??? is where I'm having trouble. In the stored procedure this parameter is an OUTPUT parameter. I tried declaring a string and then passing in "out declaredString" but that wasn't correct.

我不确定我是否会以正确的方式进行操作，有什么想法吗?

I'm not sure I'm going about this the right way, any thoughts?

这是存储过程:

ALTER PROCEDURE dbo.InsertNewUser ( @eMail nvarchar(256), @firstName nvarchar(256), @lastName nvarchar(256), @passwordHash nvarchar(256), @salt nvarchar(256), @output nvarchar(256) OUTPUT ) AS /* Saves a user to the db. */ BEGIN --First check if the user doesn't exist IF EXISTS (SELECT eMail FROM UserSet WHERE eMail = @eMail) --Return that user exists SET @output = 'User exists' ELSE INSERT INTO UserSet VALUES (@eMail, @firstName, @lastName, @passwordHash, @salt) END

推荐答案

我使用以下代码解决了该问题:

I solved it with this code:

//This will provide the parameter System.Data.Objects.ObjectParameter parameter = new ObjectParameter("output", "nvarchar(256)"); //This will contain the returned values ObjectResult result = context.CheckIfUserExists(eMail, parameter);