Thank you for your patience.
At the time present, the DefaultIfEmpty() support on collection navigation properties is not released. However, you can achieve the needed LEFT JOIN (and respectively the result) with the help of our Fetch Plans
feature. Basically, it allows you to query for the objects related to a given one, in just one statement. The following example utilizes the Include
extension method of Telerik Data Access, but you could also use the rest of the methods and patterns
provided by the Fetch Plans API:
(EntitiesModel db =
var result = from c
db.Customers.Include(c => c.Orders)
where c.CustomerID ==
The generated SQL statement would be similar to this one:
(a.[CustomerID] = b.[CustomerID])
Note that the extension method is in the Telerik.OpenAccess namespase, and you may need to add a using clause in your code.
Additionally, I will make sure to update this thread as soon as the support of DefaultIfEmpty() on collection navigational properties is available.
I hope you find this feasible. If you need further assistance, do not hesitate to get back to us.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map