.net 怎么执行mysql 带变量的SQL查询语句

Question

.net 怎么执行mysql 带变量的SQL查询语句，如下语句在.net中执行的话 会因为@符号的问题导致报错，求大神赐教

 SELECT a.id,a.name,t1.m_payNum ,@curRank=@curRank +1 as rank
FROM s1_aoshinet.players t1 JOIN s1_aoshinet.player_attributes a ON t1.id = a.id,(SELECT  @curRank:=0) c
WHERE 1=1 ORDER BY m_payNum desc LIMIT 100

Answer 1

http://blog.csdn.net/kavensu/article/details/9888303