title: sql-c#-insert data to database and output autoincreament id
body: <p>I want to get Id from sql, this is my sql:</p>
  
  <pre><code>INSERT INTO Respondent (Gender) VALUES ('Male') OUTPUT inserted.Id. 
  </code></pre>
  
  <blockquote>
    <p>error: Incorrect syntax near 'OUTPUT'.</p>
  </blockquote>