Custom System Routes (Nancy inspired)

gistfile1.cs

            Get("foo/bar.html", 
                (request, response) => {

                    using (var connection = new SqlConnection(
                        System.Configuration.ConfigurationManager.AppSettings["strConnection"]))
                    {
                        connection.Open();

                        var result = connection.Query<ExecutiveReportResult>(
                            Util.getSql("rm_consulta_relatorio_executivo"),
                            new { Anos = new int[] { 2012 }, Meses = new int[] { 1, 2, 3 }, CodigoInterno = "1.1.4" });

                        Render("ExecutiveReport.liquid", result, response);
                    }

            });
        }