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: sqlite c# demo-1
- class code: sqlite c# demo-2
- demo code: connect to SQLite using C# (+nuget!)
- SQLite – tutorials point
- 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). 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.
dotnethacker.home.blog 