The slides in this week discuss the details of a simple online bookstore backed by a database. Other than (i) Visual Studio Community (VSC), (ii) ASP.NET Core, (iii) MVC framework, and (iv) C#, this project uses the following two technologies:
- Microsoft SQL Server, which is a Relational Database Management System (RDBMS). SQL Server uses Structured Query Language (SQL) for interacting with the database and supports Transact-SQL (T-SQL) for handling transactions.
- ASP.NET Entity Framework (EF), which allows .NET developers to interact with relational databases using domain-specific objects, eliminating the need for most of the data-access code that developers would typically need to write. In essence, EF provides an abstraction layer over the database. Developers can work with objects that represent database tables and rows, rather than writing raw SQL queries. This makes data access simpler and faster.
       |
     |
|
“Why do they call it rush hour when nothing moves?” — Robin Williams |