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,
the Telerik team