Shit that annoys me.

gistfile1.cs

public int FetchMediumType(string device)
{
 

    SQLSelect select = new SQLSelect(Connection);
    select.Columns("MediumType");
    select.From("dbo.Links");
    select.Distinct = true;
    select.Where("FromPort", Op.Like, device)
            .Or("ToPort", Op.Like, device);

    return select.ExecuteScalar<int>();

}
public int FetchMediumTypeFromString(string type)
{
    SQLSelect select = new SQLSelect(Connection);
    select.Columns("PK");
    select.From("dbo.MediumType");
    select.Distinct = true;
    select.Where("MediumType", Op.Equal, type);


    return select.ExecuteScalar<int>();
}

A region!? Bleh!

regions, hiding bad code since 2003