0
I think the problem lies in your queries. ( i don't know if they work i gues not).
use the following examples:
example innerjoin:
var innerJoinQuery =
from category in categories
join prod in products on category.ID equals prod.CategoryID
select new { ProductName = prod.Name, Category = category.Name }; //produces flat sequence
example groupjoin:
var innerGroupJoinQuery =
from category in categories
join prod in products on category.ID equals prod.CategoryID into prodGroup
select new { CategoryName = category.Name, Products = prodGroup };
or
var innerGroupJoinQuery2 =
from category in categories
join prod in products on category.ID equals prod.CategoryID into prodGroup
from prod2 in prodGroup
where prod2.UnitPrice > 2.50M select prod2;
example left outer join:
var leftOuterJoinQuery =
from category in categories
join prod in products on category.ID equals prod.CategoryID into prodGroup
from item in prodGroup.DefaultIfEmpty(new Product { Name = String.Empty, CategoryID = 0 })
select new { CatName = category.Name, ProdName = item.Name };
The problem wich i had to face was that i was trying tu update 2 tables during a joing. But that wasn't possible. so i had to write 2 single update queries one for the first table and one for the second table. Offcourse you can add paramethers.
Hope this helps.
Kind regards
