If I wanted to use the Auto-Increment logic, whereabouts do I put it into the application?

I assume that this overrides ado.net auto-increment, yes/no?

Also, how and where does it keep track of the primary key?

Thanks.