I have a problem, I need to return the identity of the record I have just created in c# and save it as an integerr.
I've seen loads of examples on the internet but I just can't seem to adapt it for what I need.
Any help appreciated

```
cmprawf.CommandText = "INSERT INTO profiion( // Code that inserts in the right place )";
cmprawf.ExecuteNonQuery();
cnTB.Close();

```