Hi everybody,

I can not figure out why this command complains about expecting a parameter which I'm clearly supplying. Same code works fine in SSMS. Do you see what I may be missing here?

   using (SqlCommand sqlCommand = new SqlCommand())
            {
                sqlCommand.CommandType = CommandType.Text;
                sqlCommand.CommandText = @";merge dbo.gst_actv as trgt 
      using (select cast(pass_no as char(16)) as ref_no
           from dbo.gst_pass
           where pending = 1 and salespoint = @salespoint) as srce 
          on trgt.ref_no = srce.ref_no 
      when matched and trgt.activ_type between 100 and 199 
      then delete; 

    delete dbo.gst_pass where pending = 1 and salespoint = @salespoint;";
                
                sqlCommand.Parameters.Add("@salespoint", SqlDbType.Char, 6).Value = this.CurrentSalespoint;
                database.ExecuteSqlCommand(sqlCommand, CommandExecutionType.NonQuery);
                messageText = this.GetFormattedReturn();
            }

The error is this:

The parameterized query '(@salespoint char(6));merge dbo.gst_actv as trgt
using (' expects the parameter '@salespoint', which was not supplied.

It sounds like some weird bug to me.