You're reading from C# 11 and .NET 7 – Modern Cross-Platform Development Fundamentals Start building websites and services with ASP.NET Core 7, Blazor, and EF Core 7

Product type Paperback

Published in Nov 2022

Publisher Packt

ISBN-13 9781803237800

Length 818 pages

Edition 7th Edition

Languages

Tools

.NET

Concepts

Server Side Web Development

Author (1):

Mark J. Price

View More author details

Table of Contents (19) Chapters

Preface

1. Hello, C#! Welcome, .NET!

2. Speaking C# FREE CHAPTER

3. Controlling Flow, Converting Types, and Handling Exceptions

4. Writing, Debugging, and Testing Functions

5. Building Your Own Types with Object-Oriented Programming

6. Implementing Interfaces and Inheriting Classes

7. Packaging and Distributing .NET Types

8. Working with Common .NET Types

9. Working with Files, Streams, and Serialization

10. Working with Data Using Entity Framework Core

11. Querying and Manipulating Data Using LINQ

12. Introducing Web Development Using ASP.NET Core

13. Building Websites Using ASP.NET Core Razor Pages

14. Building Websites Using the Model-View-Controller Pattern

15. Building and Consuming Web Services

16. Building User Interfaces Using Blazor

17. Epilogue

18. Index

Building an entity model for use in the rest of the book

Practical applications usually need to work with data in a relational database or another data store. In this chapter, we will define an entity data model for the Northwind database stored in SQL Server or SQLite. It will be used in most of the apps that we create in subsequent chapters.

The Northwind4SQLServer.sql and Northwind4SQLite.sql script files are different. The script for SQL Server creates 13 tables as well as related views and stored procedures. The script for SQLite is a simplified version that only creates 10 tables because SQLite does not support as many features. The main projects in this book only need those 10 tables so you can complete every task in this book with either database.

Instructions to install SQLite can be found in Chapter 10, Working with Data Using Entity Framework Core. In that chapter, you will also find instructions for installing the dotnet-ef tool, which you will use to scaffold...