In this React 18: Full Course Video Tutorial, we'll be covering everything you need to know about React 18! From creating a basic React component to creating more advanced React components, we'll be covering everything in this React tutorial for beginners.
WASM and .NET are two functionalities of Blazor that make it difficult to compare with other SPA frameworks and libraries.
Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability1. This marks the latest milestone in the more than 30-year history of SQL Server.
Blazor Fundamentals Tutorial
Blazor server-side vs client-side (WebAssembly) | What should you choose?
What are Razor Components? | Blazor Tutorial 1
Dependency Injection | Blazor Tutorial 2
What are Blazor Layouts? | Blazor Tutorial 3
Routing and Navigation | Blazor Tutorial 4
JS Interop: Calling JavaScript from C# | Blazor Tutorial 5
JS Interop: Calling C# methods from JavaScript | Blazor Tutorial 6
Creating Forms with Validation | Blazor Tutorial 7
How to add Authentication in Server-side Blazor | Blazor Tutorial 8
Authorization in Server-Side Blazor | Blazor Tutorial 9
How to use HTML5 Web Storage in Blazor | Blazor Tutorial 10
Managing Blazor state using Redux | Blazor Tutorial 11
Creating a desktop application using Blazor and Electron | Blazor Tutorial 12
Deploying Server-Side Blazor in Azure with SignalR service | Blazor Tutorial 13
Building cross platform mobile apps with Blazor (Experimental)
If you enable our semantic highlighting support then, be sure to try out the included Visual Studio 2019 Light and Dark themes. TypeScript looks great in it too!
NOTE: For semantic highlighting ensure that editor.semanticHighlighting.enabled and csharp.semanticHighlighting.enabled are set to true.
npm@5 takes npm a pretty big step forward, significantly improving its performance in almost all common situations, fixing a bunch of old errors due to the architecture, and just generally making it more robust and fault-tolerant.
USE [WideWorldImporters];
GO
SET STATISTICS IO ON;
GO
/*
What's are the inner and outer
data sets?
*/
SELECT
[ol].[OrderLineID],
[o].[CustomerID]
FROM [Sales].[OrderLines] [ol]
INNER JOIN [Sales].[Orders] [o]
ON [ol].[OrderID] = [o].[OrderID]
WHERE [o].[CustomerID] = 185;
GO 
SELECT
[ol].[OrderLineID],
[o].[CustomerID]
FROM [Sales].[OrderLines] [ol]
INNER JOIN [Sales].[Orders] [o]
ON [ol].[OrderID] = [o].[OrderID]
WHERE [o].[CustomerID] = 185
OPTION (FORCE ORDER); 
SELECT
[ol].[OrderLineID],
[o].[CustomerID]
FROM [Sales].[OrderLines] [ol]
INNER LOOP JOIN [Sales].[Orders] [o]
ON [ol].[OrderID] = [o].[OrderID]
WHERE [o].[CustomerID] = 185
OPTION (FORCE ORDER);
GO 
SELECT
[ContactPersonID],
[OrderDate],
[CustomerPurchaseOrderNumber]
FROM [Sales].[Orders]
WHERE [ContactPersonID] = 3144; 
ALTER TABLE [Sales].[Orders] ADD CONSTRAINT [PK_Sales_Orders] PRIMARY KEY CLUSTERED ( [OrderID] ASC ) GO CREATE NONCLUSTERED INDEX [FK_Sales_Orders_ContactPersonID] ON [Sales].[Orders] ( [ContactPersonID] ASC )
CREATE NONCLUSTERED INDEX [FK_Sales_Orders_ContactPersonID] ON [Sales].[Orders] ( [ContactPersonID] ASC ) INCLUDE ( [OrderDate], [CustomerPurchaseOrderNumber] ) WITH (DROP_EXISTING = ON) ON [USERDATA]; GO
SELECT
[ContactPersonID],
[OrderDate],
[CustomerPurchaseOrderNumber]
FROM [Sales].[Orders]
WHERE [ContactPersonID] = 3144; 
USE [WideWorldImporters] GO DROP TABLE [Sales].[Copy_Orders] GO SELECT * INTO [Sales].[Copy_Orders] FROM [Sales].[Orders]; GO CREATE NONCLUSTERED INDEX [NCI_Copy_Orders_ContactPersonID] ON [Sales].[Copy_Orders] ( [ContactPersonID] ); GO
SELECT
[ContactPersonID],
[OrderDate],
[CustomerPurchaseOrderNumber]
FROM [Sales].[Copy_Orders]
WHERE [ContactPersonID] = 3144; 
CREATE NONCLUSTERED INDEX [NCI_Copy_Orders_ContactPersonID] ON [Sales].[Copy_Orders] ( [ContactPersonID] ASC ) INCLUDE ( [OrderDate], [CustomerPurchaseOrderNumber] ) WITH (DROP_EXISTING = ON) ON [USERDATA]; GO
See the following table to select the correct download
| OS | Development Environment | .NET Core SDK |
|---|---|---|
| Windows | Visual Studio 2019 version 16.6 | 3.1.302 |
| Windows | Visual Studio 2019 version 16.4 | 3.1.106 |
| MacOS | Visual Studio for Mac | Visual Studio for Mac .NET Core Support |