EP03 - BlazorChartJS - Create Project and Start EF Core with SQL Db Configurations

This video will cover how to create a Blazor server-side project and start the integration of EF Core. We will also create a model and begin the SQL Server database connection process. The data from the SQL Database will be used later in this video series to build Charts from the Chart.js JavaScript library. We are using Visual Studio Community 2019 and Microsoft SQL Server Management Studio 2019 with a SQL Server Express installation. All software is free and is available on Microsoft's website for download. I have included the links in the description below. Free Software Downloads from Microsoft.com: • VS Community 2019: https://visualstudio.microsoft.com/downloads/ • SQL Server 2019: https://www.microsoft.com/en-us/sql-server/sql-server-downloads Also if you missed the previous BlazorChartJS video for this project, I've left the link in the description,... as well as the source code to the project. Previous Video & URL: EP02 - BlazorChartJS - Create SQL Server Database: https://youtu.be/z5Y83_BXfAI Complete BlazorChartJS Playlist - Blazor Server-side, Chart.js, C#, .NET Core & SQL Server: https://www.youtube.com/playlist?list=PL18sVs24YATWxCkJYlxSPZJxr3yYyP5Pi Source code: Coming soon on GitHub. Don't forget to ... SUBSCRIBE • LIKE • SHARE • FOLLOW • COMMENT Chapters: 00:00 ... Intro, Title & Outline 01:18 ... Show ChartStats Database in SQL Server Management Studio 01:43 ... Open Visual Studio to Create Blazor Server-side Project 02:13 ... Name Project BlazorChartJS and Save to Folder Location 02:55 ... Choose Server-side Blazor, Configure for HTTPS and Create Project 03:22 ... Project Displays in Visual Studio 03:36 ... Run Project before Making Changes 03:50 ... Demo Project using Home, Counter and Fetch Data Components 04:35 ... Prepare Project for SQL Data Access 04:50 ... Add ChartStats SQL Database Connection String to appsettings.json 06:45 ... Show Index, Counter and Fetch Data Components in Solution Explorer 07:12 ... Create Models Folder for City Model Class 07:44 ... Create City Model Class 08:43 ... Add C# Properties to City Class that Match Columns in the Cities Table 11:19 ... Add Key Attribute to City_ID to Identify Primary Key 11:44 ... Install Missing Entity Framework Core NuGet Packages 14:20 ... Navigate Back to City.cs Class 14:39 ... Add Using Statements for EF Core Namespaces to City Class 15:13 ... Add Table Attribute to City Class 16:00 ... Add Using Statements for DataAnnotations.Schema Namespace to City Class 16:32 ... Add Using Statement for EF Core Namespace to City Class 17:13 ... Save and Run Project 17:41 ... Test Project using Home, Counter and Fetch Data Components 18:11 ... Next Video Banner and Outro Thank you! - Travis