60 Second Dev

C# records are a new way of defining reference types that use value equality. They're very helpful when you need an immutable data type, saving you from having to write readonly properties and overriding a bunch of equality methods. For example, here's an immutable class definition with value equality and a nicely formatted string output: public class TeamClass { private readonly string _name ; private readonly int _yearFormed ; public TeamClass ( string name , int yearFormed ) = > ( _name , _yearFormed ) = ( name , yearFormed ) ; public string Name = > _name ; public int YearFormed = > _yearFormed ; public override string ToString ( ) = > $ " TeamClass {{ Name = {Name}, YearFormed = {YearFormed} }} " ; public override bool Equals ( object obj ) { return obj is TeamClass otherTeam && Name = = otherTeam . Name && Year

You can easily format numbers using built-in standard or custom format strings. Depending on your environment, you may want complete control over number formats, or you may want to leave it up to the user's locale. View code on GitHub

Mustache is a really simple templating engine, and a good choice for building HTML. Here's an example using the Stubble package in .NET. View code on GitHub

If you're doing an update, and need information on the records you're updating, you can do it all in a single command. This video gives you an example using a CTE, where you update, and also pull data down from the records that you're updating, all in a single command. View code on GitHub

Most of the time, you can use regular queries to accomplish your needs in a SQL database. There are plenty of interesting design patterns to work with sets of data, but once in awhile, you need the flexibility of a cursor. Here's an example of a straightforward read only cursor. View code on GitHub

The CsvHelper library includes a very easy way to transform .NET objects into properly formatted CSV. To read CSV, check out my previous post . View code on GitHub