There are 2 ways ... you can do it in database or in a framework like
cayenne
The framework way is best for being database independent
The database way is best for databases being accessed on different way ...
let's say java and .net ... in those constellations you otherwiese would
have to do multiple inplementations
In most cases you will find a mix of both
2009/3/27 Joe Baldwin <jfbaldwi..arthlink.net>
> I am curious: how are your related-tables managed in a relational database
> without FK's? Is there no RDB perspective in the design?
>
>
>
>
> On Mar 27, 2009, at 2:33 PM, Joseph Schmidt wrote:
>
>
>> Just reread your question.. Sorry for
>>> misleading. This is true, Cayenne
>>> cannot know about relationships in DB without FKs. So you
>>> have to map them
>>> manually
>>>
>> Adding manually is not efficient for most cases (too big databases) :(.
>> (This would not convince users to ditch RoR's ActiveRecord for Cayenne :(
>> ).
>>
>> I added a feature request for this:
>> https://issues.apache.org/jira/browse/CAY-1202
>> since Cayenne could infer these relations if they respect the convention.
>>
>> Thanks,
>> Joseph.
>>
>>
>>
>>
>>
>
This archive was generated by hypermail 2.0.0 : Sat Mar 28 2009 - 07:52:14 EDT