Breaking News: Grepper is joining You.com. Read the official announcement!

convert sql table to c# class

YOU.com answered on September 12, 2023 Popularity 7/10 Helpfulness 1/10

answer convert sql table to c# class

related convert sql table to c# class

convert sql table to c# class

Comment

using System;
using System.Data;
using System.Data.SqlClient;

public class SqlToCSharpConverter
{
    public static string ConvertSqlTableToCSharpClass(string tableName)
    {
        // The SQL connection string
        string connectionString = "Your_Connection_String";

        // Create the SQL connection
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            // Open the connection
            connection.Open();

            // Retrieve the table schema
            DataTable schemaTable = connection.GetSchema("Columns", new[] { null, null, tableName });

            // Create the class definition
            string classDefinition = $"public class {tableName}" + Environment.NewLine;
            
            classDefinition += "{" + Environment.NewLine;

            // Retrieve column names and types
            foreach (DataRow row in schemaTable.Rows)
            {
                string columnName = row["COLUMN_NAME"].ToString();
                string dataType = row["DATA_TYPE"].ToString();

                // Map SQL data types to C# data types
                string csharpDataType = MapSqlDataTypeToCSharp(dataType);

                // Append field declarations
                classDefinition += $"\tpublic {csharpDataType} {columnName} {{ get; set; }}" + Environment.NewLine;
            }

            classDefinition += "}";

            return classDefinition;
        }
    }

    private static string MapSqlDataTypeToCSharp(string dataType)
    {
        // Modify the type mappings as per your requirements
        switch (dataType.ToLower())
        {
            case "bigint":
                return "long";
            case "binary":
            case "image":
            case "timestamp":
            case "varbinary":
                return "byte[]";
            case "bit":
                return "bool";
            case "char":
            case "nchar":
            case "ntext":
            case "nvarchar":
            case "sysname":
            case "text":
            case "varchar":
                return "string";
            case "date":
            case "datetime":
            case "datetime2":
            case "smalldatetime":
                return "DateTime";
            case "datetimeoffset":
                return "DateTimeOffset";
            case "decimal":
            case "money":
            case "numeric":
            case "smallmoney":
                return "decimal";
            case "float":
                return "double";
            case "int":
                return "int";
            case "real":
                return "float";
            case "smallint":
                return "short";
            case "time":
                return "TimeSpan";
            case "tinyint":
                return "byte";
            case "uniqueidentifier":
                return "Guid";
            default:
                return "object";
        }
    }
}

Popularity 7/10 Helpfulness 1/10 Language csharp

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Closely Related Answers

convert sql table to c# class

Comment

to convert sql table to c# class
there are mulitple ways to do it here is two ways

1. you can use the Scaffold-DbContext (Entity Framework Core) 
Scaffold-DbContext "Your-Connection-String" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
by providing you connection string here you can generate the classes from the db you want

2. you can use any online converter where you provide the create table script and the online tool will convert it to C# class
eg:- https://codverter.com/src/sqltoclass

Popularity 6/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: c# sql class

Link to this answer
Share Copy Link

Contributed on Apr 14 2024

omar nidal

0 Answers Avg Quality 2/10

convert sql table to c# class

Contents

More Related Answers

convert sql table to c# class

Closely Related Answers

convert sql table to c# class

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.