Hello,
I have a resultset that currently looks something like this:
ResultsetFields lrsFields = new ResultsetFields(14);
lrsFields.DefineField(UserFieldIndex.FirstName, 1, "FirstName");
...
lrsFields.DefineField(UserFieldIndex.WorksFor, 12, "WorksFor");
This is working OK, but WorksFor is a foreign key that references itself (User table). How can I add UserFieldIndex.FirstName, but for the WorksFor relationship? Is there a way to do something like this when a table references itself?
I can do this using a prefetched path, but I can't seem to do it using the resultset.
UserEntity user = new UserEntity(10);
//create prefetched path
//fetch entity
user.Firstname; //Users first name
user.User.FirstName; //Managers first name