Mysql LIMIT statement in .NET TableAdapter query

I am adding the following query to a .NET dataset TableAdapter.

select * from users ORDER BY RAND() LIMIT 0,10

But the LIMIT word is not recognized as a part of the query and I am unable to proceed further.

Is there any wo开发者_高级运维rkaround for this issue?

The MySQL site has a bug report that looks a lot like you problem: http://bugs.mysql.com/bug.php?id=36622. The problem described there is that the wizard gives an error. But, when you just complete the wizard, it does work.