I am using SQL Server Denali to create 2 tables with a 1-many relationship. But I got the result of a query just like there was no relationship at all.
Anyone please tell me if this is a bug of Denali, or there is something to do to make the relationship to work.
Problem solved by creating the relationship manually in query builder.
Query builder does not show up any relationship created by CREATE TABLE statement whereas Database Diagrams does. Is there any way to get the relationships from the database to query builder?