If I want to manually assign the primary key of a table instead of using identity field, is there a recommend way to handle that in MM.NET? I basically want to add one to the highest primary key in the table.

I currently have a store procedure that handle the insert and the assignment of the primary key, however, I don't know at what point should I override the MM.NET framework to call my SP.