Re: Child table loading with LinqToSql

2010-09-24 Thread Corneliu I. Tusnea
David, You can use DefaultIfEmpty to get your Left Outer Join http://social.msdn.microsoft.com/Forums/en-US/linqprojectgeneral/thread/c139313e-d745-4e1d-b3dc-ab355507eb48 Corneliu. On Thu, Sep 23, 2010 at 12:37 PM, Arjang Assadi arjang.ass...@gmail.comwrote: If Anyone is intrested in Entity

Child table loading with LinqToSql

2010-09-22 Thread David Burela
I am using LinqToSql on a project, and Ria services to expose it as an IQueryable. I want to send my Product table along with its child tables (e.g. ProductStatus, ProductCategory) To do this I am using the standard public IQueryableProduct ProductSelect() { DataLoadOptions loadOpts = new

Re: Child table loading with LinqToSql

2010-09-22 Thread David Burela
This has been solved. For anyone that is interested, it has to do with the foreign key in the DBML. If the foreign key is not nullable it will do an inner join. If you make the field nullable then it will do a left join. On 23 September 2010 10:28, David Burela david.bur...@gmail.com wrote: I