oracle get primary key value after an insert

[Justin]

All,

Using oracle and DBLinq, how can I perform an insert and get the
sequence value back into my primary key? I cannot figure it out.

I have something like this:

Employee emp = new Employee();

emp.Name = "joe";

db.Employee.InsertOnSubmit(emp);

db.SubmitChanges();

// how do I get the primary key value now?

int recordID = emp.ID; // ID returns 0 but is 9 in the database table

Thanks for any help!

/Justin