Linq to Sql外键关系

您好像打错了字：

 var authorsAndTitles =          from title in database.Titles          from book in **tilte**.AuthorISBN          let author = book.Author          orderby author.LastName, aurthor.FirstName, title.BookTitle          select new { author.FirstName, author.LastName, title.BookTitle };

它不应该是title.AuthorISBN指令的litte.AuthorISBN吗？我用**包围了这个词。

除此之外，我会尝试这样做：

var authorsAndTitles =          from title in database.Titles          let author = title.AuthorISBN.Author          orderby author.LastName, aurthor.FirstName, title.BookTitle          select new { author.FirstName, author.LastName, title.BookTitle };

新尝试：

var authorsAndTitles =          from autISBN in database.AuthorISBN          let author = autISBN.Author          let title = autISBN.Titles          orderby author.LastName, author.FirstName, title.BookTitle          select new { author.FirstName, author.LastName, title.BookTitle };