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 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!
dotnethacker.home.blog 