It is possible to write custom query in Azure DevOps for work items using the Work Item Query Language (WIQL) a language close to SQL language
Query in Azure DevOps for work items
Search Results for: sql
Deploy WordPress with Azure DevOps
In this new post, I show you how to deploy WordPress with Azure DevOps using an instance of WordPress app service created in the Azure
Universal PredicateBuilder for Expression
In this new short post, I’ll show you how to create a universal PredicateBuilder for Expression in C# to merge 2 or more expressions with Linq
Create a LogicApp to use CosmosDB
I’m going to explain how to create a LogicApp to use CosmosDB in Azure based on a common scenario. I’ll show other solution in the next posts
Blazor using HttpClient with authentication
Today, we are going to learn how to create a secure connection in Blazor using HttpClient with authentication to gain access to the protected resources on the Web API’s side. Everything is based on IdentityServer. Until now, we secure Blazor WebAssembly With IdentityServer4 and enabled login and logout actions. After successful login, IdentityServer sends us the id_token and the access_token. But we are not using that access_token yet. So, in this article, we are going to change that. But, using the access token with Blazor WebAssembly is not going to be our…
Secure Blazor WebAssembly with IdentityServer4
I’m going to explain how to secure a Blazor WebAssemble application with IdentityServer4. Also, how to secure API calls
Configure CORS in API Management
I will show you how to configure CORS in the API Management Service in Azure and avoid the mistake I did when I configure this service
Adding an API using ASP.NET Core
Adding an API using ASP.NET Core is the subject of this new post related to explain how to implement a project in a clean architecture
Creating the Infrastructure project
We will be on creating the Infrastructure project following clean architecture. We are going to bring in another layer: the infrastructure
Datatables in ASP.NET Core Server-Side
We will learn how to use Datatables in ASP.NET Core with Server-Side Processing with a simple real-world implementation to understand better
Integration with Identity in AdminLTE project
I continue to add more features to the integration of AdminLTE with Identity and IdentityServer in AdminLTE in an ASP.NET Core project
Building Multi-Tenant Applications
This article talks about multi-tenant applications and discusses how multi-tenant applications can be architected and implemented in ASP.NET 5
Create Database From Model Using EFCore
Wouldn’t it be nice if the database gets created automatically on the EF Core model your created? To that end this article discusses just that
Audit with Entity Framework Core
How to implement an efficient audit system with Entity Framework Core? In this post I explain what to do and the source code is on GitHub
Azure Resource naming convention guide
The goal of this post is to offer a simple guide how to generate naming convention for Azure resource, bearing in mind some restrictions from Azure itself. Naming Principals First, I want to give you some generic information about naming in Azure: The naming pattern must support easy application level grouping for show back/charge back billing when required. Constraints: Some resources are constrained by their identifier length, and case sensitivity The convention MUST Describes type of resource in the subscription. Constraints: Some resources must be uniquely named across entire Azure. The establishment…
Application Insights: select and filter
Azure Application Insights has a specific language and syntax for select and filter data different from Structured Query Language (SQL). In this post, I am going to compare Analytics query language to SQL with examples for selection and filtration. First, navigate to analytics page of any Application Insights App by clicking Logs tab in the overview page of the app. Then, analytics tab opens a new editor window that you can type your query in it. Now, in the query editor we are going to write our queries using the…
Microsoft ported Procmon from Linux
Microsoft ported Procmon from Linux for monitoring the system calls, Registry access, and file activity for processes running in the operating system.
Database Connection Resiliency in Entity Framework Core
How to implement database connection resiliency using an inbuilt or custom execution strategy using Entity Framework Core
Transactions with Entity Framework Core
In the last couple of weeks, I was talking about Entity Framework Core for creating a model or call stored procedures. But how to use transactions?
Map base class to derive class
I’m facing a problem when I want to cast a base class to a derive class. A derive class is a class that derives from a base class. In this post I explain my solution to this problem.
C# 9: Partial Method Enhancements for Source Generators
Source Generators in C# 9 will allow compiler-extensions to inspect code and then inject additional source code at compile-time
Entity Framework Core and calling a stored procedure
With Entity Framework Core you are able creating a model from the database and also calling a stored procedure.
Azure support
I use Microsoft Azure technologies for backend services within Xamarin apps or web applications, as they allow the app usage to scale indefinitely and you only pay for what you use. I offer my knowledge to support you with Microsoft Azure technologies. Active Directory (Azure AD): use Azure AD to provide authorisation and security services to Xamarin apps. I also use OAuth providers to provide security services. Mobile App Service: An Azure Mobile App Service allows two-way data synchronisation between a central data store and each device running the Xamarin…
What Bill Gates said about the internet in a Microsoft internal memo 25 years ago today: It’s a ‘tidal wave’
Exactly 25 years ago today, on May 26, 1995, Gates wrote an internal memo to Microsoft’s executive staff and his direct reports to extol the benefits of expanding the company’s internet presence
Creating a Model for an Existing Database
Creating entity & context model automatically in C# for an existing database is called Database-First approach with Entity Framework Core