why SELECT clause comes after FROM clause in LINQ?

Question

Hiten Pandya · Answer

Hi Gajendra, In Linq to sql query from clause denotes that we are going to use this datasource and then declaring the local variable for to be used on each element and then select the required data from datasource using that local variable just like we can't access the variable without declare it first.... So, from below example var query = "from c in dbo.Customer where c.Id=1 select c"; dbo.Customer is our dataSource and c is our one kind of local variable or alias and then we apply the filter in the form of where clause and in last we are fetching the result.

Suraj Kumar · Answer

Hello, Obtaining a Data Source In a LINQ query, the first step is to specify the data source. In C# as in most programming languages a variable must be declared before it can be used. In a LINQ query, the from clause comes first in order to introduce the data source (customers) and the range variable (cust). C# //queryAllCustomers is an IEnumerable var queryAllCustomers = from cust in customers select cust; Thanks

why SELECT clause comes after FROM clause in LINQ?

Answers (2)