// @nuget: Norm.net -Version 3.1.0

// @nuget: System.Data.SqlClient -Version 4.8.2

using System.Data;

using System.Data.SqlClient;

using Norm;

​

public class Program

{

    public static void Main()

    {

        using var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools());

        connection

            .Execute("begin tran")

            .Execute("create table #test (t text)")

            .Execute("insert into #test values (@param1)", ("param1", "foo", SqlDbType.VarChar))

            .Execute("rollback");

    }

}