Basic.md

SQL Server Basics

We suggest to open the corresponding tutorial page and go over the examples "side by side".

Disclaimer: Linq handles most of functionality up to tutorial's section 7 very elegantly. There is no much value in replacing it for these cases. The reason we demonstrate the basic SQL capabilites of ELINQ is that the advanced cases are built on patterns of simple cases.

So before jumping to the advanced cases, we suggest to go over and run few basic ones to understand how ELINQ works.

• Section 1. Querying data
• Section 2. Sorting data
• Section 3. Limiting rows
• Section 4. Filtering data
• Section 5. Joining tables
• Section 6. Grouping data
• Section 7. Subquery
• Section 8. Set Operators
• Section 9. Common Table Expression (CTE)
• Section 11. Modifying data

Section 1. Querying data

• SELECT

Section 2. Sorting data

• ORDER BY

Section 3. Limiting rows

• OFFSET FETCH
• SELECT TOP

Section 4. Filtering data

• DISTINCT
• WHERE

Section 5. Joining tables

• INNER JOIN
• Since joins in ELINQ are functions, using a required join type is merely a call to the correct function.

Section 6. Grouping data

• GROUP BY
• HAVING
• GROUPING SETS
• CUBE and ROLLUP

Section 7. Subquery

• Subquery
• Correlated subquery
• EXISTS, ANY and ALL are covered in Subquery

Section 8. Set Operators

• UNION, INTERSECT, EXCEPT

Section 9. Common Table Expression (CTE)

• CTE
• Recursive CTE

Section 10. Pivot

• Not Supported 😬

Section 11. Modifying data

• INSERT
• INSERT multiple rows (with Batch Insert example)
• INSERT INTO SELECT (Bulk Insert)
• UPDATE (Bulk Update)
• UPDATE JOIN (Bulk Update)
• DELETE (Bulk Delete)
• MERGE (Upsert)

---

< BACK | HOME