I am using SQL Server 6.5, Visual C++, and COM to tackle a personal project. I understand the use of Primary Keys, Foreign Keys nad other referential integrity mechanisms when designing a database. But, in the COM world, where the business logic is often sandwiched between the data layer and the application layer, are referential integrity mechanisms commonly used?
My direct point is that it seems redundant for me to implement foreign keys in a SQL database design only to code the knowledge of these table relationships into my business COM objects. I've consulted various texts and can find no information that helps me understand this area.
I'm not looking for a two page explanation, I'm a fairly sharp guy, but in six sentences or less could someone point me in the right direction?