You are right that with the “classic” wizards it is possible to create a one to one relationship between two tables. In most of the cases this relationship works – the linkage is maintained and selecting either of the table you are getting records from both tables.
However, there is a limitation in this approach. When you try to insert a new row in both tables, a foreign key exception is thrown, since the order of the insert is not maintained properly. This means that while the one to one relationship might look slightly better in the classic wizards as a matter of data retrieval, it has the same problems with the insert command. The workarounds for that limitation would be the same as described in the knowledge base article.
We will consider implementing a better linkage maintenance in the Visual Designer (similar to the one used in the wizards) for one of the future releases in order to have easier data retrieval in such cases.
Do not hesitate to contact us in case you have any questions.
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>