LINQ to SQL Table Dependency

Question

If I have two tables... Category and Pet. Is there a way in LINQ to SQL to make the result of the joined query map to a another strongly typed class (such as: PetWithCategoryName) so that I can strongly pass it to a MVC View? I currently have Category and Pet classes... should I make another one? Maybe I missing something here. Can any of you enlighten me? ``` from p in petTable join c in categoryTable on p.CategoryId equals c.Id where (c.Id == categoryId.Value) select new { p.Id, p.Name, p.Description, p.Price, CategoryName = c.Name }

Accepted Answer

How would I go about using LoadWith? I'm not finding much help online. Any good resources?

I found this online: http://blogs.msdn.com/wriju/archive/2007/10/04/linq-to-sql-change-in-datacontext-from-beta-1-to-beta-2.aspx

You would do something like:

```
var loadOption = new DataLoadOptions();           
loadOption.LoadWith<Pets>(p => p.Category);
db.LoadOptions = loadOption;

var pets = from p in PetStoreContext.Pets
           select p;
```

And then your pets query will already include category, so no trip to the database happens when you try to access category.

LINQ to SQL Table Dependency

Solution

Problem