Hi

I have the following scenario and would like to use LLBLgen without making customize views inside SQL server.

Any suggestions?

Selectstatement

SELECT TBLadmin_navigation.id, TBLadmin_navigation.adminNaviUrl, TBLadmin_text.text FROM TBLadmin_navigation INNER JOIN TBLadmin_text ON TBLadmin_navigation.textPosition = TBLadmin_text.textPosition WHERE (TBLadmin_navigation.AdminNaviModule = 1) AND (TBLadmin_text.languageId = @userLanguage) ORDER BY TBLadmin_navigation.AdminNaviOrder

TBLadmin_navigation: id - int primary key adminNaviUrl - varchar adminNaviModule - int adminNaviOrder - int textPosition - varchar

TBLadmin_text id - int primary key text - varchar textPosition - varchar languageId - int

Its not possible to set an relation between textPosition in SQL server, so how can I do this with LLBLgen.

Currently I have made a view in SQL server, which gives me a DataView using TypedViewClasses, but I would rather have an AdminNavigation object with an 1-1 relation with AdminText.

In the designer you can't define that relation, so that will be a no-show. You can try at runtime to create an EntityRelation object and add that to the RelationCollection, please check the generated code's Relations folder for classes with code which illustrate how to create an EntityRelation object.