[3.0.5 MSSQL 2008] Bug on generate save sql
Posted: Thu 06 Oct 2011 09:54
Hello
On
Table().InsertOnSubmit(Entity);
db.SubmitChanges();
generate next sql:
and get error:
You must declare the scalar variable "@@ret1".
Need replace
SELECT @@ret1 = ID, @@ret2 = Name FROM tUsers
on
SELECT @ret1 = ID, @ret2 = Name FROM tUsers
On
Table().InsertOnSubmit(Entity);
db.SubmitChanges();
generate next sql:
Code: Select all
declare @p14 int
set @p14=NULL
declare @p15 nvarchar(49)
set @p15=NULL
exec sp_executesql N'INSERT INTO tUsers (FirstName, LastName, Login, Password, IsAdmin, CreateDate, LastVisit, DefaultLanguageID, Deleted, Email, Nick) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11) ; SELECT @@ret1 = ID, @@ret2 = Name FROM tUsers WHERE ID = SCOPE_IDENTITY()',N'@p1 nvarchar(5),@p2 nvarchar(8),@p3 nvarchar(3),@p4 nvarchar(1),@p5 bit,@p6 datetime,@p7 datetime,@p8 int,@p9 bit,@p10 nvarchar(13),@p11 nvarchar(3),@ret1 int output,@ret2 nvarchar(49) output',@p1=N'Denis',@p2=N'Sahoshko',@p3=N'kam',@p4=N'1',@p5=1,@p6=NULL,@p7=NULL,@p8=NULL,@p9=0,@p10=N'[email protected]',@p11=N'Kam',@ret1=@p14 output,@ret2=@p15 output
select @p14, @p15You must declare the scalar variable "@@ret1".
Need replace
SELECT @@ret1 = ID, @@ret2 = Name FROM tUsers
on
SELECT @ret1 = ID, @ret2 = Name FROM tUsers