
考慮以下的程式碼:
KTBOOKSEntities ke = new KTBOOKSEntities();
var v = from b in ke.Books
where b.BookPrice <>700
ObjectQuery
msg+="\n\n SQL ... \n"+objv.ToTraceString();
以下是輸出的 SQL 字串,msg 變數的內容:
SELECT
[Extent1].[BookID] AS [BookID],
[Extent1].[BookTitle] AS [BookTitle],
[Extent1].[BookISBN] AS [BookISBN],
[Extent1].[BookPrice] AS [BookPrice],
[Extent1].[BookAuthor] AS [BookAuthor],
[Extent1].[BookCategoryID] AS [BookCategoryID]
FROM [dbo].[Book] AS [Extent1]
WHERE [Extent1].[BookPrice] <> 700
沒有留言:
張貼留言