Hi,

I haven't been in llblgen for quite a while now. In a new project, I have a multi-language database (I made my design so that for each table A that contains varchar or text fields, I create a table B that contains those fields along with the culture id for each culture that my site uses as well as a foreign key to table A's primary key. The primary key of table B becomes the foreign key of table A with the culture id) My question is simple, what's the best way to get only the lines of B for the current culture when I do something like A.B[0].Title ?

Thanks!

You would filter on the CultureId when retrieving Entity A. Please refer to "Filtering and sorting" in the LLBLGen Pro documentation.

Also refer to the "Prefetch paths", section so that you can retrieve the related entity B along with A.