Please help me in sorting out my Problem Providing me the solution . My Problem is I have a master table with Primary key on ID field (PatientID-(Patient-Table)) and it is an Identity field And My child table has the same ID field(PatientID-(PatientDetails-Table)) and it has the relationship set And...

Probably this section might not be the right one for this topic but it's definately the right site regarding the performance difference. Can you give me your expert advice on performance cons and pros of using stored procedure vs hibernate? I have a hard time convincing my application developers...