Hello Zhen,
Thank you for your feedback.
In general, Telerik Data Access does not support such a scenario.
However, you can achieve the outcome you need (a custom subset of the columns of more than one table) with the help of
anonymous types and
LINQ projection. The idea is that you do not define a strongly typed class in your code and leave the compiler to encapsulate a set of properties into a single object. The properties in this case, would be the columns of the tables from which you select. Here is an example:
Here, the type of the
query variable is anonymous type and the projection is the subset of properties defined after the
select new statement.
I hope this helps. Let us know, if you need further information.
Regards,
Doroteya
Telerik
OpenAccess ORM is now
Telerik Data Access. For more information on the new names, please, check out the
Telerik Product Map.