model and repository in C#

Question

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 namespace sample.Models { class Model_Sample { public string Database { get ; set ; } public string ServerInstance { get ; set ; } public string UserID { get ; set ; } public string Password { get ; set ; } } class Model_Customer { public int CustomerID { get ; set ; } public string CustomerName { get ; set ; } public int age { get ; set ; } public string Phone { get ; set ; } } } Repository.cs public List 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 public partial class frmCustomerMaster : Form { Model_Sample data= new Model_Sample (); Model_Customer mycustomer = new Model_Customer(); private void BtnSave_Click( object sender, EventArgs e) { mycustomer.CustomerID = Convert.ToInt32(txtcustomerID.text); mycustomer.CustomerName = txtCustomerName.text mycustomer.age = Convert.ToInt32(txtage.text); mycustomer.phone = txtphone.Text; rep.Customer(data, mycustomer); } }

Sreekanth Reddy · 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.

Lisen · Answer

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

Sreekanth Reddy · Answer

Hi Lisen, If you want to do transactions(commit , rollback...), I suggest do in procedures. Upto your code everything is well. Thank you.

Lisen · Answer

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..