{"id":21067,"date":"2024-03-15T21:27:18","date_gmt":"2024-03-15T21:27:18","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/"},"modified":"2024-03-21T19:36:07","modified_gmt":"2024-03-21T19:36:07","slug":"how-to-query-data-by-month-in-linq","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/","title":{"rendered":"How to query data by month in LINQ?"},"content":{"rendered":"<p>In LINQ, you can use the GroupBy method to group data by month and use the DateTime.Month property to get the month of the date.<\/p>\n<p>Here is an example code that demonstrates how to query data by month.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\">\/\/ \u5047\u8bbe\u6709\u4e00\u4e2a\u5305\u542b\u65e5\u671f\u548c\u6570\u636e\u7684\u5217\u8868<\/span>\r\nList&lt;DataItem&gt; data = <span class=\"hljs-keyword\">new<\/span> List&lt;DataItem&gt;()\r\n{\r\n    <span class=\"hljs-keyword\">new<\/span> DataItem { Date = <span class=\"hljs-keyword\">new<\/span> DateTime(<span class=\"hljs-number\">2022<\/span>, <span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">15<\/span>), Value = <span class=\"hljs-number\">10<\/span> },\r\n    <span class=\"hljs-keyword\">new<\/span> DataItem { Date = <span class=\"hljs-keyword\">new<\/span> DateTime(<span class=\"hljs-number\">2022<\/span>, <span class=\"hljs-number\">2<\/span>, <span class=\"hljs-number\">25<\/span>), Value = <span class=\"hljs-number\">20<\/span> },\r\n    <span class=\"hljs-keyword\">new<\/span> DataItem { Date = <span class=\"hljs-keyword\">new<\/span> DateTime(<span class=\"hljs-number\">2022<\/span>, <span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">5<\/span>), Value = <span class=\"hljs-number\">30<\/span> },\r\n    <span class=\"hljs-keyword\">new<\/span> DataItem { Date = <span class=\"hljs-keyword\">new<\/span> DateTime(<span class=\"hljs-number\">2022<\/span>, <span class=\"hljs-number\">3<\/span>, <span class=\"hljs-number\">10<\/span>), Value = <span class=\"hljs-number\">40<\/span> },\r\n    <span class=\"hljs-keyword\">new<\/span> DataItem { Date = <span class=\"hljs-keyword\">new<\/span> DateTime(<span class=\"hljs-number\">2022<\/span>, <span class=\"hljs-number\">2<\/span>, <span class=\"hljs-number\">10<\/span>), Value = <span class=\"hljs-number\">50<\/span> }\r\n};\r\n\r\n<span class=\"hljs-comment\">\/\/ \u6309\u6708\u4efd\u5206\u7ec4\u5e76\u67e5\u8be2<\/span>\r\n<span class=\"hljs-keyword\">var<\/span> result = data.GroupBy(item =&gt; item.Date.Month)\r\n                 .Select(<span class=\"hljs-keyword\">group<\/span> =&gt; <span class=\"hljs-keyword\">new<\/span> {\r\n                     Month = <span class=\"hljs-keyword\">group<\/span>.Key,\r\n                     Sum = <span class=\"hljs-keyword\">group<\/span>.Sum(item =&gt; item.Value)\r\n                 });\r\n\r\n<span class=\"hljs-comment\">\/\/ \u8f93\u51fa\u7ed3\u679c<\/span>\r\n<span class=\"hljs-keyword\">foreach<\/span> (<span class=\"hljs-keyword\">var<\/span> item <span class=\"hljs-keyword\">in<\/span> result)\r\n{\r\n    Console.WriteLine(<span class=\"hljs-string\">$\"Month: <span class=\"hljs-subst\">{item.Month}<\/span>, Sum: <span class=\"hljs-subst\">{item.Sum}<\/span>\"<\/span>);\r\n}\r\n<\/code><\/pre>\n<p>In this example, we start by grouping the data by month using the GroupBy method. Then, we use the Select method to process each group, creating a new anonymous type object that includes the month and the total sum of data for that month. Finally, we output the results using a foreach loop.<\/p>\n<p>Please note that the DataItem class in the example is a custom data item class used to store dates and data values. You will need to make adjustments according to your own data structure.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In LINQ, you can use the GroupBy method to group data by month and use the DateTime.Month property to get the month of the date. Here is an example code that demonstrates how to query data by month. \/\/ \u5047\u8bbe\u6709\u4e00\u4e2a\u5305\u542b\u65e5\u671f\u548c\u6570\u636e\u7684\u5217\u8868 List&lt;DataItem&gt; data = new List&lt;DataItem&gt;() { new DataItem { Date = new DateTime(2022, 1, 15), [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-21067","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to query data by month in LINQ? - Blog - Silicon Cloud<\/title>\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.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to query data by month in LINQ?\" \/>\n<meta property=\"og:description\" content=\"In LINQ, you can use the GroupBy method to group data by month and use the DateTime.Month property to get the month of the date. Here is an example code that demonstrates how to query data by month. \/\/ \u5047\u8bbe\u6709\u4e00\u4e2a\u5305\u542b\u65e5\u671f\u548c\u6570\u636e\u7684\u5217\u8868 List&lt;DataItem&gt; data = new List&lt;DataItem&gt;() { new DataItem { Date = new DateTime(2022, 1, 15), [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T21:27:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T19:36:07+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"How to query data by month in LINQ?\",\"datePublished\":\"2024-03-15T21:27:18+00:00\",\"dateModified\":\"2024-03-21T19:36:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/\"},\"wordCount\":134,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/\",\"name\":\"How to query data by month in LINQ? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T21:27:18+00:00\",\"dateModified\":\"2024-03-21T19:36:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to query data by month in LINQ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to query data by month in LINQ? - Blog - Silicon Cloud","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.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/","og_locale":"en_US","og_type":"article","og_title":"How to query data by month in LINQ?","og_description":"In LINQ, you can use the GroupBy method to group data by month and use the DateTime.Month property to get the month of the date. Here is an example code that demonstrates how to query data by month. \/\/ \u5047\u8bbe\u6709\u4e00\u4e2a\u5305\u542b\u65e5\u671f\u548c\u6570\u636e\u7684\u5217\u8868 List&lt;DataItem&gt; data = new List&lt;DataItem&gt;() { new DataItem { Date = new DateTime(2022, 1, 15), [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T21:27:18+00:00","article_modified_time":"2024-03-21T19:36:07+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"How to query data by month in LINQ?","datePublished":"2024-03-15T21:27:18+00:00","dateModified":"2024-03-21T19:36:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/"},"wordCount":134,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/","name":"How to query data by month in LINQ? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T21:27:18+00:00","dateModified":"2024-03-21T19:36:07+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-query-data-by-month-in-linq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to query data by month in LINQ?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=21067"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21067\/revisions"}],"predecessor-version":[{"id":54907,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21067\/revisions\/54907"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=21067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=21067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=21067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}