// C# Extension Method

// Doc: https://csharp-extension.com/en/method/1002416/int32-sqlsystemtypetosqldbtype

​

// @nuget: Z.ExtensionMethods

​

using System;

public class Program

{

    public static void Main()

    {   

        Int32[] values = { 34, 35, 36, 40, 41, 42, 48, 52, 56 };

        Console.WriteLine("{0,-10}{1,-20}","short", "SqlDbType");

        Console.WriteLine("{0,-10}{1,-20}","-----", "---------");

​

       foreach (Int16 value in values)

        {

            // C# Extension Method: Int32 - SqlSystemTypeToSqlDbType

            Console.WriteLine("{0,-10}{1,-20}", value, value.SqlSystemTypeToSqlDbType());

        }

    }

}