Create a database called inventory in MSSQL server $($Local SQL$),$ and create a table called

product with the following attributes$-$ id$,$ name, price, unitsInStock. Select appropriate attribute

type. Insert at least $10$ records in it$.$ NOTE: you must submit the SQL code you used to create the

table and data for this assignment.

Create a Blazor Server Web Application meeting the following requirements$-$

a$.$ Connect to the inventory database from Visual Studio

b$.$ Install Entity Framework Core SqlSever and Tools packages.

c$.$ Using database Scaffold command to create the Model and DbContext files

i$.$ Example: Scaffold$-$DbContext "Data Source$=$DESKTOP$-$JTBAQ$5$T

MSSQLSERCSCI$4405$;Initial Catalog$=$sample;Integrated Security$=$True;

TrustServerCertificate$=$True $"$ Microsoft.EntityFrameworkCore.SqIServer $-$

OutputDir Models $-$Tables employee

d$.$ Add a nav menu called Products and connect to page called ProductInfo$($Razor

component$)$

e$.$ Display all the product information in the Products pages.