Linq to Sql外键关系

Question

null

null

表名:authorisbn

• ISBN->外键
• authorid->外键

既然Linq-to-SQL会根据外键关系自动创建属性，为什么下面的代码块不会触发智能感知呢？对我来说不是...

它不允许我添加照片，但“author”与AuthorISBN有“一对多”关系，“titles”也与AuthorISBN有“一对多”关系

代码：

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

Answer 1

你好像打错了字：

 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和tilte.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 };