WHY ELINQ?

What ELINQ is?

ELINQ is a Language Integrated Query (LINQ) technology for relational databases and Entity Framework (EF) Core. It allows you to use C# to write strongly typed SQL queries. 


ELINQ enhances EF LINQ with new capabilities:

  • Full power of C# for query creation: multiple statements inside lambda, variables, functions, etc.
  • No semantic gap with SQL. ELINQ declares SQL statements (like SELECT, FROM, WHERE) as first class C# methods, combining familiar syntax with intellisense, type safety and refactoring.
  • No limitations. Any practical SQL can be expressed with C# elegance. 


With ELINQ SQL becomes just "another" class library exposing its API locally, literally "Language Integrated SQL".  ELINQ has declarations of all methods and extension in popular databases, so you can  take advantage of all the database features using C#.

Complete Vendor Specific C# Type Declarations

image22
image23
image24
image25
image26