An ASP.NET Database Project

---

The slides in this week discuss the implementation details of the first online bookstore backed by a database which uses only one table. Other than

• Visual Studio Community (VSC),
• ASP.NET Core Web App,
• MVC framework, and
• C#,

this project uses the following two technologies:

• 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.

• Entity Framework (EF) Core, 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.