I don't know c# but;
a select command with identity column descending. but it can reason conflicts when another user append record while you append. So you can use a field in where clause which that has unique data. I did that with sqlserver.