How is this standard C# code to work over a list: var males = from p in context.... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

scarface74 on Sept 21, 2019 | parent | context | favorite | on: What ORMs have taught me: just learn SQL (2014)

How is this standard C# code to work over a list:

  var males = from p in context.Person where p.Sex = “M” select c;

Any more imperative whether context represents a C# object or a database?

takeda on Sept 23, 2019 [–]

Well, LINQ is special, it is a language that is similar to SQL that's inside of another language. Such code then is translated to SQL. The language is still not SQL but SQL-like and is incomplete, for example you can't do CTE in it.

Consider applying for YC's Winter 2027 batch! Applications are open till November 2.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact