title: Can you use MySQL @ session variables in the C# connector?
body: <p>I have a query that utilizes MySQL session variables (note the @rank variable)</p>
  
  <pre><code>SELECT Rank, UserId, CurrentVDOT
  FROM
      (
          SELECT @rank := @rank + 1 AS Rank, UserId, MaxVDOT AS CurrentVDOT
          FROM
              (
                  SELECT UserId, MAX(VDOT) AS MaxVDOT
                  FROM
                      (
                          SELECT U.UserId, U.VDOT
                          FROM
                              (
                                  SELECT UserId, MAX(Created) AS Created
                                  FROM UserVDOT
                                  GROUP BY UserId
                              ) G
                          INNER JOIN UserVDOT U
                          ON U.UserId = G.UserId
                              AND U.Created = G.Created
                      ) M
                  GROUP BY UserId
                  ORDER BY MaxVDOT DESC
              ) R, (SELECT @rank := 0) foo
      ) F
  WHERE F.UserId = @UserId;
  </code></pre>
  
  <p>If I try to execute this against the C# MySQL connector, it tries to tell me that I need to declare @rank as an input parameter variable.</p>
  
  <p>Is there any way around this?</p>
  
  <p>Thanks.</p>