C# – eat{Code}live

September 8, 2025August 30, 2025

Quickly Convert JSON into C# Object Models 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.

April 15, 2024December 12, 2023

SQL NOLOCK with C# and Entity Framework Core (EFCore)

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.

April 1, 2024November 27, 2023

Get Distinct Object by Id and Return Full Object with C# and EF

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:

March 4, 2024August 17, 2023

How to submit AWS Batch Job with C#

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:

February 5, 2024August 15, 2023

Subscribe to EventStore catch-up subscription from the start with C# example

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:

January 22, 2024August 15, 2023

Entity Framework (EF) Core FluentApi Relationships without Navigation Properties

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:

December 4, 2023August 15, 2023

Case-insensitive “LIKE” search with EF Core and PostgreSQL

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:

November 6, 2023August 15, 2023

Helpful C# – Partitioner

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:

September 18, 2023August 15, 2023

Helpful C# – OfType

In C#, the OfType method is used to filter a collection and retrieve only the elements that are of a specific type or that can be cast to a particular type. It is part of LINQ (Language-Integrated Query) and can be used with collections that implement the IEnumerable interface.

The syntax for using OfType is as follows:

December 23, 2018

Workaround – Google Sign-In without Google+ API with MVC .NET and Owin

A few years back I created a small custom application for a client that utilized their Google logins for authentication. The web application was written with ASP.NET MVC and utilized Katana/Owin pipeline. The common practice to setup that application with Google sign in was to also enable the Google+ API. If you have done this then like me you have received an email recently that explains, as of March 2019 the Google+ API’s will be shut down. I have spent the last few days trying to read through the documentation to understand what needs to be done to fix this, without completely switching up the current login flow, however they don’t seem to make this transition easy for .NET applications. Thankfully I finally found the answer I was looking for, a workaround posted in GitHub comments, to address this exact issue. For those of you who are in the same boat as me have a look at this comment . I have made the changes recommended here and I can verify that my Google Sign-In is now working again without the Google+ API enabled.