Index: test/TestCases.cs ================================================================== --- test/TestCases.cs +++ test/TestCases.cs @@ -240,25 +240,26 @@ cmd.ExecuteNonQuery(); } } + // Inserts binary data into the database using a named parameter internal static void BinaryInsert(DbConnection cnn) { using (DbCommand cmd = cnn.CreateCommand()) { - cmd.CommandText = "INSERT INTO TestCase(Field6) VALUES($bin)"; + cmd.CommandText = "INSERT INTO TestCase(Field6) VALUES(@bin)"; DbParameter Field6 = cmd.CreateParameter(); byte[] b = new byte[4000]; b[0] = 1; b[100] = 2; b[1000] = 3; b[2000] = 4; b[3000] = 5; - Field6.ParameterName = "$bin"; + Field6.ParameterName = "@bin"; Field6.Value = b; cmd.Parameters.Add(Field6); cmd.ExecuteNonQuery();