Try .NET /elinq/
Powered by Try .NET

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 10. Pivot

Section 11. Modifying data