using SqlQuery; var connection = new SqlConnection("connection string"); var query = "SELECT * FROM Customers WHERE Country = @Country"; var parameters = new { Country = "USA" }; var result = connection.Query(query, parameters);
using SqlQuery; var connection = new SqlConnection("connection string"); var query = "INSERT INTO Customers (Name, Email) VALUES (@Name, @Email)"; var parameters = new { Name = "John Doe", Email = "[email protected]" }; var rowsAffected = connection.Execute(query, parameters);This example executes an INSERT query that inserts a new customer into the database. The query uses parameterized values to prevent SQL injection attacks. The package library for SqlQuery is SqlQuery.Core, which is available on NuGet.