var con = OpenFB2Connection(); var trans = con.BeginTransaction(); var command = new OleDbCommand("INSERT INTO ... VALUES ... RETURNING Id"); cmd.Parameters.Add("Id", OleDbType.Integer).Direction = ParameterDirection.Output; var Id = (int)cmd.ExecuteScalar(); //Here is your Id