Hi Mehul Patni,
The case statement should work exactly as you have written it. The problem here is that Telerik OpenAccess ORM does not support joins in Linq queries yet. This functionality is scheduled to be implemented for our 2009 Q3 release later this year. In the meantime you can use a reference from the
VARMSContract class to the VARMSEmployee class. If you are using the Reverse mapping approach but you do not have this reference, you can create it from the Reverse mapping wizard. Open the wizard and select the
VARMSContract.EmployeeID from the treeview. Then click the "Create Ref." button, choose the reference type (
VARMSEmployee) and select the
EmployeeID column from the combobox in the grid below. Regenerate the class and the reference should be there. Now you will be able to reach the related employee object from
VARMSContract.TheNewReferenceName and use it in the Linq query.
All the best,
Alexander
the Telerik team