ParamBehavior

static void Main(string[] args)
{
    SqlConnectionStringBuilder bldr = new SqlConnectionStringBuilder();
    bldr.DataSource = "(localdb)\\DEV";
    bldr.InitialCatalog = "DbParams";
    bldr.ApplicationName = "ParameterBehavior";
    bldr.IntegratedSecurity = true;

    using (SqlConnection con = new SqlConnection(bldr.ConnectionString))
    using (SqlCommand cmd = con.CreateCommand())
    {
        // this method call will change with each scenario to highlight
        // the behavior of various command properties.
        InputWithNoDefault(cmd); 
        
        con.Open();
        var result = cmd.ExecuteScalar();
        Console.WriteLine(result.ToString());
        Console.WriteLine(cmd.Parameters["@param1"].Value);
    }
    Console.ReadKey();
}