Creating C# Enums from a SQL Database using T4 Text Templates

Creating C# Enums from a SQL Database using T4 Text Templates

Creating C# Enums from a SQL Database using T4 Text Templates. Let's use T4 Text Templates to generate C# enums from SQL tables. Example code included!

There are more than a hundred of these tables in our SQL database, each with their own type codes, names, and descriptions, but generally following the same structure in terms of column names. These values, according to our users, hardly ever change (on the order of one change a year) but they want to keep the ability to change them if necessary.

All of which lead me and my team to this conclusion: the values are not table rows, they are enumerations, and we should treat them as such.

csharp

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

CSharp Fibonacci Series - Write A Fibonacci Program

In this Video you will learn how to write a CSharp Fibonacci Series Programm. Learn how to use the Fibonacci Sequence in C#. Write a little C# Program to get Fibonacci Numbers. This Fibonacci Series is seen in Nature quite often.

CSharp Interview 50 Question and Answers

This video is a compilation of my 5 successful videos - 50 C# Interview Questions and Answers and should be seen as interview preparation.

Introducing C# 9: Improved pattern matching

Pattern matching has been introduced in C# 6 and has well evolved since. The latest improvement was pretty interesting on C# 8 which has been released last year. If you missed pattern matching improvements on C# 8 , here is a nice article from Miguel Bernard (@MiguelBernard88): https://blog.miguelbernard.com/pattern-matching-in-csharp/. If you have missed all new features in C# 8, you can read also his great serie here: https://blog.miguelbernard.com/csharp-8-0-new-features/. In this article I will show you all the great new features of pattern matching.

Introducing C# 9: Records

C# 9 Introduces a new keyword: record keyword. record keyword makes an object immutable and behave like a value type. data keyword replaces the init keyword for each property if you want the whole object (all properties) to be immutable.

Introducing C# 9: Init only properties

.NET 5 brings a new version of the C# language: C# 9. In this article we will discuss on a new feature: Init only properties. C# 9 Introduces init accessor (variant of set accessor) that allows properties to be assigned once during object initialization.