Knowledge Repo / Experience Log
If you’ve been using Entity Framework Core for a while, you know that sometimes you just need to delete or update a bunch of rows quickly without the overhead of pulling them into memory first. That’s where two newer methods—ExecuteDeleteAsync and ExecuteUpdateAsync—come in handy.
Instead of looping through entities and calling SaveChanges, these methods translate directly into SQL DELETE and UPDATE statements under the hood. That means fewer round trips and better performance.
One of the trickiest challenges in software development is switching between tech stacks. Sometimes you’re working in C#, then suddenly you need to port logic over to Python for a machine learning project, or convert a Node.js snippet into Go for performance testing.
Doing these translations by hand can be tedious, and searching online often leads to mismatched snippets. This is where ChatGPT has become a secret weapon — paste in code from one stack and it can rewrite the logic in another, complete with idiomatic conventions for that language.
Here are a few ways this can work in real-world scenarios.
Continue reading “Convert Code Between Tech Stacks With ChatGPT”As a developer, one of the most common tasks I run into is working with JSON data. Whether it’s coming from an API response, a config file, or a third-party integration, I often need to convert JSON into strongly-typed C# object models. Doing this by hand can be time-consuming, and online converters sometimes generate clunky code.
That’s where ChatGPT has become a game-changer for me. I can paste in a JSON object, and within seconds, I get back a clean C# class structure that I can drop right into my project. From there, I can map or deserialize the JSON data using libraries like System.Text.Json or Newtonsoft.Json.
Let me walk you through a simple example.
Continue reading “Quickly Convert JSON into C# Object Models With ChatGPT”In Entity Framework Core, there is no direct equivalent to the NOLOCK hint in SQL. The NOLOCK hint is used in SQL Server to allow a SELECT statement to read a table without acquiring a shared lock, and it can be used to improve query performance in certain scenarios.
If you’re using Entity Framework Core in C# and you want to retrieve distinct items based on a specific property (e.g., ID) but still return the full object, you can use the GroupBy method along with First or FirstOrDefault. Here’s an example assuming you have a class named YourEntity with a property named Id:
Submitting an AWS Batch job using the AWS SDK for .NET (C#) involves a series of steps, including creating a job definition, specifying the job queue, and submitting the job. Here’s a basic example:
Continue reading “How to submit AWS Batch Job with C#”EventStore is an open-source database technology designed for storing, retrieving, and querying event data using a stream-based approach. In EventStore, a catch-up subscription is used to read events from a given point in a stream and catch up to the most recent events. When starting a catch-up subscription, you can specify the starting position using an event number or position. However, in some cases, you might want to start from the beginning or the very first event. Here’s how you can achieve that:
Continue reading “Subscribe to EventStore catch-up subscription from the start with C# example”Entity Framework (EF) Core allows you to define relationships between entities using Fluent API, even without explicitly creating navigation properties. This can be useful when you want to define relationships between entities but don’t want to create navigation properties in your entity classes. Here’s how you can achieve this:
Continue reading “Entity Framework (EF) Core FluentApi Relationships without Navigation Properties”When using EF Core with PostgreSQL for a case-insensitive “LIKE” search, you can leverage PostgreSQL-specific features to achieve the desired behavior. PostgreSQL supports the ILIKE operator, which performs a case-insensitive pattern matching operation. Here’s an example of how to perform a case-insensitive “LIKE” search using EF Core and PostgreSQL:
In C#, the Partitioner class is part of the System.Collections.Concurrent namespace and is used to partition data into smaller chunks for parallel processing. It provides an easy way to divide work among multiple tasks or threads in a parallel algorithm.
Here’s an example of how to use the Partitioner class: