{"id":27092,"date":"2024-03-16T07:51:45","date_gmt":"2024-03-16T07:51:45","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/"},"modified":"2024-03-22T10:11:15","modified_gmt":"2024-03-22T10:11:15","slug":"how-does-linq-execute-sql-statements","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/","title":{"rendered":"How does linq execute SQL statements?"},"content":{"rendered":"<p>In LINQ, you can execute SQL statements in two ways: using LINQ to SQL or using Entity Framework.<\/p>\n<p>The steps to executing SQL statements using LINQ to SQL are as follows:<\/p>\n<ol>\n<li>Context of the data<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (<span class=\"hljs-keyword\">var<\/span> context = <span class=\"hljs-keyword\">new<\/span> DataContext(connectionString))\r\n{\r\n    <span class=\"hljs-comment\">\/\/ \u6267\u884cSQL\u8bed\u53e5<\/span>\r\n}\r\n<\/code><\/pre>\n<ol>\n<li>Create SQL query: Use LINQ query expressions or method chaining to create SQL queries.<\/li>\n<\/ol>\n<p>Example of using LINQ query expressions:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">var<\/span> query = <span class=\"hljs-keyword\">from<\/span> c <span class=\"hljs-keyword\">in<\/span> context.Customers\r\n            <span class=\"hljs-keyword\">where<\/span> c.City == <span class=\"hljs-string\">\"London\"<\/span>\r\n            <span class=\"hljs-keyword\">select<\/span> c;\r\n<\/code><\/pre>\n<p>Example of using method chaining:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">var<\/span> query = context.Customers.Where(c =&gt; c.City == <span class=\"hljs-string\">\"London\"<\/span>);\r\n<\/code><\/pre>\n<ol>\n<li>Convert to a list<\/li>\n<li>Return the first element of a sequence, or a default value if the sequence is empty.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">var<\/span> result = query.ToList();\r\n<\/code><\/pre>\n<p>Full example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (<span class=\"hljs-keyword\">var<\/span> context = <span class=\"hljs-keyword\">new<\/span> DataContext(connectionString))\r\n{\r\n    <span class=\"hljs-keyword\">var<\/span> query = <span class=\"hljs-keyword\">from<\/span> c <span class=\"hljs-keyword\">in<\/span> context.Customers\r\n                <span class=\"hljs-keyword\">where<\/span> c.City == <span class=\"hljs-string\">\"London\"<\/span>\r\n                <span class=\"hljs-keyword\">select<\/span> c;\r\n\r\n    <span class=\"hljs-keyword\">var<\/span> result = query.ToList();\r\n}\r\n<\/code><\/pre>\n<p>The steps for executing SQL statements using Entity Framework are as follows:<\/p>\n<ol>\n<li>Context of database operations<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (<span class=\"hljs-keyword\">var<\/span> context = <span class=\"hljs-keyword\">new<\/span> DbContext(connectionString))\r\n{\r\n    <span class=\"hljs-comment\">\/\/ \u6267\u884cSQL\u8bed\u53e5<\/span>\r\n}\r\n<\/code><\/pre>\n<ol>\n<li>Create a SQL query: Use LINQ query expressions or method chaining to create a SQL query.<\/li>\n<\/ol>\n<p>An example of using LINQ query expressions:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">var<\/span> query = <span class=\"hljs-keyword\">from<\/span> c <span class=\"hljs-keyword\">in<\/span> context.Customers\r\n            <span class=\"hljs-keyword\">where<\/span> c.City == <span class=\"hljs-string\">\"London\"<\/span>\r\n            <span class=\"hljs-keyword\">select<\/span> c;\r\n<\/code><\/pre>\n<p>Example of using method chaining:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">var<\/span> query = context.Customers.Where(c =&gt; c.City == <span class=\"hljs-string\">\"London\"<\/span>);\r\n<\/code><\/pre>\n<ol>\n<li>Convert to a list.<\/li>\n<li>Return the first element or a default value if the sequence is empty.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">var<\/span> result = query.ToList();\r\n<\/code><\/pre>\n<p>Full example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> (<span class=\"hljs-keyword\">var<\/span> context = <span class=\"hljs-keyword\">new<\/span> DbContext(connectionString))\r\n{\r\n    <span class=\"hljs-keyword\">var<\/span> query = <span class=\"hljs-keyword\">from<\/span> c <span class=\"hljs-keyword\">in<\/span> context.Customers\r\n                <span class=\"hljs-keyword\">where<\/span> c.City == <span class=\"hljs-string\">\"London\"<\/span>\r\n                <span class=\"hljs-keyword\">select<\/span> c;\r\n\r\n    <span class=\"hljs-keyword\">var<\/span> result = query.ToList();\r\n}\r\n<\/code><\/pre>\n<p>It is important to note that when executing SQL statements using LINQ to SQL or Entity Framework, queries can be created using query expressions or method chaining, and results can be retrieved using methods like ToList(), FirstOrDefault(), etc. Additionally, other LINQ operators like OrderBy(), GroupBy(), etc. can also be used to sort, group, and manipulate the query results.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In LINQ, you can execute SQL statements in two ways: using LINQ to SQL or using Entity Framework. The steps to executing SQL statements using LINQ to SQL are as follows: Context of the data using (var context = new DataContext(connectionString)) { \/\/ \u6267\u884cSQL\u8bed\u53e5 } Create SQL query: Use LINQ query expressions or method chaining [&hellip;]<\/p>\n","protected":false},"author":7,"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-27092","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 does linq execute SQL statements? - 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-does-linq-execute-sql-statements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How does linq execute SQL statements?\" \/>\n<meta property=\"og:description\" content=\"In LINQ, you can execute SQL statements in two ways: using LINQ to SQL or using Entity Framework. The steps to executing SQL statements using LINQ to SQL are as follows: Context of the data using (var context = new DataContext(connectionString)) { \/\/ \u6267\u884cSQL\u8bed\u53e5 } Create SQL query: Use LINQ query expressions or method chaining [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/\" \/>\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:51:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T10:11:15+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\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=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"How does linq execute SQL statements?\",\"datePublished\":\"2024-03-16T07:51:45+00:00\",\"dateModified\":\"2024-03-22T10:11:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/\"},\"wordCount\":209,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/\",\"name\":\"How does linq execute SQL statements? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T07:51:45+00:00\",\"dateModified\":\"2024-03-22T10:11:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How does linq execute SQL statements?\"}]},{\"@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\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How does linq execute SQL statements? - 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-does-linq-execute-sql-statements\/","og_locale":"en_US","og_type":"article","og_title":"How does linq execute SQL statements?","og_description":"In LINQ, you can execute SQL statements in two ways: using LINQ to SQL or using Entity Framework. The steps to executing SQL statements using LINQ to SQL are as follows: Context of the data using (var context = new DataContext(connectionString)) { \/\/ \u6267\u884cSQL\u8bed\u53e5 } Create SQL query: Use LINQ query expressions or method chaining [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T07:51:45+00:00","article_modified_time":"2024-03-22T10:11:15+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"How does linq execute SQL statements?","datePublished":"2024-03-16T07:51:45+00:00","dateModified":"2024-03-22T10:11:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/"},"wordCount":209,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/","url":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/","name":"How does linq execute SQL statements? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T07:51:45+00:00","dateModified":"2024-03-22T10:11:15+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-does-linq-execute-sql-statements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How does linq execute SQL statements?"}]},{"@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\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27092","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=27092"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27092\/revisions"}],"predecessor-version":[{"id":61302,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27092\/revisions\/61302"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=27092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=27092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=27092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}