using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

​

public class TableConverter

{

    /// <summary>

    /// Converts a space-separated CSV table into C# properties with PascalCase names and correct C# data types.

    /// </summary>

    /// <param name="tableData">The input string containing the table data.</param>

    /// <returns>A formatted string with C# properties.</returns>

    public static string ConvertTableToCSharpProperties(string tableData)

    {

        if (string.IsNullOrEmpty(tableData))

        {

            return string.Empty;

        }

​

        var properties = new StringBuilder();

        var rows = tableData.Split(new[] { '\n' }, StringSplitOptions.RemoveEmptyEntries);

​

        foreach (var row in rows)

        {

            var columns = row.Split(new[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);

​

            if (columns.Length < 2)

            {

                continue; // Skip malformed rows

            }

​

            var variableName = columns[0];

            var mssqlType = columns[1];

​

            try

            {

                var transformedName = TransformVariableName(variableName);

                var csharpType = MapMssqlToCSharpType(mssqlType);

                var propertyName = GeneratePropertyName(transformedName);

                var propertyString = $"public {csharpType} {propertyName} {{ get; set; }}";

                properties.AppendLine(propertyString);

            }

            catch (Exception ex)

            {

                // Handle or log the exception as needed.  For now skip invalid rows.

                Console.WriteLine($"Error processing row: {row}.  Error: {ex.Message}");

            }

        }

​

        return properties.ToString().TrimEnd();

    }

​

​

    private static string TransformVariableName(string variableName)

    {

        // Convert to sentence case (e.g., "firstName" becomes "First name")

        var result = new StringBuilder();

        result.Append(char.ToUpper(variableName[0]));

        for (int i = 1; i < variableName.Length; i++)

        {

            if (char.IsUpper(variableName[i]))

            {

                result.Append(" ");

            }

            result.Append(variableName[i]);

        }

        return result.ToString();

    }

​

    private static string MapMssqlToCSharpType(string mssqlType)

    {

        switch (mssqlType.ToUpper())

        {

            case "INT":

                return "int";

            case "VARCHAR":

                return "string";

            case "DATETIME":

                return "DateTime";

            case "BIT":

                return "bool";

            case "DECIMAL":

                return "decimal";

            default:

                throw new ArgumentException($"Unsupported MSSQL data type: {mssqlType}");

        }

    }

​

    private static string GeneratePropertyName(string transformedName)

    {

        // Convert to PascalCase (e.g., "First name" becomes "FirstName")

        var words = transformedName.Split(' ');

        var propertyName = new StringBuilder();

        foreach (var word in words)

        {

            if (string.IsNullOrEmpty(word)) continue;

​

            if (!char.IsLetter(word[0]))

            {

                throw new ArgumentException($"Invalid character at the beginning of word: {word}");

            }

​

            propertyName.Append(char.ToUpper(word[0]));

            propertyName.Append(word.Substring(1));

        }

​

        if (!char.IsLetter(propertyName[0]))

        {

            throw new ArgumentException($"Property name must start with a letter.");

        }

        return propertyName.ToString();

    }

​

​

    public static void Main(string[] args)

    {

        string tableData = @"employeeId INT  1

employeeName VARCHAR  2

hireDate DATETIME  3

isActive BIT  4

salary DECIMAL  5";

​

        string cSharpProperties = ConvertTableToCSharpProperties(tableData);

        Console.WriteLine(cSharpProperties);

    }

}

​