表名:Author
表名:Titles
表名:AuthorISBN
下面的代码块为什么不触发intellisense,因为Linq会根据外键关系自动创建属性?在我的情况下它不..。
错误:
名称标题在title.AuthorISBN中的当前上下文中不存在 它不允许我添加一张照片,但“作者”与AuthorISBN有一对多的关系,而“标题”也与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 };发布于 2012-09-19 19:46:03
你好像犯了个错误:
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 };https://stackoverflow.com/questions/12501285
复制相似问题