带有Linq数据插入确认的C# [英] C# with Linq data inserting confirmation
问题描述
BankDataContext obj = new BankDataContext();
BankAccount obj1 = new BankAccount();
obj1.accountid = 1 ;
obj1.balance = 560 ;
obj1.bankname = bkl;
obj.BankAccounts.InsertOnSubmit(obj1);
obj.SubmitChanges();
在存储过程中使用Sql Out参数...
for例子
Quote:CREATE PROCEDURE [dbo]。[MY_SAMPLE_SP]
@ PARAM1 NVARCHAR(15),
@ PARAM2 BIGINT = NULL,
@ PARAM3 NVARCHAR (50)= NULL,
@ PARAM4 BIT = NULL,
@ PARAM5 NVARCHAR(100)= NULL,
@ PARAM6 BIGINT = NULL ,
@ PARAM7 INT = NULL,
@OPERACTION VARCHAR(10)= NULL,
@SUCCESS BIT OUT,
@ERRORNAME NVARCHAR(MAX)OUT
AS
BEGIN
IF UPPER(@OPERACTION) =''INSERT''
BEGIN
BEGIN
开始尝试
INSERT INTO [DBO]。[PR_SRY_GROUP_MASTER ]
(
[COLUMN1]
,[COLUMN2]
,[COLUMN3]
,[COLUMN4]
,COLUMN5
,[COLUMN6]
)
VALUES >
(
@ PARAM1
,@ PARAM2
,@ PARAM3
,@ PARAM4
,@ PARAM5
,@ PARAM6
);
SET @ SUCCESS = 1
SET @ERRORNAME ='''SUCCESS''
结束尝试
BEGIN CATCH
BEGIN
SET @ SUCCESS = 0
SET @ ERRORNAME = ERROR_MESSAGE()+'':''+ ERROR_NUMBER();
END
END CATCH
END
ELSE
BEGIN
SET @ SUCCESS = 0;
SET @ERRORNAME =''ERROR'';
END
END
END
C# with Linq data inserting confirmation, in ADO.Net we can return bool as a return type for confirmation if it is true, but how do we do that in LINQ with SQL Approach
BankDataContext obj = new BankDataContext();
BankAccount obj1 = new BankAccount();
obj1.accountid =1;
obj1.balance = 560;
obj1.bankname ="bkl";
obj.BankAccounts.InsertOnSubmit(obj1);
obj.SubmitChanges();
Use Sql Out Parameters in stored procedure ...
for example
Quote:CREATE PROCEDURE [dbo].[MY_SAMPLE_SP]
@PARAM1 NVARCHAR(15),
@PARAM2 BIGINT =NULL,
@PARAM3 NVARCHAR(50) =NULL,
@PARAM4 BIT =NULL,
@PARAM5 NVARCHAR(100) =NULL,
@PARAM6 BIGINT =NULL,
@PARAM7 INT =NULL,
@OPERACTION VARCHAR(10) =NULL,
@SUCCESS BIT OUT,
@ERRORNAME NVARCHAR(MAX) OUT
AS
BEGIN
IF UPPER(@OPERACTION) = ''INSERT''
BEGIN
BEGIN
BEGIN TRY
INSERT INTO [DBO].[PR_SRY_GROUP_MASTER]
(
[COLUMN1]
,[COLUMN2]
,[COLUMN3]
,[COLUMN4]
,COLUMN5
,[COLUMN6]
)
VALUES
(
@PARAM1
,@PARAM2
,@PARAM3
,@PARAM4
,@PARAM5
,@PARAM6
);
SET @SUCCESS=1
SET @ERRORNAME=''SUCCESS''
END TRY
BEGIN CATCH
BEGIN
SET @SUCCESS=0
SET @ERRORNAME=ERROR_MESSAGE() + '' : '' + ERROR_NUMBER();
END
END CATCH
END
ELSE
BEGIN
SET @SUCCESS=0;
SET @ERRORNAME=''ERROR'' ;
END
END
END
这篇关于带有Linq数据插入确认的C#的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!