Hello flexcoders,
following the «Managed Associations» approach, I just encountered a
question.
Please assume this:
I have a set of entities created in my database, i.e. Employee and
Company - to stick with the examples. In contradiction to the examples,
assume that they relate in a n-m manner, meaning one company can have
any number employees and one employee can have any number of companies.
For that, to come up with a good database layout, I'd need to design a
corresponding relation in the database - «Employee», «Company» and
«EmployeeHasCompany» (the ladder one is the n-m relation - it holds
foreign keys to each, employee and company).
Let's say all of that is set so far and the application's requirements
demand the database level cohesion of data and for that, require the
table structure to be like I pointed out.
Now here's some random thoughts... How do I model that for use with the
Flex Data Services? I know, there's some destination properties
(one-to-one, one-to-many, ...) on which basis FDS manages data supply.
Isn't that situation not only redundant but also risky to use? I'm
thinking of transactions, date consistency and else... And how do I
update the EmployeeHasCompany relation with new data? Is it like I need
to trust FDS to do the right things? I'm afraid of losing control here.
So all in all, I think, my question is how to transfer the database
model accordingly to the FDS confuguration? Or maybe I'm just off the
track here.
Cheers, Thomas
------------------------------------
Thomas Rühl
Design, Programming & Concepts
akitogo OHG
Hanauer Landstrasse 188
60314 Frankfurt
Telefon +49 (0) 69 800 69 445
Fax +49 (0) 69 800 69 449
Mobil +49 (0) 179 750 75 87
E-Mail thomas.ruehl@akitogo.com
Web http://www.akitogo.com
------------------------------------