{"id":27102,"date":"2024-03-16T07:52:24","date_gmt":"2024-03-16T07:52:24","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/"},"modified":"2024-03-22T10:12:42","modified_gmt":"2024-03-22T10:12:42","slug":"how-to-view-the-sql-statement-generated-by-linq","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/","title":{"rendered":"How to view the SQL statement generated by Linq?"},"content":{"rendered":"<p>There are various ways to view the SQL statements generated by LINQ at runtime, depending on the LINQ provider and development environment you are using.<\/p>\n<ol>\n<li>Keep track of changes made to the DataContext.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (<span class=\"hljs-keyword\">var<\/span> db = <span class=\"hljs-keyword\">new<\/span> YourDataContext())\r\n{\r\n    db.Log = Console.Out;\r\n    <span class=\"hljs-comment\">\/\/ \u6267\u884c LINQ \u67e5\u8be2<\/span>\r\n}\r\n<\/code><\/pre>\n<p>This will output the generated SQL statements on the console.<\/p>\n<ol>\n<li>Database recording<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (<span class=\"hljs-keyword\">var<\/span> db = <span class=\"hljs-keyword\">new<\/span> YourDbContext())\r\n{\r\n    db.Database.Log = Console.Write;\r\n    <span class=\"hljs-comment\">\/\/ \u6267\u884c LINQ \u67e5\u8be2<\/span>\r\n}\r\n<\/code><\/pre>\n<p>This will output the generated SQL statement on the console.<\/p>\n<ol>\n<li>Utilize LINQPad: LINQPad is a third-party tool commonly used for viewing and analyzing LINQ queries. You can paste your LINQ query code into LINQPad and view the generated SQL statements by selecting the option to execute to SQL.<\/li>\n<\/ol>\n<p>Please note that these methods may vary depending on the LINQ provider and development environment being used. Choose the method that best suits your specific situation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are various ways to view the SQL statements generated by LINQ at runtime, depending on the LINQ provider and development environment you are using. Keep track of changes made to the DataContext. using (var db = new YourDataContext()) { db.Log = Console.Out; \/\/ \u6267\u884c LINQ \u67e5\u8be2 } This will output the generated SQL statements [&hellip;]<\/p>\n","protected":false},"author":12,"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-27102","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 view the SQL statement generated by 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-view-the-sql-statement-generated-by-linq\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to view the SQL statement generated by Linq?\" \/>\n<meta property=\"og:description\" content=\"There are various ways to view the SQL statements generated by LINQ at runtime, depending on the LINQ provider and development environment you are using. Keep track of changes made to the DataContext. using (var db = new YourDataContext()) { db.Log = Console.Out; \/\/ \u6267\u884c LINQ \u67e5\u8be2 } This will output the generated SQL statements [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-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-16T07:52:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T10:12:42+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\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=\"Liam\" \/>\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-view-the-sql-statement-generated-by-linq\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"How to view the SQL statement generated by Linq?\",\"datePublished\":\"2024-03-16T07:52:24+00:00\",\"dateModified\":\"2024-03-22T10:12:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/\"},\"wordCount\":128,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/\",\"name\":\"How to view the SQL statement generated by Linq? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T07:52:24+00:00\",\"dateModified\":\"2024-03-22T10:12:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to view the SQL statement generated by 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\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to view the SQL statement generated by 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-view-the-sql-statement-generated-by-linq\/","og_locale":"en_US","og_type":"article","og_title":"How to view the SQL statement generated by Linq?","og_description":"There are various ways to view the SQL statements generated by LINQ at runtime, depending on the LINQ provider and development environment you are using. Keep track of changes made to the DataContext. using (var db = new YourDataContext()) { db.Log = Console.Out; \/\/ \u6267\u884c LINQ \u67e5\u8be2 } This will output the generated SQL statements [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T07:52:24+00:00","article_modified_time":"2024-03-22T10:12:42+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"How to view the SQL statement generated by Linq?","datePublished":"2024-03-16T07:52:24+00:00","dateModified":"2024-03-22T10:12:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/"},"wordCount":128,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/","name":"How to view the SQL statement generated by Linq? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T07:52:24+00:00","dateModified":"2024-03-22T10:12:42+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-sql-statement-generated-by-linq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to view the SQL statement generated by 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\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27102","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=27102"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27102\/revisions"}],"predecessor-version":[{"id":61313,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27102\/revisions\/61313"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=27102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=27102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=27102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}