using System;

using System.Data.SqlClient;

using System.Linq;

using System.Collections.Generic;

using System.Data;

using System.Text;

public class Program

{    

    public static void Main()

    {

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))

        {   

            var sql = "select top 1 * from OrderDetails";

            Console.WriteLine(connection.DumpClass(sql));

        }

    }

}

​

public static class LINQPadExtensions

{

    private static readonly Dictionary<Type, string> TypeAliases = new Dictionary<Type, string> {

        { typeof(int), "int" },

        { typeof(short), "short" },

        { typeof(byte), "byte" },

        { typeof(byte[]), "byte[]" },

        { typeof(long), "long" },

        { typeof(double), "double" },

        { typeof(decimal), "decimal" },

        { typeof(float), "float" },

        { typeof(bool), "bool" },

        { typeof(string), "string" }

    };

​

    private static readonly HashSet<Type> NullableTypes = new HashSet<Type> {

        typeof(int),

        typeof(short),

        typeof(long),

        typeof(double),

        typeof(decimal),

        typeof(float),

        typeof(bool),

        typeof(DateTime)

    };

​

    public static string DumpClass(this IDbConnection connection, string sql,string className = null)

    {

        if (connection.State != ConnectionState.Open)

            connection.Open();

​

        var cmd = connection.CreateCommand();

        cmd.CommandText = sql;

        var reader = cmd.ExecuteReader(CommandBehavior.KeyInfo | CommandBehavior.SingleRow );

​

        var builder = new StringBuilder();

        do

        {

            if (reader.FieldCount <= 1) continue;

​

            var schema = reader.GetSchemaTable();

            foreach (DataRow row in schema.Rows)

            {

                if (string.IsNullOrWhiteSpace(builder.ToString()))

                {

                    var tableName = string.IsNullOrWhiteSpace(className)?row["BaseTableName"] as string??"Info":className;

                    builder.AppendFormat("public class {0}{1}", tableName, Environment.NewLine);

                    builder.AppendLine("{");

                }

                var type = (Type)row["DataType"];

                var name = TypeAliases.ContainsKey(type) ? TypeAliases[type] : type.Name;

                var isNullable = (bool)row["AllowDBNull"] && NullableTypes.Contains(type);

                var collumnName = (string)row["ColumnName"];

​

                builder.AppendLine(string.Format("\tpublic {0}{1} {2} {{ get; set; }}", name, isNullable ? "?" : string.Empty, collumnName));

                builder.AppendLine();

            }

​

            builder.AppendLine("}");

            builder.AppendLine();

        } while (reader.NextResult());

​

        return builder.ToString();

    }

}