I work as a solution architect and a technical architect, too. I use .NET and ASP.NET specifically for web development. Nowadays, it's not just ASP.NET. We mostly use microservices or service-oriented architecture, so the web development is in Angular or React, and we create APIs like microservices or SOA. Either way, its working depends upon the client. We mostly develop single-page applications, and the backend is Microsoft .NET Core. Now we are migrating to .NET 7.0, and I have mostly been using SQL Server in the backend. I have also been working using Azure DocumentDB for some of the NoSQL.
My client is a medium-sized enterprise.