Create LINQ association without foreign keys

Question

Is it possible to have something like ContactAddress.Contact in LINQ without creating a foreign key relationship in SQL Server between the two (which could be related to Contact.Id ↔ ContactAddress.ContactId)?

Thanks:)

Answer 1

If you want to create relations on your object-relational map (even if these relations do not exist in the database as a declared foreign key), you can do this using the Object-Relational constructor.

http://msdn.microsoft.com/en-us/library/bb629295.aspx

Answer 2

, , . , LINQ to SQL, , :

from category in db.Categories
from product in category.Products
select new
{
    Category = category,
    Product = product
}

T-SQL, :

from category in db.Categories
join product in db.Products on category.CategoryId equals product.CategoryId
select new
{
    Category = category,
    Product = product
}

:

SELECT
    *
FROM
    Category INNER JOIN Product ON Category.CategoryId = Product.CategoryId

, .