title: Entity Framework, MySQL, SaveChanges - Error in SQL syntax
body: <p>This is the error I am getting:</p>
  
  <pre><code>Server Error in '/' Application.
  
  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group) VALUES ('test_user','testpass',13,77,0,0,0,1);SE' at line 9
  
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
  
  Exception Details: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group) VALUES ('test_user', 'testpass', 13, 77, 0, 0, 0, 1); SE' at line 9
  </code></pre>
  
  <p>I had a look around and someones explanation that it maybe an issue with the mysql buffer <code>SELECT is stripped which may indicate some string buffer problems in the MySql drive</code></p>
  
  <p>I am using MySQL Connector version 6.5.4.0</p>
  
  <p>Any help appreciated thanks</p>
  
  <p>As requested this is the code I use to insert:</p>
  
  <pre><code>public bool CreateMember(string username, string password, int age, int residence)
  {
      Context.Members.AddObject(new MemberEntity { Username = username, Password = password, Age = age, Residence = residence, Banned = false, Locked = false, Online = false, Group = 1 });
      return Context.SaveChanges() &gt; 0;
  }
  </code></pre>