title: Inserting Row and getting Id, get error
body: <p>I insert a value / new row and I need the ID, but I get an error...</p>
  
  <p>SQL code:</p>
  
  <pre><code>INSERT INTO [StoneTable] ([StoneName]) VALUES (@StoneName)
  SELECT SCOPE_IDENTITY()
  </code></pre>
  
  <p>Using this code to insert row and getting the ID:</p>
  
  <pre><code>stoneTableTableAdapter = new StoneTableTabelleTableAdapter();
  int id = Convert.ToInt32(stoneTableTableAdapter.InsertStoneNameAndReturnId("anything"));
  //And on this 2nd Line I got an error
  </code></pre>
  
  <p>Error message:</p>
  
  <blockquote>
    <p>There was an error parsing the query. [ Token line number = 2,Token line offset = 1,Token in error = SELECT ]</p>
  </blockquote>
  
  <p>What's the problem? In my other project I use the same syntax, with no problems. Tried with <code>@@IDENTITY</code>, as well not working....</p>