We explored the many : many table relationship architecture using Primary Key (PK) in one table (for example Customers table) and using Primary Key (PK) in a second table (for example Products table) and using a set of 2xPrimary Keys (PK) in a third table (for example Orders table). both of these primary keys are also defined as Foreign Keys (FK) to the first two tables. so what did we gain? we got customers which could buy many products. and products which could be bought buy many customers, so there we have- many : many. each purchase is a new row in Orders table. we saw how to combine all of these three tables in a join query. we also saw how to create a DB using Sql Server Management Studio (SSMS) in MSSQL. and how to read the tables from c#.
More topics covered:
- more complicated nested queries
- Go keyword in MSSQL
- Connecting VS 2017 to MSSQL directly
- MSSQL connection string using integrated security
Links:
.NET Experts 