sql脚本:
declare
intErrorCode INT;
increasingId INT;
viewModelName NVARCHAR2;
viewModelUrl NVARCHAR2;
viewModelPostTitle NVARCHAR2;
viewModelPostContent NVARCHAR2;
BEGIN
viewModelName=N'NAME100';
viewModelUrl=N'URL100';
viewModelPostTitle=N'NAME100-PostTitle1';
viewModelPostContent=N'NAME100-PostContent1';
------- 开始事务
insert into [TESTDATABASE].[Blogs]([Url], [Name])
VALUES(viewModelUrl,viewModelName);
increasingId=@@IDENTITY ;
insert into [TESTDATABASE].[Posts]([Title], [Content], [BlogId])
VALUES(viewModelPostTitle, viewModelPostContent, increasingId);
COMMIT; --ROLLBACK;--COMMIT; ------- 结束事务
EXCEPTION
WHEN OTHERS THEN
ROLLBACK; -- 出现异常则回滚事务
END;
执行语句:
int r = _context.Database.ExecuteSqlRaw(sql)
执行结果 【r】竟然为 【1】???