Linq to SQl Stored Procedure Problem( it can't figure out the return type)
- by chobo2
Hi
I have this SP
USE [Test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[UsersInsert](@UpdatedProdData XML)
AS
INSERT INTO
dbo.UserTable(UserId,UserName,LicenseId,Password,PasswordSalt,Email,IsApproved,IsLockedOut,CreateDate,
LastLoginDate,LastLockOutDate,FailedPasswordAttempts,RoleId)
SELECT
@UpdatedProdData.value('(/ArrayOfUsers/Users/UserId)[1]', 'uniqueidentifier'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/UserName)[1]', 'varchar(20)'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/LicenseId)[1]', 'varchar(50)'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/Password)[1]', 'varchar(128)'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/PasswordSalt)[1]', 'varchar(128)'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/Email)[1]', 'varchar(50)'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/IsApproved)[1]', 'bit'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/IsLockedOut)[1]', 'bit'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/CreateDate)[1]', 'datetime'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/LastLoginDate)[1]', 'datetime'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/LastLockOutDate)[1]', 'datetime'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/FailedPasswordAttempts)[1]', 'int'),
@UpdatedProdData.value('(/ArrayOfUsers/Users/RoleId)[1]', 'int')
Now this SP creates just fine. It's when I go to VS2010 and try to drag this SP in my method panel of my linq to sql file in design view.
It tells me that it can't figure out the return type. I try to go to the properties but it does not have "none" as a choice and I can't type it in. It should be "none" so how do I set it to "none"?
