title: Mysql LIMIT statement in .NET TableAdapter query
body: <p>I am adding the following query to a .NET dataset TableAdapter.</p>
  
  <blockquote>
    <p>select * from users ORDER BY RAND()
    LIMIT 0,10</p>
  </blockquote>
  
  <p>But the LIMIT word is not recognized as a part of the query and I am unable to proceed further.</p>
  
  <p>Is there any workaround for this issue?</p>