Category: SQL

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!

We got familiar with Data Base Management System (DBMS) and the Relational Data Base Management System (RDBMS). we explored what is SQL? and what is its purpose. we talked about the difference between SQL and noSQL databases. we downloaded the SQLite DB Browser and created our first DB using SQL queries. then we wrote a C# program which runs queries against the same SQLite DB, using SQLite nugets

More topics covered:

• Advantages of using DBMS
• Advantages of using RDBMS
• DB in JSON format   { key : value }
• DB normalization rules
• Additional data bases: MySQL, MongoDB, PostgreSQL, etc.
• noSQL usages
• C# GetValue command
• Nugets
• SQLite nuget package

Links:

• DB browser for SQLite – download link
• class code: connect to SQLite using C# (+nuget!)
• Advantages of DBMS
• Nuget home page
• SQLite nuget
• Lesson Summary Video
• HomeWork – Part I
• Homework – part II (etgar): improve the program we wrote in class. create a class called Employee (with relevant properties + ctor + toString) and this time read the SQLite table into a list of Employees (List<Employee>). do it by creating new Employee and placing the data you read from GetValue into the Employee properties (don’t forget casting). each time add the Employee into a list. after you done reading the entire query result, use foreach method to print all of the employees.