❔ System Transaction and best using it
I am looking for any useful information based on this article https://learn.microsoft.com/en-us/archive/msdn-magazine/2005/december/transactions-volatile-resource-managers-in-net about system transaction, ideally I would like examples or source code I would also be happy with any video or detailed materials about transactions without using databases inside c# themselves
3 Replies
Do you need transaction for handling state of the objects not representing data from database ? Your question sounds like that. Generally database DML operations like insert, update, delete, select need transactions to isolate a business operation from other business operation based on the requirement. I hope you are referring to handling transaction of database operations in c#. We need more information about your requirements. Which .net version you are working ? (whether .net framework 4.5(kind of legacy now) or .net 5/6) Which database you are dealing with ? (Whether PostgreSQL, MySQL, SQLServer,..)
please take a look and let me know whether you are looking for this kind of information https://learn.microsoft.com/en-us/sql/connect/ado-net/local-transactions?view=sql-server-ver16
Local transactions - ADO.NET Provider for SQL Server
Demonstrates how to perform transactions against a database with Microsoft SqlClient Data Provider for SQL Server.
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.