using (AdomdConnection conn =
new AdomdConnection("Data Source=tfsDB;Initial Catalog=Tfs_Analysis; MDX Compatibility=1;"))
{
conn.Open();
using (AdomdCommand cmd = new AdomdCommand(" ....... mdxQuery here ....... ", conn))
{
DataSet ds = new DataSet();
ds.EnforceConstraints = false;
ds.Tables.Add();
DataTable dt = ds.Tables[0];
dt.Load(cmd.ExecuteReader());
return dt;
}
} var urlHelper = new UrlHelper(htmlHelper.ViewContext.RequestContext);
var url = urlHelper.Action("Home", "Index"); UrlHelper.GenerateUrl(null, actionName, controllerName,
null, null, null, routeValues, htmlHelper.RouteCollection,
htmlHelper.ViewContext.RequestContext, true);