model and repository in C#

Lisen

Hi,

i am working in a C# project using model and repository..

im not sure if im using the method correctly or not because im new in C# programming

i am adding some code in below.. pls tell me if im using it correctly or not..

for me its working fine..

but i want to use with begin,commit and rollback

pls help me in this matter

models.cs

Repository.cs

public List< Model_Customer > Customer(Model_Sample data, Model_Customer mCustomer)
{
IDbConnection db = new SqlConnection("Data Source=" + data.Instance + ";Initial Catalog=" + data.Database + ";User ID=" + data.UserID + ";Password=" + data.Password + "");
List list = db.Query("ProcCustomerCRUD", mCustomer,
commandType: CommandType.StoredProcedure).ToList();
return list;

windows form

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy7y ago
Accepted answer
Hi Lisen,
Hi, The below procedure inserts into two tables with transactions. If any of the insertion fails the transaction doesnt gets succeed.
GO
CREATE PROCEDURE dbo.InsertDataInTwoTables
(
@val1 varchar(100)
, @val2 varchar(100)
)
AS
BEGIN
BEGIN TRANSACTION;
SAVE TRANSACTION MySavePoint;
BEGIN TRY
-- Inserting in 1st table
INSERT INTO [dbo].[tblName1]
([col1],[col2])
VALUES (@val1, @val2);
-- Inserting in 2nd table
INSERT INTO [dbo].[tblName2]
([col1],[col2])
VALUES (@val1, @val2);

END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION MySavePoint; -- rollback to MySavePoint
END
END CATCH
COMMIT TRANSACTION
END;
GO
If it helps, Mark as answer.
Thank you.
Lisen7y ago
Hi sreekanth..
now i m getting error in repository

System.Data.SqlClient.SqlException: 'Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.'
pls solve this
Lisen7y ago
hi. thanks for your reply..
can you tell me how..
like if i want to insert same data in 2 tables.... i need to commit only after both tables are inserted..
Sreekanth Reddy7y ago
Hi Lisen,
If you want to do transactions(commit , rollback...), I suggest do in procedures.
Upto your code everything is well.
Thank you.