Resolving Color Inconsistencies and Accessibility Issues with Razor Components in .NET 6 Project

I'm conducting research to solve an issue in my .NET 6 project. I'm experiencing some inconsistencies and color problems in Visual Studio regarding a razor library I've added to my main project. Speci...

12 May at 04:32

Use @ literal in SQL command text

I want to change a password for a user in MySQL which requires `@` symbol. However, C# SQL command uses that as a parameter holder and because of that the following command fails. How does one escape ...

12 May at 04:33

Can C# help me write an immutable class that uses "With" member functions that return modified objects?

I have an immutable class defined with around six properties. This is a simplified version: This allows me to write code such as: and extension functions allow me to write more useful "With" functio...

12 May at 04:33

What regex pattern can I use to work with ISBNs?

I require a pattern that will search for the correct ISBNs in the file. Only the pattern itself needs to be implemented using regular expressions My code so far:

12 May at 04:35

How can I detect if a column is hidden in Google Sheets?

I have a sheet where certain data is hidden and I need to ensure that I don't show that data if it's hidden (which columns are hidden will change frequently). How can I detect which columns are hidden...

12 May at 04:36

Using PowerShell to modify package versions in C# Project files

I'd like to use PowerShell to modify the versions of some of our packages. Using this script it works if I just pass in the version number, *but there may be other packages with the same version that ...

12 May at 04:37

C# - Deserialize DateTime & DateTimeOffset values to UTC and Local Time as required

I'm currently working on a full stack application that has never had to be conscious of time zone, but looks like it will soon need to be a bit more versatile in terms of being aware of local time zon...

convert the current UTC time to micro seconds format in C#

How to represent current UTC date time in the following format yyyy-MM-ddThh:mm:ss.sssZ I tried this: o/p : 2024-05-10T01:56:36:36Z But the problem is I am getting the seconds restricted to two digits...

12 May at 04:39

Recursively include with EF Core 8?

I'm using EF Core 8. I have a catalog system. It contains pages. Pages can have other pages as well as items. I need to load child pages recursively. I have this But it only loads one level deep. This...

12 May at 04:40

Handling Errors When Invoking PowerShell Script from C#?

I am trying to invoke a powershell script that makes use of tokens. I see I receive this specific error message. Is just checking this specific message fine and add me recreating the tokens logic? If ...

Pass templated base class generic child to function without restricting by the template type

I have the following problem. I want to create a baseclass with variable type property that is used internally by the base class and classes that inherit from it as follows: The problem arises when I ...

12 May at 04:42

Insert DateTime to PostgreSQL with C#

Below is my code: [![enter image description here](https://i.sstatic.net/95uh8FKN.png)](https://i.sstatic.net/95uh8FKN.png) Why would the `DateTime.UtcNow` be modified after inserting it into Postgre,...

12 May at 04:43

lock accessing to a property in C# using methods

I have the following class: So when a thread wants to read the "State" it should be thread-safe however, there is also a possibility to lock that using a public methods an unlock it with another metho...

12 May at 04:44

How to configure cascade deletion in Entity Framework Core 8

I'm wondering if there's a way to configure cascade deletion for the following ### Scenario When I delete a `File` entity (database row), I want all associated entities to be deleted as well. Currentl...

How to "fire and forget" an activity in a ASP.NET core which requires Graph API access?

I have an ASP.NET Core 8 Web Application, which uses Entra ID OpenID connect authentication, then uses `graphclient` to access the OnlineMeeting API. All is working. The web application creates an onl...

How to determine how many character will fit in a label?

I have a label and I want to determine how many characters will fit in the label so I can modify the content before assigning, how can I do this, from the above link I tried: **intWidth** is returned ...

12 May at 04:49

What needs to be passed for IEnumerable<KeyValuePair<string, IEnumerable<string>>>?

How can I pass a method a `IEnumerable>>` A method I'm working with expects this as a parameter, but I can't for the life of me figure out what that should be. I've tried `Dictionary>` and Visual Stud...

12 May at 04:49

EntityFramework .net 6 getting object that are in provided list

I have list of objects used as filter: I have a repository and I want to query like: But it doesnt work, it complains that it cant be converted to sql query, probably because Contains uses complex obj...

12 May at 04:51

How to check which auth scheme was used for current request

I need to implement different logic depending on which auth scheme was used to authenticate the users. Currently i'm using `IAuthenticateResultFeature` feature on the HttpContext, but i'm having a rea...

12 May at 04:52

AddKeyedScoped initializing object with func<IServiceProvider, object?, TService> implementationFactory not working? .NET 8

I have started using `AddKeyedScoped` with .NET 8. I want use my own initialization object for dependency: Has anyone used above implementation for setting key with initialization? For scope this work...

12 May at 04:52

How to create a custom model binder attribute

I am not sure if this is even possible but I have a model as follows: I am trying to get the Uploader object to fill after model binds. I use this object quite often in many models and depends on acce...

12 May at 04:54

How To Support Range Requests In ServiceStack For application/json

The ServiceStack docs say that "HTTP Partial Content Support is added in true ServiceStack-style where it's now automatically and transparently enabled for any existing services returning" and then it...

29 Aug at 10:47

Disable BasicAuth fallback

According to the documentation: https://docs.servicestack.net/auth/authentication-and-authorization#authenticating-with.net-service-clients > Although behind-the-scenes it ends up making 2 requests, 1...

29 Aug at 10:49

Is there a way to limit DTOs returned back from /types/typescript?

We have an api which serves 2 SPA sites and we use the models from /types/typescript in both. One of the sites only uses one services worth of DTOs but it has to use the generated file with all DTOs, ...

29 Aug at 10:50

How can we use MySql Select Case construct in ORMLite ServiceStack

SqlExpression sqlExp = db.From() .Where(l => l.e01f02 == EmployeeId && l.e01f07 == LeaveStatus.Approved) .Where($"(e01f04 >= '{MonthFirstDate}' AND e01f04 = '{MonthFirstDate}' AND ADDDATE(e01f04, ...