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:
(EntitiesModel dbContext =
var query = (from c
dbContext.Categories on c.CategoryID equals cat.CategoryID
MyCategory = cat.CategoryName,
TagNumber = c.TagNumber,
Model = c.Model,
Make = c.Make
Here, the type of the query
variable is anonymous type and the projection is the subset of properties defined after the select new
I hope this helps. Let us know, if you need further information.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map