We solved some SQL queries and talked about different SQL JOIN query flavors. we took a brief look on the SQL Server Management Studio (SSMS) and ran a few queries against the MicroSoft SQL Server (MSSQL) [will be elaborated in our next classes]. We made a Plain Old C# Object (POCO) class and used it to store information which we read from the database (into a List). In other words, we used the Program.cs class to behave as an Access Data Object (ADO) to our data base. then we got familiar with the concept of querying List<Employee> using Language Integrated Queries (LINQ) using the two formats: query syntax (looks like SQL) and method syntax (using lambda => expression)
More topics covered:
- POCO constrains
- Immediate window (Alt + Ctrl + I)
- SQLITE syntax vs MSSQL syntax
- LINQ Anonymous objects
- SSMS query runner
Links:
- MSSQL 2017 download link – developer edition
- class code: DAO and LINQ sample code
- Previous homework solution (contributed by Erez Peer)
- DAO – wikipedia link
- DAO – Java reference (click if you dare)
- LINQ query syntax – MSDN link
- LINQ – command!
- LINQ query syntax vs method syntax
- Lesson Summary Video!
- Homework!
.NET Experts 