static void Main(string[] args) { DAL dal = new DAL(); var kvp = new KeyValuePair <string, object>("Rate", "descending order"); //my order by = order by dal.GetData("my order by", kvp); kvp = new KeyValuePair <string, object>("Rate", 50); //my where = where dal.GetData("my where", kvp); dal.Print(); kvp = new KeyValuePair <string, object>("RateChangeDate", 0); //my group by = group by dal.GetData("my group by", kvp); dal.Print(); kvp = new KeyValuePair <string, object>("BusinessEntityID", "BusinessEntityID"); //my left join = left join dal.GetData("my left join", kvp); dal.Print(); kvp = new KeyValuePair <string, object>("BusinessEntityID", "BusinessEntityID"); //my right join = right join dal.GetData("my right join", kvp); dal.Print(); }