DbAgentObj dbAgent = new DbAgentObj("connectionString"); string sql = "INSERT INTO MyTable (Name, Age) VALUES ('John', 30)"; dbAgent.ExecuteNonQuery(sql);
DbAgentObj dbAgent = new DbAgentObj("connectionString"); string sql = "UPDATE MyTable SET Age = 35 WHERE Name = 'John'"; dbAgent.ExecuteNonQuery(sql);
DbAgentObj dbAgent = new DbAgentObj("connectionString"); string sql = "DELETE FROM MyTable WHERE Age > 40"; dbAgent.ExecuteNonQuery(sql);This code creates a new DbAgentObj instance with a connection string to the database, defines a DELETE statement, and executes it using the ExecuteNonQuery method. This will delete all records from the MyTable table where the age is greater than 40. The DbAgentObj class is part of the ADONetCore library, which is a package for .NET Core that provides a lightweight and low-level API for working with databases.