how to translate a linq expression into sql string use c# code

Question

how to translate a linq expression for example

var query = (from article in ArticleRepository.GetAll()
            join read in ArticleReadRepository.GetAll() on read.ArticleId equals article.Id
            where article.Id>10
            select new 
            {
                article.Title,
                read.ReadCount
            }).ToList();

into sql string

select article.Title,
       read.ReadCount 
       from ArticleTable as article 
       join ArticleReadTable as read on read.ArticleId = article.Id 
       where article.Id>10

use c# code

Gilad Green · Accepted Answer · 2016-08-16 05:38:45Z

2

Print query.ToString() and you will see the query formed by the LINQ expression

For example,

var query = from emp in v.Employees
            select emp;
var sqlQuery = query.ToString();
Console.WriteLine(sqlQuery);

The result will be:

SELECT 
[Extent1].[ID] AS [ID], 
[Extent1].[Name] AS [Name]
FROM [dbo].[Employee] AS [Extent1]

edited Aug 16, 2016 at 5:38

Gilad Green

37.3k7 gold badges67 silver badges99 bronze badges

answered Aug 16, 2016 at 5:14

Richa Garg

1,93615 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Reimu Lyu Over a year ago

actually,i want to know the implementing of query.ToString()...ok,i will see the source code for it.

Richa Garg Over a year ago

You can retrieve it as a string from query.ToString and fire it as a sql query.

Richa Garg Over a year ago

@ReimuLyu Please mark it as an answer if it solved your problem

Collectives™ on Stack Overflow

how to translate a linq expression into sql string use c# code

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related