Скачать или смотреть Blazor (ASP.NET Core) - Creating A Step By Step Database | EF Core Power Tools | Authentication

Creating A Step-By-Step End-To-End Database Server-Side Blazor Application (.Net Core 5.0)

In this video , we will demonstrate how a list of Weather forecasts can be added to the database by each user. A user will only have the ability to see their own forecasts.

Steps:
Create The Blazor Application.
Open Visual Studio.
Select Create a new Project.
Select Blazor App and click Next.
Name it and click Create.
Select Blazor Server App.
Click the Change link under Authentication.
Select Individual User Accounts and Store user accounts in-app and Click Create.

Create The Database
Open the SQL Server Object Explorer
Add a connection to your local database server if you don’t already have it in the SQL Server list
For this tutorial, we do not want to use the SQL Express server on (localdb)\MSSQLLocalDB that
you may already see in the list.
You will specify just the server and Connect
Give the database a name and press Enter. The database will be created.
Right-Click on the Database node and select Properties.
Open the Properties window if it is not already opened.
The Properties window for the database will display.
Copy the Connection string for the database.
Open the appsettings.json file.
Paste in the connection string for the DefaultConnection and save the file.
Hit F5 to run the application.
The application will open in your web browser. Click the Register link.
Enter the information to create a new account.
Click the Register button.
Because this is the first time the database is being used, you will see a message asking you to run
the migration scripts that will create the database objects needed to support the user
membership code.
Click the Apply Migrations button.
After the message changes to Migrations Applied, refresh the page in the web browser.
After clicking refresh in your web browser, a popup will require you to click Continue.
Click the Click here to confirm your account link.
On the Confirm email page, click the name of the application to navigate to the home page.
Now you can click the Log in link to log in using the account you just created.
You will now be logged into the application.
You can click around the application and see that it works.
The Fetch data page currently shows random data. We will alter the application to allow us to add,
update, and delete this data in the database.
In the SQL Server Object Explorer window, in Visual Studio, we see the tables that the migration
scripts added.
Right-click on the Tables node and select Add New Table.
Paste the script in the T-SQL window and then click the Update button.
Right-click on the table and select Show Table Data.
We will enter some sample data so that we will be able to test the data connection in the next
steps.

Create The Data Context
If you do not already have it installed, install EF Core Power Tools . (Note: Before installing, close
Visual Studio)
Right-click on the project node in the Solution Explorer and select EF Core Power Tools then
Reverse Engineer.
Click the Add button
Connect to the database.
Select the database connection in the dropdown and click OK.
Select the WeatherForecast table and click OK.
Set the values and click OK.
In the Solution Explorer, you will see the Data Context has been created.
Click the OK button to close the popup
Open the Startup.cs file. Add/change the code to the ConfigureServices section

Read From The Database
Inserting Data Into The Database
Updating The Data
Deleting The Data

blazor database connection
blazor database tutorial
blazor database access
blazor entity framework database first
blazor sql
blazor tutorial
blazor c#
blazor train
blazor server
blazor .net 5
blazor authentication
blazor app
blazor app tutorial
blazor asp.net core
blazor beginner
blazor step by step
blazor step by step tutorial
blazor asp.net core
blazor asp.net
blazor asp.net core 3.1
blazor asp-append-version
blazor asp.net core tutorial
asp.net core blazor tutorial
blazor vs asp.net core
blazor webassembly asp.net core hosted
asp.net core blazor crud
asp.net mvc blazor
asp.net blazor webassembly
blazor application
asp.net core blazor
asp blazor
asp.net core blazor kudvenkat
asp.net blazor tutorial
asp.net core 5 blazor