Relationship between classes when using LINQ to SQL (no relationship in the DB) <p>I have two tables in my database -> Activities and Customers. Each Activity has a CustomerId, however the designers of the database haven't added any foreign key constraints. </p> <p>I want to be able to write </p> <pre><code>activity.Customer.Name //Returns name of the customer </code></pre> <p>So I need a way of telling LINQ to SQL to map the CustomerId in the Activity object to the correct Customer object.</p> <p>I could of course do :</p> <pre><code>var customers = db.Customers; var activities = db.Activities; </code></pre> <p>And then manually map them to each other, but that would be a pain...</p> <p>Is this is possible? Adding foreign key constraints is unfortunately not an option. </p>