Load up a new asp.net project.
Add a button to the default webform and add the following code to the click event (don't forget to include "using System.Data.SqlClient;" at the top):
Code:
private void Button1_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("server=127.0.0.1;uid=sa;pwd=mypass;database=Northwind");
SqlCommand cmd = new SqlCommand("INSERT INTO dbo.Categories (CategoryName) VALUES (@CategoryName)", conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@CategoryName", SqlDbType.NVarChar, 15));
cmd.Parameters["@CategoryName"].Value = "test";
conn.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Dispose();
}
Breakpoint the line "cmd.ExecuteNonQuery();"
When the debugger reaches that point, hit stop. Look in your northwind database and you will see a category called "test". Even if you breakpoint on conn.Open(), the category is added.
This does it on all of my development machines (4), so I don't think it's a botched install.
[edit]
I just tried this in a plain old windows forms application and there is no bug, so perhaps it's an error in the asp.net worker process.