LocalDB | .NET oriented NoSQL database with ACID properties | Database library

I have a .NET 5 Azure Function running with a FUNCTIONS_WORKER_RUNTIME config value of dotnet-isolated.

The function app needs to connect to an Azure SQL database using EF Core 5.0.6.

I followed guidance from this post for EF configuration.

My custom dbcontext is now:

I have this method to generate a jwt token using c# .netcore 3.1 version.

I have the following structure of Razor pages in my project:

Most of the content is available in the Index page. I am working on my local IIS on the localhost. When I type the localhost address in my browser, the Index page is shown as supposed. However, if I type https://localhost:44352/Logout in order to open the Logout page, it calls the OnGet method of the Index page and opens that page instead of calling the OnGet method of the Logout page.

Here is the OnGet method of the Index page:

I need to use dotnet5 with Azure Functions so followed the guidance to create a new solution: https://docs.microsoft.com/en-us/azure/azure-functions/dotnet-isolated-process-guide.

This worked great so next job was to add in serilog with sinks for console and sql server.

I have added nuget packages:

• Serilog.AspNetCore v4.1.0
• Serilog.Sinks.MSSqlServer v5.6.0

Here is the Program.Main:

I was developing my project and this error occurred to me:

"System.Data.SqlClient.SqlException: 'Procedure or function' dbo.Bi_medicaoInset 'expects parameter' @ID_interno_disp ', which was not supplied.'"

I have already searched the internet but I can't find anything to help me.

C# code:

A small project consisting of 2 classes Appointments and Department, I need to be able to select the department name from a dropdown box.

I have tried and asp-items, both are returning nullpointerexcpetion or something similar like ArgumentNullException: Value cannot be null. (Parameter 'items') Appointment Class public class Appointment { [Key] public virtual int Id { get; set; } [Display(Name = "Department")] public virtual int Dep_Id { get; set; } public Department Departments{ get; set; } } Department class public class Department { [Key] public virtual int ID { get; set; } [Required] public virtual string Name { get; set; } } Two controllers using Entity Framework (Web API and MVC) were scaffolded based on these classes and localdb Department table was filled with some values. In the MVC controller generated from Appointment, I created a method public void PopulateDepartmentsDropDownList() { var departmentsQuery = from d in _context.Departments orderby d.Name select d; ViewBag.DepartmentID = new SelectList(departmentsQuery.AsNoTracking(), "ID", "Name"); } And finally in the Create.cshtml also generated from Appointment, these attempts do not work.

generates an empty dropdown and

@Html.DropDownList("dep", new SelectList(ViewBag.DepartmentID, "ID", "Name")) crashes the page.

I am not sticking to any method, any solution that works based on any controller is fine.

I am working on a .NetCore application that uses SQL server and Entity Framework Core. I created a database and I connect to it using the connection string that I show bellow in my json file:

I am having trouble trying to switch over from using a LocalDb to using an instance of SQL express in Microsoft SQL Server. The following is my connection string:

Creating a new Blazor WebAssembly App with Microsoft Visual Studio 2019 Version 16.9.4 with these specifications: Target Framework .NET 5.0, Authentication Type Individual Accounts and ASP.NET Core Hosted:

With no modifications I have simply started the project with IIS Express, ran migrations and added a user to the database.

This works without a problem so then I created a publish profile to folder.

I then set up a new site in IIS, version 10.0.19041.1, and set the Application Pool to use my Windows Identity that I have confirmed works with SSMS and that works via IIS Express.

Running it the first time I got this error in Windows logs:

System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Extensions.DependencyInjection.IdentityServerBuilderConfigurationExtensions.<>c.b__10_2(IServiceProvider sp)

I fixed this by adding a Key to IdentityServer in appsettings.json exactly like appsettings.Development.json does it: