How to use MySQL custom variables with ADO.NET

MySQL SQL commands can contain user-defined variables starting with "@".

The MySQL ADO.NET connector also uses "@" for command parameters.

Is there a way to escape the '@' character so that I can use the custom variable in the SQL statement sent to MySQL via ADO.NET?

I am trying to do something like this:

UPDATE company 
    SET next_job_id = @jobid:=next_job_id+1 
    WHERE company_id = @companyid; 
SELECT @jobid;

      

        
        
        
      

    

Where @jobid is a MySQL user variable and @companyid is a parameter.