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

Generate Table script using class in c#

CodeWhizFaisal answered on May 9, 2023 Popularity 3/10 Helpfulness 1/10

answer Generate Table script using class in c#

Generate Table script using class in c#

Comment

public string GenerateCreateTableSql<T>()
{
    Type type = typeof(T);
    string tableName = type.Name;

    var properties = type.GetProperties();

    var columnDefs = properties.Select(p => $"{p.Name} {GetDbType(p.PropertyType)}");

    string sql = $"CREATE TABLE {tableName} ({string.Join(",", columnDefs)})";

    return sql;
}

private string GetDbType(Type type)
{
    if (type == typeof(int))
        return "INT";
    else if (type == typeof(string))
        return "NVARCHAR(MAX)";
    // Add other data types as needed...

    throw new NotSupportedException($"Type {type.FullName} is not supported.");
}

Popularity 3/10 Helpfulness 1/10 Language csharp

Source: chat.openai.com

Tags: c# generate script

Link to this answer
Share Copy Link

Contributed on May 09 2023

CodeWhizFaisal

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Generate Table script using class in c#

Contents

More Related Answers

Generate Table script using class in c#

Grepper

Documentation

Social

Legal

Contact

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