C#

// Get back all Data Types that match the generic type
public List<DataType<T>> GetTypes(T typeToGet)
{
    return DataTypes.Where(x => x.ConvestionType == typeToGet).ToList();
}

public abstract class DotNetlTypeConverterBase<T>
{
    private List<DataType<T>> _dataTypes;
    public List<DataType<T>> DataTypes
    {
        get { return _dataTypes; }
        private set { _dataTypes = value; }
    }

    public DotNetlTypeConverterBase()
    {
        DataTypes = new List<DataType<T>>();
        Load();
    }

    protected abstract void Load();

    public class DataType<T>
    {
        public DotNetTypes DotNetType { get; private set; }
        public T ConvestionType { get; private set; }

        public DataType(DotNetTypes dotNetType, T convestionType)
        {
            DotNetType = dotNetType;
            ConvestionType = convestionType;
        }
    }
}

public class DotNetToSqlTypeConverter<SqlDbType> : DotNetlTypeConverterBase<SqlDbType>
{
    protected override void Load()
    {
        DataTypes.Add(new DataType<SqlDbType>(DotNetTypes.Short, SqlDbType.SmallInt));
        DataTypes.Add(new DataType<SqlDbType>(DotNetTypes.Double, SqlDbType.Double));
    }
}

public class DataType
{
    public DotNetTypes? DotNetType { get; private set; }
    public SqlDbType? SqlDbType { get; private set; }
    public OleDbType? OleDbType { get; private set; }

    public DataType(DotNetTypes? dotNetType, SqlDbType? sqlDbType, OleDbType? oleDbType)
    {
        DotNetType = dotNetType;
        SqlDbType = sqlDbType;
        OleDbType = oleDbType;
    }
}

private static List<DataType> DataTypes;

static DataTypeConversion()
{
    Load();
}

private static void Load()
{
    DataTypes = new List<DataType>
    {
        new DataType(DotNetTypes.Short, SqlDbType.SmallInt, null),
        new DataType(DotNetTypes.Int32, SqlDbType.Int, null),
        new DataType(DotNetTypes.Int64, SqlDbType.BigInt, null),
        new DataType(DotNetTypes.Boolean, SqlDbType.Bit, null),
        new DataType(DotNetTypes.Double, SqlDbType.Float, null),
        new DataType(DotNetTypes.Float, SqlDbType.Real, null),
        new DataType(DotNetTypes.Guid, SqlDbType.UniqueIdentifier, null),
        new DataType(DotNetTypes.Byte, SqlDbType.TinyInt, null),
        new DataType(DotNetTypes.DataTable, SqlDbType.Structured, null),

        new DataType(DotNetTypes.DateTime, SqlDbType.DateTime, null),
        new DataType(DotNetTypes.DateTime, SqlDbType.SmallDateTime, null),
        new DataType(DotNetTypes.DateTime, SqlDbType.Date, null),
        new DataType(DotNetTypes.DateTime, SqlDbType.Time, null),
        new DataType(DotNetTypes.DateTime, SqlDbType.DateTime2, null),

        new DataType(DotNetTypes.DateTimeOffset, SqlDbType.DateTimeOffset, null),

        new DataType(DotNetTypes.Object, SqlDbType.Variant, null),
        new DataType(DotNetTypes.Object, SqlDbType.Udt, null),

        new DataType(DotNetTypes.Decimal, SqlDbType.Decimal, null),
        new DataType(DotNetTypes.Decimal, SqlDbType.Money, null),
        new DataType(DotNetTypes.Decimal, SqlDbType.SmallMoney, null),

        new DataType(DotNetTypes.Byte, SqlDbType.Binary, null),
        new DataType(DotNetTypes.Byte, SqlDbType.Image, null),
        new DataType(DotNetTypes.Byte, SqlDbType.VarBinary, null),
        new DataType(DotNetTypes.Byte, SqlDbType.Timestamp, null),

        new DataType(DotNetTypes.String, SqlDbType.NVarChar, null),
        new DataType(DotNetTypes.String, SqlDbType.VarChar, null),
        new DataType(DotNetTypes.String, SqlDbType.Char, null),
        new DataType(DotNetTypes.String, SqlDbType.NChar, null),
        new DataType(DotNetTypes.String, SqlDbType.NText, null),
        new DataType(DotNetTypes.String, SqlDbType.Text, null),
        new DataType(DotNetTypes.String, SqlDbType.Xml, null)
    };
}

public enum DotNetTypes
{
    @Unknown,
    @Short,
    @Boolean,
    @Byte,
    @Char,
    @DateTime,
    @DateTimeOffset,
    @Decimal,
    @Double,
    @Int32,
    @Int16,
    @Int64,
    @Float,
    @Object,
    @SByte,
    @Single,
    @String,
    @UInt16,
    @UInt32,
    @UInt64,
    @Guid,
    @DataTable
}

new DataType(DotNetTypes.Byte, SqlDbType.Binary, null),
new DataType(DotNetTypes.Byte, SqlDbType.Image, null),
new DataType(DotNetTypes.Byte, SqlDbType.VarBinary, null),
new DataType(DotNetTypes.Byte, SqlDbType.Timestamp, null),

// Using "WCF REST Starter Kit" (http://msdn.microsoft.com/en-us/netframework/cc950529.aspx)
using (var client = new HttpClient("http://rt.site.com/REST/1.0/"))
{
   client.TransportSettings.Cookies = new CookieContainer();

   var form = new HttpUrlEncodedForm();
   form.Add("user", "LOGIN");
   form.Add("pass", "PASSWORD");

   client.Post(string.Empty, form.CreateHttpContent());

   // 1. Get ticket data
   using (var request = client.Get("ticket/1234/show"))
   {
      string content = request.Content.ReadAsString();
      // Some logic
   }

   // 2. Post ticket reply with attachment
   var formPost = new HttpMultipartMimeForm();
   byte[] attachment = new byte[];
   string content = string.Empty;
         
   // Store data in attachment
   // Store data in content string ("Field: Value" line by line)
   // ...
         
   formPost.Add("content", content);
   formPost.Add("attachment_1", "attachment_1", HttpContent.Create(attachment, "application/octet-stream"));
                             
   using (var post = client.Post("ticket/1234/comment"), formPost.CreateHttpContent()))
      // Some logic
}

var credentials = new NetworkCredential(name, pass);
CookieContainer CookieContainer = new CookieContainer();
var handler = new HttpClientHandler {CookieContainer = CookieContainer,  Credentials = credentials };
using (var client = new HttpClient(handler))
{

    client.BaseAddress = new Uri("https://something.net");

    var form = new List<KeyValuePair<string, string>>();
    form.Add(new KeyValuePair<string, string>("user", name));
    form.Add(new KeyValuePair<string, string>("pass", pass));

    var request = new HttpRequestMessage(HttpMethod.Post, "/rt/REST/1.0");

    request.Content = new FormUrlEncodedContent(form);

    var response = await client.SendAsync(request);

    var contents = await response.Content.ReadAsStringAsync();