
We discussed the separation between Graphic User Interface (GUI), Business Logic (BL) and Data Access Layer (DAL) – which includes the Data Access Object (DAO). We explored the table relationship flavors 1:1 , 1:many , many:many. we created two SQLite tables containing 1:1 relationship using Primary Key (PK) and Foreign Key (FK) references. then we wrote a C# program which executes a join query on these two tables, and stored the result in an anonymous object (for a new view)

More topics covered:
- Join select query in C#
- Creation of anonymous object from an SQL result
- Combining PK + FK between two tables (SQLite)
- Creating SQLite table with FK null chicken-egg dilemma
Links:









