ProductController.cs<\/strong> file.\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Web;\r\n\r\n\r\nnamespace FCDemoWithSqlServerUsing_AspWrapper\r\n{\r\n \/\/controller class for quaring fetched data\r\n public class ProductController\r\n {\r\n \/\/funcion for getting all months\r\n public List getMonth()\r\n {\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n\r\n var month = from product in data.quarterwiseProductDatas\r\n select product.Month;\r\n return month.ToList();\r\n }\r\n\r\n }\r\n \/\/for all quarters\r\n public List getQuarter()\r\n {\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n var quarter = from product in data.quarterwiseProductDatas\r\n select product.quarter;\r\n return quarter.ToList();\r\n }\r\n\r\n }\r\n \/\/Fetching all values\r\n public List getValues()\r\n {\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n var values = from product in data.quarterwiseProductDatas\r\n select product.Value;\r\n return values.ToList();\r\n }\r\n }\r\n \/\/Fetching series\r\n public List getSeries()\r\n {\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n var series = from product in data.quarterwiseProductDatas\r\n select product.series;\r\n return series.ToList();\r\n }\r\n }\r\n \/\/Fetching Monthwise values\r\n public List getMonthwiseValue(string series, string quarter)\r\n {\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n\r\n\r\n var monthValue = from product in data.quarterwiseProductDatas\r\n where product.quarter == quarter & product.series == series\r\n select product.Value;\r\n\r\n\r\n\r\n\r\n\r\n return monthValue.ToList();\r\n }\r\n }\r\n \/\/Fetching quarter wise values\r\n public List quarterWiseMonth(string quarter)\r\n {\r\n\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n var monthVal = from product in data.quarterwiseProductDatas\r\n where product.quarter == quarter\r\n orderby product.Month descending\r\n select product.Month;\r\n return monthVal.ToList();\r\n }\r\n\r\n }\r\n }\r\n}\r\n\r\n<\/pre>\r\nStep 10<\/strong>\r\nAdd the code given below to the SeriesLinkController.cs<\/strong> file. Along with the code added in the ProductController.cs<\/strong> file, this code will add custom controllers where LINQ has been implemented for querying the data fetched from the database using Entity Framework.\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Web;\r\n\r\n\r\nnamespace FCDemoWithSqlServerUsing_AspWrapper\r\n{\r\n public class Series\r\n {\r\n public int value;\r\n public string link;\r\n public Series(int value,string link)\r\n {\r\n this.value = value;\r\n this.link = link;\r\n }\r\n }\r\n \/\/controller for handling all series information\r\n public class SeriesLinkContoller\r\n {\r\n \/\/fetching all series\r\n public List getSeries()\r\n {\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n\r\n var series = from product in data.Series_wise_Product\r\n select product.seriesName;\r\n return series.ToList();\r\n }\r\n }\r\n \/\/fetching series wise data\r\n public List getSeriesWiseData(string series)\r\n {\r\n List valueLink = new List();\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n var seriesLink = from product in data.Series_wise_Product\r\n where product.seriesName == series\r\n select new { linkdata = product.link, valuedata = product.SeriesValue };\r\n\r\n foreach(var obj in seriesLink)\r\n {\r\n valueLink.Add(new Series(obj.valuedata, obj.linkdata));\r\n }\r\n }\r\n return valueLink;\r\n }\r\n \/\/Fetching series values\r\n public List getSeriesValue()\r\n {\r\n List values = new List();\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n\r\n var seriesValue = from product in data.Series_wise_Product\r\n select product.SeriesValue;\r\n foreach(var val in seriesValue)\r\n {\r\n values.Add(val);\r\n }\r\n }\r\n return values;\r\n }\r\n public List getLink()\r\n {\r\n using (ProductEntities data = new ProductEntities())\r\n {\r\n\r\n var linkValue = from product in data.Series_wise_Product\r\n select product.link;\r\n return linkValue.ToList();\r\n\r\n }\r\n\r\n }\r\n }\r\n}\r\n\r\n<\/pre>\r\nStep 11<\/strong>\r\nCreate a new folder within the project hierarchy and name it scripts<\/strong>. Paste all FusionCharts JavaScript files in the scripts<\/strong> folder.\r\n![\"\"](\"https:\/\/www.fusioncharts.com\/blog\/wp-content\/uploads\/gallery\/blog\/2017\/07\/Task-3-Step-11_Scripts-Folder-1.png\")
\r\n\r\nStep 12<\/strong>\r\nCreate a new web form and name it Default.aspx<\/strong>. In the Default.aspx<\/strong> file, paste the code given below.\r\n<html xmlns=\"https:\/\/www.w3.org\/1999\/xhtml\">\r\n<head runat=\"server\">\r\n <script src=\"scripts\/fusioncharts.js\"><\/script>\r\n <script src=\"scripts\/fusioncharts.js\"><\/script>\r\n <script src=\"scripts\/fusioncharts.theme.fint.js\"><\/script>\r\n <title>Multi series column 2d drilldown demo<\/title>\r\n<\/head>\r\n<body>\r\n <form id=\"form1\" runat=\"server\">\r\n <div>\r\n <asp:Literal ID=\"l1\" runat=\"server\">\r\n Chart will load here\r\n <\/asp:Literal>\r\n <\/div>\r\n <\/form>\r\n<\/body>\r\n<\/html>\r\n\t\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Web;\r\nusing System.Web.UI;\r\nusing System.Web.UI.WebControls;\r\nusing System.Text;\r\nusing FusionCharts.Charts;\r\nusing System.Web.Script.Serialization;\r\n\r\nnamespace FCDemoWithSqlServerUsing_AspWrapper\r\n{\r\n public partial class Default : System.Web.UI.Page\r\n {\r\n protected void Page_Load(object sender, EventArgs e)\r\n {\r\n\r\n \/\/Declaringcollections to retain data fetched through controllers\r\n \r\n ProductController cont = new ProductController();\r\n SeriesLinkContoller linkcont = new SeriesLinkContoller();\r\n List ProductMonth = cont.getMonth();\r\n List ProductQuarter = cont.getQuarter();\r\n List ProductValue = cont.getValues();\r\n List ProductSeries = cont.getSeries();\r\n List SeriesNames = linkcont.getSeries();\r\n List LinkValue = linkcont.getLink();\r\n List SeriesValue = linkcont.getSeriesValue();\r\n\r\n \/\/Building JSON String\r\n StringBuilder JSON = new StringBuilder();\r\n \/\/appending all cosmatic properties\r\n JSON.Append(\"{\" +\r\n \"'chart': {\" +\r\n \"'caption': 'Comparison of two products on the basis of Quarterly Revenue',\" +\r\n \"'xAxisname': 'Quarter',\" +\r\n \"'yAxisName': 'Revenues (In USD)',\" +\r\n \"'numberPrefix': '$',\" +\r\n \"'plotFillAlpha': '80',\" +\r\n \"'paletteColors': '#0075c2,#1aaf5d',\" +\r\n \"'baseFontColor': '#333333',\" +\r\n \"'baseFont': 'Helvetica Neue,Arial',\" +\r\n \"'captionFontSize': '14',\" +\r\n \"'subcaptionFontSize': '14',\" +\r\n \"'subcaptionFontBold': '0',\" +\r\n \"'showBorder': '0',\" +\r\n \"'bgColor': '#ffffff',\" +\r\n \"'showShadow': '0',\" +\r\n \"'canvasBgColor': '#ffffff',\" +\r\n \"'canvasBorderAlpha': '0',\" +\r\n \"'divlineAlpha': '100',\" +\r\n \"'divlineColor': '#999999',\" +\r\n \"'divlineThickness': '1',\" +\r\n \"'divLineIsDashed': '1',\" +\r\n \"'divLineDashLen': '1',\" +\r\n \"'divLineGapLen': '1',\" +\r\n \"'usePlotGradientColor':'0',\" +\r\n \"'showplotborder': '0',\" +\r\n \"'valueFontColor': '#ffffff',\" +\r\n \"'placeValuesInside': '1',\" +\r\n \"'showHoverEffect': '1',\" +\r\n \"'rotateValues': '1',\" +\r\n \"'showXAxisLine': '1',\" +\r\n \"'xAxisLineThickness': '1',\" +\r\n \"'xAxisLineColor': '#999999',\" +\r\n \"'showAlternateHGridColor': '0',\" +\r\n \"'legendBgAlpha': '0',\" +\r\n \"'legendBorderAlpha': '0',\" +\r\n \"'legendShadow': '0',\" +\r\n \"'legendItemFontSize': '10',\" +\r\n \"'legendItemFontColor': '#666666'\" +\r\n \" },\"\r\n );\r\n \/\/appenfing into StringBuilder objectiterating through collections\r\n JSON.Append(\"'categories': [{\" +\r\n\r\n \"'category': [ \");\r\n foreach (var quar in ProductQuarter.Distinct())\r\n {\r\n \/\/for last element escaping comma\r\n if (quar == ProductQuarter.Distinct().Last())\r\n {\r\n JSON.Append(\"{ 'label': '\" + quar + \"' }\");\r\n break;\r\n\r\n }\r\n JSON.Append(\"{ 'label': '\" + quar + \"' },\");\r\n\r\n }\r\n JSON.Append(\"]\" +\r\n \"}],\" +\r\n \"'dataset': [\");\r\n foreach (var prod in SeriesNames.Distinct())\r\n {\r\n List seriesWiseValue = linkcont.getSeriesWiseData(prod);\r\n JSON.Append(\"{\" +\r\n \"'seriesname':\" + \"'\" + prod + \"',\" + \"'data': [\");\r\n foreach (var linkValue in seriesWiseValue)\r\n {\r\n if (linkValue == seriesWiseValue.Last())\r\n {\r\n JSON.Append(\"{\" +\r\n\r\n \"'value':\" + \"'\" + linkValue.value + \"','link':\" + \"'\" + linkValue.link + \"'}\");\r\n break;\r\n }\r\n\r\n JSON.Append(\"{\" +\r\n\r\n \"'value':\" + \"'\" + linkValue.value + \"','link':\" + \"'\" + linkValue.link + \"'},\");\r\n }\r\n if (prod == SeriesNames.Distinct().Last())\r\n {\r\n JSON.Append(\"]\" +\r\n\r\n \" }\");\r\n break;\r\n }\r\n JSON.Append(\"]\" +\r\n\r\n \" },\");\r\n\r\n }\r\n JSON.Append(\"],\");\r\n JSON.Append(\"'linkeddata': [\");\r\n foreach (var quat in ProductQuarter.Distinct())\r\n {\r\n if (quat == ProductQuarter.Distinct().Last())\r\n {\r\n JSON.Append(\"{'id': '\" + quat + \"',\" +\r\n\r\n \"'linkedchart': {\" +\r\n \"'chart': {\" +\r\n \"'caption': 'Month wise Revenue for the 1st quarter',\" +\r\n \"'subCaption': 'Harrys SuperMart',\" +\r\n \"'xAxisname': 'Months',\" +\r\n \"'yAxisName': 'Revenues (In USD)',\" +\r\n \"'numberPrefix': '$',\" +\r\n \"'theme': 'fint'\" +\r\n \" },\" +\r\n \"'categories': [{\" +\r\n \"'category': [\" +\r\n\r\n getQuarterWiseMonth(quat) +\r\n \"]\" +\r\n \"}],\"\r\n\r\n\r\n );\r\n JSON.Append(\"'dataset': [\");\r\n\r\n foreach (var seri in SeriesNames.Distinct())\r\n {\r\n if (seri == SeriesNames.Distinct().Last())\r\n {\r\n JSON.Append(\"{\" +\r\n \"'seriesname': '\" + seri + \"',\"\r\n + \"'data': [\" + getquarterseriesWiseData(seri, quat) + \"]}\"\r\n\r\n\r\n\r\n\r\n );\r\n break;\r\n }\r\n JSON.Append(\"{\" +\r\n \"'seriesname': '\" + seri + \"',\"\r\n + \"'data': [\" + getquarterseriesWiseData(seri, quat) + \"]},\"\r\n\r\n\r\n\r\n\r\n );\r\n\r\n\r\n }\r\n JSON.Append(\"]}}\");\r\n break;\r\n }\r\n\r\n JSON.Append(\"{'id': '\" + quat + \"',\" +\r\n\r\n \"'linkedchart': {\" +\r\n \"'chart': {\" +\r\n \"'caption': 'Month wise Revenue for the 1st quarter',\" +\r\n \"'subCaption': 'Harrys SuperMart',\" +\r\n \"'xAxisname': 'Months',\" +\r\n \"'yAxisName': 'Revenues (In USD)',\" +\r\n \"'numberPrefix': '$',\" +\r\n \"'theme': 'fint'\" +\r\n \" },\" +\r\n \"'categories': [{\" +\r\n \"'category': [\" +\r\n\r\n getQuarterWiseMonth(quat) +\r\n \"]\" +\r\n \"}],\"\r\n\r\n\r\n );\r\n JSON.Append(\"'dataset': [\");\r\n\r\n foreach (var seri in SeriesNames.Distinct())\r\n {\r\n\r\n if (seri == SeriesNames.Distinct().Last())\r\n {\r\n JSON.Append(\"{\" +\r\n \"'seriesname': '\" + seri + \"'\"\r\n + \",'data': [\" + getquarterseriesWiseData(seri, quat) + \"]}\"\r\n\r\n );\r\n\r\n break;\r\n\r\n }\r\n JSON.Append(\"{\" +\r\n \"'seriesname': '\" + seri + \"',\"\r\n + \"'data': [\" + getquarterseriesWiseData(seri, quat) + \"]},\"\r\n\r\n );\r\n\r\n\r\n }\r\n JSON.Append(\"]}},\");\r\n }\r\n\r\n JSON.Append(\"]}\");\r\n \/\/replacing all ' into \"\r\n string str = JSON.ToString().Replace('\\'', '\\\"');\r\n \/\/writing JSON string into a JSON file and if data will be modified it wil be reflected in json file\r\n System.IO.File.WriteAllText(@Server.MapPath(\"json.json\"), str);\r\n \/\/calling FC Constructor\r\n Chart cc = new Chart(\"mscolumn2d\", \"mychart\", \"750\", \"550\", \"jsonurl\", \"json.json\");\r\n \/\/Rendering chart by calling Render()\r\n l1.Text = cc.Render();\r\n\r\n }\r\n\r\n \/\/function for fetching series wise and quarter wise values\r\n public StringBuilder getquarterseriesWiseData(string series, string quarter)\r\n {\r\n ProductController cont = new ProductController();\r\n StringBuilder subjson = new StringBuilder();\r\n\r\n foreach (var seriwise in cont.getMonthwiseValue(series, quarter))\r\n {\r\n if (seriwise == cont.getMonthwiseValue(series, quarter).Last())\r\n {\r\n subjson.Append(\"{\" +\r\n \"'value': '\" + seriwise + \"'}\");\r\n break;\r\n }\r\n subjson.Append(\"{\" +\r\n \"'value': '\" + seriwise + \"'},\");\r\n\r\n }\r\n return subjson;\r\n\r\n }\r\n \/\/For fetching quarter wise data.\r\n public StringBuilder getQuarterWiseMonth(string quarter)\r\n {\r\n ProductController cont = new ProductController();\r\n StringBuilder subjson = new StringBuilder();\r\n foreach (var month in cont.quarterWiseMonth(quarter).Distinct())\r\n {\r\n if (month == cont.quarterWiseMonth(quarter).Distinct().Last())\r\n {\r\n subjson.Append(\"{\" +\r\n \"'label': '\" + month + \"'}\");\r\n break;\r\n }\r\n subjson.Append(\"{\" +\r\n \"'label': '\" + month + \"'},\");\r\n\r\n }\r\n return subjson;\r\n\r\n }\r\n }\r\n}\r\n<\/pre>\r\nStep 13<\/strong>\r\nPress Ctrl + <\/strong>F5<\/strong> to execute Default.aspx<\/strong>.\r\nYour output should look as seen in the image below.\r\n![\"\"](\"https:\/\/www.fusioncharts.com\/blog\/wp-content\/uploads\/gallery\/blog\/2017\/07\/Output.png\")
\r\nIn your live chart, click the data plot for a quarter to drill-down to see the monthly revenue for that quarter.\r\n<\/span>Was There a Problem Rendering the Chart?<\/span><\/h2>\r\nIn case something went wrong and you are unable to see the chart, check for the following:\r\n\r\n \t- The chart ID should be unique for all charts rendered on the same page. Otherwise, it will result in a JavaScript error.<\/li>\r\n \t
- If the chart does not show up at all, check if the fusioncharts.js<\/strong> and FusionCharts wrapper FusionCharts.java<\/strong> was loaded. Also, check if the path to the fusioncharts.js<\/strong> and the FusionCharts.java<\/strong> files is correct, and whether the files exist in that location.<\/li>\r\n<\/ul>","protected":false},"excerpt":{"rendered":"
All charts (except for the zoom-line chart) in FusionCharts Suite XT can be configured to be rendered as drill-down charts. Drill-down charts can be implemented using several features, for example, the data plots can be linked to other charts, to simple URLs that will be open in the same page or in a different page, […]<\/p>\n","protected":false},"author":29,"featured_media":16033,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"coauthors":[652,650],"class_list":["post-16029","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"yoast_head":"\n
FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026<\/title>\n<meta name=\"description\" content=\"Configure almost any chart as a drill-down visual. Use 2026 FusionCharts Suite XT to create deep-dive interfaces for your users. Improve interaction today.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026\" \/>\n<meta property=\"og:description\" content=\"Configure almost any chart as a drill-down visual. Use 2026 FusionCharts Suite XT to create deep-dive interfaces for your users. Improve interaction today.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/\" \/>\n<meta property=\"og:site_name\" content=\"FusionBrew - The FusionCharts Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-13T08:30:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T09:06:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fusioncharts.com\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1015\" \/>\n\t<meta property=\"og:image:height\" content=\"417\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nikita Jhanglani, Soumya Dutta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nikita Jhanglani, Soumya Dutta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\/\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"Article\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#article\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/\"\n\t },\n\t \"author\": {\n\t \"name\": \"Nikita Jhanglani\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/person\/270a83f8aefb80dafb2a931de0282717\"\n\t },\n\t \"headline\": \"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026\",\n\t \"datePublished\": \"2017-07-13T08:30:42+00:00\",\n\t \"dateModified\": \"2026-01-20T09:06:47+00:00\",\n\t \"mainEntityOfPage\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/\"\n\t },\n\t \"wordCount\": 917,\n\t \"commentCount\": 0,\n\t \"publisher\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#organization\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage\"\n\t },\n\t \"thumbnailUrl\": \"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg\",\n\t \"articleSection\": [\n\t \"Tutorials\"\n\t ],\n\t \"inLanguage\": \"en-US\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"CommentAction\",\n\t \"name\": \"Comment\",\n\t \"target\": [\n\t \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#respond\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"WebPage\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/\",\n\t \"url\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/\",\n\t \"name\": \"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#website\"\n\t },\n\t \"primaryImageOfPage\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage\"\n\t },\n\t \"thumbnailUrl\": \"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg\",\n\t \"datePublished\": \"2017-07-13T08:30:42+00:00\",\n\t \"dateModified\": \"2026-01-20T09:06:47+00:00\",\n\t \"description\": \"Configure almost any chart as a drill-down visual. Use 2026 FusionCharts Suite XT to create deep-dive interfaces for your users. Improve interaction today.\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#breadcrumb\"\n\t },\n\t \"inLanguage\": \"en-US\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"ReadAction\",\n\t \"target\": [\n\t \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage\",\n\t \"url\": \"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg\",\n\t \"contentUrl\": \"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg\",\n\t \"width\": 1015,\n\t \"height\": 417\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#breadcrumb\",\n\t \"itemListElement\": [\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 1,\n\t \"name\": \"Home\",\n\t \"item\": \"https:\/\/www.fusioncharts.com\/blog\/\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 2,\n\t \"name\": \"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026\"\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"WebSite\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#website\",\n\t \"url\": \"https:\/\/www.fusioncharts.com\/blog\/\",\n\t \"name\": \"FusionBrew - The FusionCharts Blog\",\n\t \"description\": \"Get tips and tricks on how to build effective Data Visualisation using FusionCharts\",\n\t \"publisher\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#organization\"\n\t },\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"SearchAction\",\n\t \"target\": {\n\t \"@type\": \"EntryPoint\",\n\t \"urlTemplate\": \"https:\/\/www.fusioncharts.com\/blog\/?s={search_term_string}\"\n\t },\n\t \"query-input\": {\n\t \"@type\": \"PropertyValueSpecification\",\n\t \"valueRequired\": true,\n\t \"valueName\": \"search_term_string\"\n\t }\n\t }\n\t ],\n\t \"inLanguage\": \"en-US\"\n\t },\n\t {\n\t \"@type\": \"Organization\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#organization\",\n\t \"name\": \"FusionCharts\",\n\t \"url\": \"https:\/\/www.fusioncharts.com\/blog\/\",\n\t \"logo\": {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/logo\/image\/\",\n\t \"url\": \"\/blog\/wp-content\/uploads\/2020\/03\/idera-fc-logo.svg\",\n\t \"contentUrl\": \"\/blog\/wp-content\/uploads\/2020\/03\/idera-fc-logo.svg\",\n\t \"width\": 1,\n\t \"height\": 1,\n\t \"caption\": \"FusionCharts\"\n\t },\n\t \"image\": {\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/logo\/image\/\"\n\t }\n\t },\n\t {\n\t \"@type\": \"Person\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/person\/270a83f8aefb80dafb2a931de0282717\",\n\t \"name\": \"Nikita Jhanglani\",\n\t \"image\": {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/person\/image\/8ccbb6c1287de762e6e06a7da1088fe5\",\n\t \"url\": \"\/blog\/wp-content\/wphb-cache\/gravatar\/6ea\/6ea57614eecc7c184539f84654fd9592x96.jpg\",\n\t \"contentUrl\": \"\/blog\/wp-content\/wphb-cache\/gravatar\/6ea\/6ea57614eecc7c184539f84654fd9592x96.jpg\",\n\t \"caption\": \"Nikita Jhanglani\"\n\t },\n\t \"url\": \"https:\/\/www.fusioncharts.com\/blog\/author\/nikita-jhanglani\/\"\n\t }\n\t ]\n\t}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026","description":"Configure almost any chart as a drill-down visual. Use 2026 FusionCharts Suite XT to create deep-dive interfaces for your users. Improve interaction today.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/","og_locale":"en_US","og_type":"article","og_title":"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026","og_description":"Configure almost any chart as a drill-down visual. Use 2026 FusionCharts Suite XT to create deep-dive interfaces for your users. Improve interaction today.","og_url":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/","og_site_name":"FusionBrew - The FusionCharts Blog","article_published_time":"2017-07-13T08:30:42+00:00","article_modified_time":"2026-01-20T09:06:47+00:00","og_image":[{"width":1015,"height":417,"url":"https:\/\/www.fusioncharts.com\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg","type":"image\/jpeg"}],"author":"Nikita Jhanglani, Soumya Dutta","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nikita Jhanglani, Soumya Dutta","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#article","isPartOf":{"@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/"},"author":{"name":"Nikita Jhanglani","@id":"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/person\/270a83f8aefb80dafb2a931de0282717"},"headline":"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026","datePublished":"2017-07-13T08:30:42+00:00","dateModified":"2026-01-20T09:06:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/"},"wordCount":917,"commentCount":0,"publisher":{"@id":"https:\/\/www.fusioncharts.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage"},"thumbnailUrl":"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg","articleSection":["Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/","url":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/","name":"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026","isPartOf":{"@id":"https:\/\/www.fusioncharts.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage"},"image":{"@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage"},"thumbnailUrl":"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg","datePublished":"2017-07-13T08:30:42+00:00","dateModified":"2026-01-20T09:06:47+00:00","description":"Configure almost any chart as a drill-down visual. Use 2026 FusionCharts Suite XT to create deep-dive interfaces for your users. Improve interaction today.","breadcrumb":{"@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#primaryimage","url":"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg","contentUrl":"\/blog\/wp-content\/uploads\/2017\/07\/New-Project-Path_Task-1-Step-1.jpg","width":1015,"height":417},{"@type":"BreadcrumbList","@id":"https:\/\/www.fusioncharts.com\/blog\/creating-fusioncharts-drill-down-charts-from-database-using-entity-framework-and-linq-in-visual-studio\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fusioncharts.com\/blog\/"},{"@type":"ListItem","position":2,"name":"FusionCharts Drill-Downs with EF & LINQ in Visual Studio 2026"}]},{"@type":"WebSite","@id":"https:\/\/www.fusioncharts.com\/blog\/#website","url":"https:\/\/www.fusioncharts.com\/blog\/","name":"FusionBrew - The FusionCharts Blog","description":"Get tips and tricks on how to build effective Data Visualisation using FusionCharts","publisher":{"@id":"https:\/\/www.fusioncharts.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fusioncharts.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fusioncharts.com\/blog\/#organization","name":"FusionCharts","url":"https:\/\/www.fusioncharts.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/logo\/image\/","url":"\/blog\/wp-content\/uploads\/2020\/03\/idera-fc-logo.svg","contentUrl":"\/blog\/wp-content\/uploads\/2020\/03\/idera-fc-logo.svg","width":1,"height":1,"caption":"FusionCharts"},"image":{"@id":"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/person\/270a83f8aefb80dafb2a931de0282717","name":"Nikita Jhanglani","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fusioncharts.com\/blog\/#\/schema\/person\/image\/8ccbb6c1287de762e6e06a7da1088fe5","url":"\/blog\/wp-content\/wphb-cache\/gravatar\/6ea\/6ea57614eecc7c184539f84654fd9592x96.jpg","contentUrl":"\/blog\/wp-content\/wphb-cache\/gravatar\/6ea\/6ea57614eecc7c184539f84654fd9592x96.jpg","caption":"Nikita Jhanglani"},"url":"https:\/\/www.fusioncharts.com\/blog\/author\/nikita-jhanglani\/"}]}},"_links":{"self":[{"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/posts\/16029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/comments?post=16029"}],"version-history":[{"count":0,"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/posts\/16029\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/media\/16033"}],"wp:attachment":[{"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/media?parent=16029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/categories?post=16029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/tags?post=16029"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.fusioncharts.com\/blog\/wp-json\/wp\/v2\/coauthors?post=16029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}