Hi, I have a table in my database with no FK relation to other tables. But conceptually all of the tables in my database are related to this table. This table contains a list of enumeration values like (gender: 100->male, 101->female etc.). Other tables use primary key values of this table. For example:

Employee Table:

Firstname:string Lastname:string GenderCode:100 (100 is the primary key of the 'male' record in the enumerations table) . . .

There is no physical relation between 'GenderCode' and the primary key of the enumerations table. Is it possible to use 'Prefetch' for 'GenderCode' of this table?

Regards, Farzad Badili

You could create a relation in the designer.

Be aware that if a table has relations to all other entities, it's mandatory that you hide the fields mapped onto relations on the PK side, otherwise that side will get a lot of collections generated into the code.

Is there any chance to solve this problem without creating relations in the designer?

no, prefetching is meant to fetch related entities into collections/references which are known at compile time, i.e. 'CustomerEntity.Orders'.