.NET Frameworks
ASP.NET Web Application
- Create an ASP.NET MVC 5 Web Application with user authentication
- Configure the ASP.NET MVC 5 web application to use an external database for user authentication
- Block comment in ASP.NET MVC Razor file
- Return values to the controller in the model from the ASP.NET MVC view
- Set the environment for an ASP.NET Core MVC web application
- Add jQuery DataTables grid to an ASP.NET Core MVC web application
- Add identity into an ASP.NET Core 2.1 MVC project and maintain full control of the Identity UI
- Read the database connection string and other secrets from environment variables
- Turn off the GDPR cookie notification in a dotnet core MVC web application
Microsoft Entity Framework
- Reverse engineer a database with AspNetCore in Visual Studio
- Enable .NET Core Entity Framework Linq query execution
- Generate SQL script from Entity Framework migration script
- Generate Entity Framework Entity Data Model in Visual Studio 2017
- Connect to a MySQL database from Visual Studio 2017
Troubleshooting
- DbUpdateConcurrencyException: Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded.
- {“error”:”Entity type ‘AspNetUserRoles’ has composite primary key defined with data annotations. To set composite primary key, use fluent API.”}
- The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)
- NotSupportedException: Unable to determine the provider name for provider factory of type ‘MySql.Data.MySqlClient.MySqlClientFactory’. Make sure that the ADO.NET provider is installed or registered in the application config
- No connection string named ‘…’ could be found in the application config file.
- Procedure or function ‘`…_Insert`’ cannot be found in database …
- Error unprotecting the session cookie in an ASP.NET Core MVC application.
- Could not create an instance of type ‘Microsoft.AspNetCore.Http.HttpContext’
- Form value count limit 1024 exceeded