enter image description here

When you are using Microsoft SQL Server connection pooling, a recycled connection gets all the session details reset (eg: temp tables are deleted). Internally this is done by the special sproc sp_reset_connection. This answer has a full list of details which are reset – What does sp_reset_connection do . One notable thing which is not on this list is the transaction isolation level. So, for example, if a connection has run a transaction at the read uncommitted level, and that connection gets recycled, the next thread which receives that connection will have a transaction isolation level of read uncommitted, which is different from the default on brand new connections of read committed. This behavior is intended (by Microsoft), as it’s documented in the TDS spec; there’s this sentence in there “Distributed
transactions and isolation levels will not be reset.“.

For starters, I am a complete novice with data access, and am working through the iamtimcorey C# Mastercourse (meaning this is the complete extent of my knowledge of SQL Server and data access in general).

DB name = NikAfzarDB TB name = ClientTB string connectionString = “Data Source=.;Initial Catalog=NikAfzarDB,Integrated Security=true”; SqlConnection Connection = new SqlConnection(connectionString); try { string query = “INSERT INTO ClientTB (CID, CFileNumber, CName, CFamily, CPhoneNumber, CJobeName, CCharacter) VALUES (@ID, @FileNumber, @Name, @Family, @PhoneNumber, @JobeName, @Character)”; SqlCommand Command = new SqlCommand(query, Connection); Command.Parameters.AddWithValue(“@ID”, id); Command.Parameters.AddWithValue(“@FileNumber”, fileNumber); Command.Parameters.AddWithValue(“@Name”, name); […]

DB name = NikAfzarDB TB name = ClientTB string connectionString = “Data Source=.;Initial Catalog=NikAfzarDB,Integrated Security=true”; SqlConnection Connection = new SqlConnection(connectionString); try { string query = “INSERT INTO ClientTB (CID,CFileNumber,CName,CFamily,CPhoneNumber,CJobeName,CCharacter) VALUES (@ID,@FileNumber,@Name,@Family,@PhoneNumber,@JobeName,@Character)”; SqlCommand Command = new SqlCommand(query, Connection); Command.Parameters.AddWithValue(“@ID”, id); Command.Parameters.AddWithValue(“@FileNumber”, fileNumber); Command.Parameters.AddWithValue(“@Name”, name); Command.Parameters.AddWithValue(“@Family”, family); Command.Parameters.AddWithValue(“@PhoneNumber”, phoneNumber); Command.Parameters.AddWithValue(“@JobeName”, jobName); Command.Parameters.AddWithValue(“@Character”, character); Connection.Open(); Command.ExecuteNonQuery(); return true; […]

I created a SQL query and it should update the database after the payment is made, but when I hit the save button, nothing happens, I don’t even get an error.