摘要:
LINQ to SQLLINQ to SQL执行标准数据库命令*查询并创建Id&Title匿名类型LINQ to SQL CodeMydataDataContext data = new MydataDataContext(); var query = data.Article.Select(m => new { Id = m.ArticleID, Title = m.ArticleTitle });SqlCodeSELECT [t0].[ArticleID] AS [Id], [t0].[ArticleTitle] AS [Title]FROM [dbo].[Article] 阅读全文
摘要:
LINQ to SQL下载LINQ to SQL Debug Visualizerhttp://www.scottgu.com/blogposts/linqquery/sqlserverQueryVisualizer.zipLINQ to SQL执行标准数据库命令*查询文章类别ID为34的文章标题并排序取4条Take()取元素条数 =>TopLINQ to SQL Code MydataDataContext data = new MydataDataContext(); var query = data.Article.Where(m => m.CategoryID == 34) 阅读全文