I need to perform a count operation on this Entity Framework (EF6) data set using a relatively complex expression as a WHERE clause and expecting it to return about 100k records.
This is my actual wrapper code :
So I have these 2 entities
I want to list the Categories as in the picture:
I have two webpages, the first has a dropdown that allows the person to select a project & a button. When the button is submitted, it takes them to the manage users webpage and sends the Projectname to the webpage as well. The manage users webpage allows the person to assign a user to the project they selected on the previous webpage. There is a button as well, and when submitted it sends an api call with post values to my controller. The controller accepts a dto and then binds these values to the AssignUserDto. It then finds the entity associated w/ the dto username, and then maps the values from the dto to the entity so that the user has a Projectname associated with it.
I have a project that allows users to create a new project. The UI has some textboxes and a submit button. It sends data through a POST request to an api call, which then creates a new project entity in the database. I deleted my migrations and then added a new migration since I wanted to fix some code, but now the post action no longer works. I see the following error message in the console –
I always try to separate my code as much as possible. I’m fairly new to ASP.NET Core but the code principles and software design patterns are the same in all languages, however, when using entity-framework, there’s something that bothers me, or that I don’t know how to deal with.
Usually I add new database entries with a “Create” form, just like the template you are given like this:
I’m using a free project from GitHub that uses Blazor with EF Identity and SQLite. Its a good starting point for me to learn and add more functionality. Currently, I would like to add authorization to the project to allow specific users to have access to particular pages. My first step is to add default roles and account. I managed to find some sample codes that do that during startup. However, I get the following runtime error.
I do not understand why this works sometimes and sometimes not.