var connectionString = "Server=localhost;Database=MyDatabase;User Id=myUsername;Password=myPassword;"; using (var handler = new SQLHandler(connectionString)) { var query = @"SELECT * FROM MyTable"; var result = handler.ExecuteQuery(query); foreach (var row in result) { Console.WriteLine($"ID: {row["id"]} - Name: {row["name"]}"); } }
var connectionString = "Server=localhost;Database=MyDatabase;User Id=myUsername;Password=myPassword;"; using (var handler = new SQLHandler(connectionString)) { using (var transaction = handler.BeginTransaction()) { try { var query1 = @"INSERT INTO MyTable (name) VALUES ('John')"; handler.ExecuteNonQuery(query1); var query2 = @"UPDATE MyTable SET name = 'Jane' WHERE id = 1"; handler.ExecuteNonQuery(query2); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Console.WriteLine($"Error: {ex.Message}"); } } }This code example demonstrates how SQLHandler can be used to execute multiple queries inside a transaction. If any of the queries fail, the transaction is rolled back and an error message is displayed. SQLHandler can be found in the "SQLHandler.dll" package library.