title: Sql Server Ce 3.5 Identity insert
body: <p>got an issue with identity columns in Sql Server CE</p>
  
  <p>when using Server explorer, in VS2008, executing the following script</p>
  
  <p>SET IDENTITY_INSERT testTable ON;
  Insert into testTable (id,name) values (1,'Something')
  SET IDENTITY_INSERT testTable ON;</p>
  
  <p>sends the follow message error
  'The Set SQL construct or statement is not supported.'
  but then inserts the row fine ?!?!?!</p>
  
  <p>anyway, when I try to do the same thing through C#, giving that script as a command text
  it fails saying the error was in the "Insert key word"</p>
  
  <p>I understand that against SQL SERVER CE the command only accepts one batch command at the time
  so in that case we have three commands (it would work with the full SQLServer)
  any idea?</p>