FLUENT APIS EF Core

FLUENT APIS

Either use annotations or use FLUENT APIS to configure database mappings.. Not everything is possible using annotations. So better to use FLUENT APIS.

modelbuilder.specify<entity>.property in the entity and then use intellesense to use required functionality

For Ex; precision of a decimal field cannot be specified using annotations but can be done using FLUENT APIS. Otherwise we need to create a custom data annotation using FLUENT APis and use it in the entity class.

Comments

Azure AD Authentication And Authorization

ROLE BASED AUTHORIZATION Step1: Setup API. 1. Create an app registration and create an app role. Make sure that the app role is assigned to user and applications. We add it to both user groups and applications as this role can be then assigned to both users and applications. Scopes can only be assigned to apps. Now we can have only users with this role access our application. This app role behind the scenes adds an approles section to the manifest.json. We can directly add it to the manifest file also. Step 2: Setup an app registration for the UI/ WEB App. . We will grant this app the read role created in the API app (shown above). Go to Azure AD and select the UI app registration. When we register an application 2 elements get created. 1. App registration 2. Enterprise Application -- service principal that get created for the app Adding roles to applications Go to the App registration => API Persmissions => Add a Permission => My API's The My Api's sec...

EF CORE 6

Enumerating through the results 3. Everytime we enumerate thorugh the DBset inside a foreach loop, the connection to the database remains open. So doing a lot of work inside the loop will result in the database connection to stay open. So, it's better to run a ToList() and get the results in memory before we start iterating through the results. SQL Injection If we hardcode the value for a parameter in the LINQ query then it will be hardcoded in the query as well, so try to use variables. Variables are converted to parameters and hence prevent SQL injection. Partial Filtering We can have more control on the LIKE statement when using the Ef.Functions.Like method var authorsNameEndWith = await context.Authors.Where(a => EF.Functions.Like(a.FirstName, "%a")).ToListAsync(); Find Order By If we have multiple order by statements, then LINQ will ignore all but the last one. So, use the thenBy operator to add more orderby statements. Triggering the query ex...

Function APP and KV integration

Create a function App and enable system assigned identity Create a Keyvault and add a secret (Name in my case) Configure Access policies for the function app in keyvault Create an access policy in Key Vault for the application identity you created earlier. Enable the "Get" secret permission on this policy. Do not configure the "authorized application" or applicationId settings, as this is not compatible with a managed identity. https://docs.microsoft.com/en-us/azure/app-service/app-service-key-vault-references Key Vault references currently only support system-assigned managed identities. User-assigned identities cannot be used. We are granting our function app permissions to get and list all the secrets in this keyvault. Add Key Vault secrets reference in the Function App configuration Go to the keyvault and click on the secret we just created. Copy the secret identifier. We need to add this value to the function app configuration. @Microsof...

Anish's Notebook

Search This Blog