Example of joining two tables - Entity Framework
var data = db.Categorie
.Join(db.CategoryMap,
cat => cat.CategoryId,
catmap => catmap.ChildCategoryId,
(cat, catmap) => new { Category = cat, CategoryMap = catmap })
.Select(x => x.Category);
See more details : http://stackoverflow.com/...
