MvcMovie | A movie system with ASP.NET MVC technologies | Model View Controller library

I'm following Microsoft's ASP.NET MVC tutorial, and as part of it, I generated CRUD operations for the model Movie through scaffolding.

The Index view has the following line at the top:

I'm following Microsoft's tutorial on MVC in ASP.NET Core 5.0, using VS Code and the terminal, and I got stuck on the Initial Migration step.

There are numerous similar questions on SO, but none of them contain an answer I can understand, as this is my first dive into ASP.NET.

The tutorial asks that I run the following commands:

I have a Model.

I am able to access sql server azure from my .net core application running in app service by using AAD authentication. To be able to do so it was necessary to register user assigned managed identity in sql server and it was done by following steps in this article . In addition, it was necessary to specify AzureServicesAuthConnectionString (RunAs=App;AppId=c5309486-960d-46f4-bbea-XXX) to allow applicaiton code to request authentication token from Azure token provider, more info here

Now I am trying to migrate my application into AKS cluster. I am following instructions from https://www.cloudiqtech.com/implementing-azure-ad-pod-identity-in-aks-cluster/ to install Azure identity into cluster by using kubernetess application https://github.com/Azure/aad-pod-identity After all configuration was created, I also added AzureServicesAuthConnectionString to config map but the application fails with the following message :

An error occurred seeding the DB.

System.AggregateException: One or more errors occurred. (Parameters: Connection String: RunAs=App;AppId=a349660d-cbfd-45fc-a917-XXX, Resource: https://database.windows.net/, Authority: . Exception Message: Tried to get token using Managed Service Identity. Access token could not be acquired. The operation was canceled.)

---> Microsoft.Azure.Services.AppAuthentication.AzureServiceTokenProviderException: Parameters: Connection String: RunAs=App;AppId=a349660d-cbfd-45fc-a917-XXX, Resource: https://database.windows.net/, Authority: . Exception Message: Tried to get token using Managed Service Identity. Access token could not be acquired. The operation was canceled.

at Microsoft.Azure.Services.AppAuthentication.AzureServiceTokenProvider.GetAuthResultAsyncImpl(String resource, String authority, Boolean forceRefresh, CancellationToken cancellationToken)

at Microsoft.Azure.Services.AppAuthentication.AzureServiceTokenProvider.GetAccessTokenAsync(String resource, String tenantId, Boolean forceRefresh, CancellationToken cancellationToken)

--- End of inner exception stack trace ---

at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

at System.Threading.Tasks.Task`1.get_Result()

at MvcMovie.DataAccess.MovieContext..ctor(DbContextOptions`1 options)

at MvcMovie.DataAccess.SeedData.Initialize(IServiceProvider serviceProvider)

at MvcMovie.Program.Main(String[] args)

I'm new to ASP.NET MVC, so this issue might not be too complex. I'm having problems when adding pagination to an ASP.NET MVC project. I've installed pagedlist.mvc from the NuGet package installer and then wrote this simple index code in the controller to pass a paged list:

I'm new to ASP.NET MVC and I get the

"NullReferenceException: Object reference not set to an instance of an object"

exception when trying to display data from a database. I have the Movies and Reviews tables that are connected like this:

I am currently trying to teach myself some .net core code.

I am currently following a tutorial on the Microsoft site.

when I try and build my code i get the following error:

/Users/xxxx/dotnet/MvcMovie/Startup.cs(1,16): error CS0234: The type or namespace name 'Data' does not exist in the namespace 'MvcMovie' (are you missing an assembly reference?) [/Users/xxxx/dotnet/MvcMovie/MvcMovie.csproj]

My Startup.cs file looks like this

I am trying to go to the following page in the tutorial:

https://localhost:44336/HelloWorld/Welcome

I created an ASP.NET Core MVC web application project and added a controller called HelloWorldController in the Controllers folder and used the following commands instead of the previous ones.

in VS 2019 i have created an web-app like this:

After that i have:

1. Created a database, and added it in VS2019 "SQL server explorer" (so connection is fine)
2. Then Scaffolded according to the command in the lasted post here: https://github.com/dotnet/efcore/issues/19986, and i get my "class/model" as a result of this.
3. Then I add my CRUD pages like demonstrated in this video: https://www.youtube.com/watch?v=q2u1VY28Drs And that is ok, since the CRUD pages are created (Exists in solution explorer).

Now when i start the app, and manouver to the new CRUD pages as shown i the last video link, it does not work out of the box, the page does not exist: No webpage was found for the web address: https://localhost:44335/V2/index. I dont understand why, but suspect it has something to do with routing.

Or, what could be the problem here? tnx

Updated 19.10

I create a MCV app, and follow the steps 1&2 above, then i follwo this guide at the "Add model" step: **https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-mvc-app/?view=aspnetcore-3.1 ** and

then add this: using Microsoft.EntityFrameworkCore; in my startup file. I do not add using MvcMovie.Data; And it still do not work, the documentation is lacking to be mild on the database first approach. What do i NEED to do from the step: "Add a Model" in the MVC guide? anyone?