' ToString override sb.AppendLine(" Public Overrides Function ToString() As String") sb.AppendLine($" Return $""className: String.Join(", ", properties.Keys.Select(Function(k) $"k=k")) """) sb.AppendLine(" End Function") sb.AppendLine("End Class") Return sb.ToString() End Function

' 2. Generate CSV reader for semi-colon files Dim csvReaderCode As String = CodeForge.GenerateCsvReader("Order", """;""") CodeForge.SaveToFile(csvReaderCode, "C:\Generated\OrderCsvReader.vb")

Public Shared Function GenerateSqlInsertBuilder(tableName As String, columnNames As List(Of String)) As String Dim sb As New StringBuilder() sb.AppendLine("Imports System.Data.SqlClient") sb.AppendLine() sb.AppendLine($"Public Class tableNameSqlBuilder") sb.AppendLine(" Public Shared Function BuildInsertCommand(conn As SqlConnection, parameters As Dictionary(Of String, Object)) As SqlCommand") sb.AppendLine($" Dim columns As String = String.Join(" & "","" & ", columnNames.Select(Function(c) $""""c""""))") sb.AppendLine($" Dim valuesPlaceholders As String = String.Join(" & "","" & ", columnNames.Select(Function(c) $"@""c"))") sb.AppendLine($" Dim sql As String = $""INSERT INTO tableName (columns) VALUES (valuesPlaceholders)""") sb.AppendLine(" Dim cmd As New SqlCommand(sql, conn)") sb.AppendLine(" For Each kvp In parameters") sb.AppendLine(" cmd.Parameters.AddWithValue(kvp.Key, kvp.Value)") sb.AppendLine(" Next") sb.AppendLine(" Return cmd") sb.AppendLine(" End Function") sb.AppendLine("End Class") Return sb.ToString() End Function

Marcus , a junior developer at DataFlow Solutions , was drowning. His boss needed three different CSV parsers, two JSON validators, and a SQL INSERT builder — all by Friday. Writing the same boilerplate ( Try-Catch , Using blocks, List(Of T) loops) over and over was burning his nights.

Public Shared Sub SaveToFile(code As String, outputPath As String) File.WriteAllText(outputPath, code, Encoding.UTF8) Console.WriteLine($"[CodeForge] Generated: outputPath") End Sub End Class Module Module1 Sub Main() ' 1. Generate a data class "Customer" Dim props As New Dictionary(Of String, String)() props.Add("Id", "Integer") props.Add("Name", "String") props.Add("Balance", "Decimal") Dim customerClass As String = CodeForge.GenerateDataClass("Customer", props) CodeForge.SaveToFile(customerClass, "C:\Generated\Customer.vb")

' Fields & Properties For Each kvp In properties Dim propName As String = kvp.Key Dim dataType As String = kvp.Value Dim fieldName As String = "_" & propName.ToLower()

Console.WriteLine("Generation complete. Press any key.") Console.ReadKey() End Sub End Module | Feature | Why It Matters | |--------|----------------| | No external dependencies | Runs on any .NET Framework / .NET Core with VB support. | | Consistent formatting | Produces human-readable, maintainable code. | | Error-aware templates | CSV reader handles missing columns; SQL builder uses parameters (safe). | | Extensible | You can add GenerateValidator , GenerateRepository , etc. | | Self-documenting | Each method clearly names what it builds. | Real-World Extension Idea Marcus later added a JSON schema to VB class converter:

Vb Code Generator -

' ToString override sb.AppendLine(" Public Overrides Function ToString() As String") sb.AppendLine($" Return $""className: String.Join(", ", properties.Keys.Select(Function(k) $"k=k")) """) sb.AppendLine(" End Function") sb.AppendLine("End Class") Return sb.ToString() End Function

' 2. Generate CSV reader for semi-colon files Dim csvReaderCode As String = CodeForge.GenerateCsvReader("Order", """;""") CodeForge.SaveToFile(csvReaderCode, "C:\Generated\OrderCsvReader.vb") vb code generator

Public Shared Function GenerateSqlInsertBuilder(tableName As String, columnNames As List(Of String)) As String Dim sb As New StringBuilder() sb.AppendLine("Imports System.Data.SqlClient") sb.AppendLine() sb.AppendLine($"Public Class tableNameSqlBuilder") sb.AppendLine(" Public Shared Function BuildInsertCommand(conn As SqlConnection, parameters As Dictionary(Of String, Object)) As SqlCommand") sb.AppendLine($" Dim columns As String = String.Join(" & "","" & ", columnNames.Select(Function(c) $""""c""""))") sb.AppendLine($" Dim valuesPlaceholders As String = String.Join(" & "","" & ", columnNames.Select(Function(c) $"@""c"))") sb.AppendLine($" Dim sql As String = $""INSERT INTO tableName (columns) VALUES (valuesPlaceholders)""") sb.AppendLine(" Dim cmd As New SqlCommand(sql, conn)") sb.AppendLine(" For Each kvp In parameters") sb.AppendLine(" cmd.Parameters.AddWithValue(kvp.Key, kvp.Value)") sb.AppendLine(" Next") sb.AppendLine(" Return cmd") sb.AppendLine(" End Function") sb.AppendLine("End Class") Return sb.ToString() End Function ' ToString override sb

Marcus , a junior developer at DataFlow Solutions , was drowning. His boss needed three different CSV parsers, two JSON validators, and a SQL INSERT builder — all by Friday. Writing the same boilerplate ( Try-Catch , Using blocks, List(Of T) loops) over and over was burning his nights. Writing the same boilerplate ( Try-Catch , Using

Public Shared Sub SaveToFile(code As String, outputPath As String) File.WriteAllText(outputPath, code, Encoding.UTF8) Console.WriteLine($"[CodeForge] Generated: outputPath") End Sub End Class Module Module1 Sub Main() ' 1. Generate a data class "Customer" Dim props As New Dictionary(Of String, String)() props.Add("Id", "Integer") props.Add("Name", "String") props.Add("Balance", "Decimal") Dim customerClass As String = CodeForge.GenerateDataClass("Customer", props) CodeForge.SaveToFile(customerClass, "C:\Generated\Customer.vb")

' Fields & Properties For Each kvp In properties Dim propName As String = kvp.Key Dim dataType As String = kvp.Value Dim fieldName As String = "_" & propName.ToLower()

Console.WriteLine("Generation complete. Press any key.") Console.ReadKey() End Sub End Module | Feature | Why It Matters | |--------|----------------| | No external dependencies | Runs on any .NET Framework / .NET Core with VB support. | | Consistent formatting | Produces human-readable, maintainable code. | | Error-aware templates | CSV reader handles missing columns; SQL builder uses parameters (safe). | | Extensible | You can add GenerateValidator , GenerateRepository , etc. | | Self-documenting | Each method clearly names what it builds. | Real-World Extension Idea Marcus later added a JSON schema to VB class converter: