Here is the example of how to create a generic method to update the different properties of same type of entities. E.g. you have User table with email, phone. And you want to update 10 records email and 5 records phone in a single DB roundtrip. By using the following method, you can do that
Authentication example: Where AzureAdOptions contains the configuration of your Azure AD. MyJwtEventsHandler is the implementation of JwtEventsHandler. e.g. Register authentication: MyAuthorizationMiddlewareResultHandler is the middleware behaviour overrider. Check Microsoft docs for more details. Use on your controller: Cheers and Peace out!!!
Sometimes we need to add claims while user is being signed in using Azure AD B2C identity provider. For that we can use API connectors. First add the API connector. There will be two options for authentication: For this post we will be using Basic authentication So, add your endpoint, username and password and save.
Sometimes we need to override the process of model creation in the DB first approach. Maybe we want to create a base class for some common functionality of all the models. So, what we could do is, use the Design Time Services: Design-time services – EF Core | Microsoft Learn. We could use ‘Custom Reverse
Pre-requisite: Now this is for DB first approach. So, we can’ use the migration scripts to automatically create a DB in docker container and run the scripts. What we could do then? We will be executing the DbUp project’s main method (since it’s a console application) by passing some arguments. E.g. Code to call at
DbUp is a tool which can be used to maintain the DB scripts in the project itself. It’s very easy to use but the docs are very up to date. I will raise the PR for docs update, hope they will accept 🙂 So, what we have: What we want to achieve Steps to follow:
Before this we used to use a filter (GlobalExceptionFilter) to handle exceptions at one place. .Net 8 has a new IExceptionFilter middleware which can be used to filter the exceptions. For more look at: Handle errors in ASP.NET Core | Microsoft Learn The new exception handler keeps information in Features property. So, If you face
Steps are tested on the .Net 8 The steps are: Nuget Packages Needed: Example code: WebApplicationFactory: If Program is not found, then you can create a partial Program class at the end of Program.cs of your main project. Test Case Class Errors: 2. Timeout Error: You may face timeout error. So, you can add wait
In the above command, ‘ConnectionString’ is the string that you use to connect with sql server. ‘Provider’ is the driver (nuget package) that will help you to interact with the sql server. e.g. for MySQL we could use ‘Pomelo.EntityFrameworkCore.MySql’ nuget package, for MSSQL we could use ‘Microsoft.EntityFrameworkCore.SqlServer’
You have to add following line to PropertyGroup in the .csproj file of the start project: Now your project will run successfully.