{"id":48,"date":"2016-10-25T14:55:32","date_gmt":"2016-10-25T14:55:32","guid":{"rendered":"http:\/\/www.softwaretraininginchennai.com\/blog\/?p=48"},"modified":"2017-02-10T03:06:54","modified_gmt":"2017-02-10T03:06:54","slug":"linq-query-with-different-data-sources-list-array-and-sql","status":"publish","type":"post","link":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/","title":{"rendered":"Linq query with different data sources List, Array and SQL"},"content":{"rendered":"<div style=\"color: #000; font-size: 14px;\">\n<h2><span style=\"color: #2e75b5; font-family: Calibri; font-size: 14pt;\">Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429<br \/>\n<\/span><\/h2>\n<p>Create <strong>StudentDetails<\/strong> Table in <strong>TestDB<\/strong> using the below snippet,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 320px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 2px; color: #000;\"><b>CREATE TABLE [dbo].[StudentDetails] (<br \/>\n[Id] INT IDENTITY (1, 1) NOT NULL,<br \/>\n[StudentName] VARCHAR (50) NULL,<br \/>\n[Age] INT NULL,<br \/>\n[inchargeStudentId] INT NULL,<br \/>\nPRIMARY KEY CLUSTERED ([Id] ASC)<br \/>\n);<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>&#8211; Create a Console Application<br \/>\nUse SQL to Linq Converter,<br \/>\n<a href=\"http:\/\/www.sqltolinq.com\/\">http:\/\/www.sqltolinq.com\/<\/a><br \/>\n<span style=\"color: #000;\">Click on Generate Linq to SQL Model Files, <\/span><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png\" alt=\"\" \/><br \/>\nBrowse a Folder and Click on OK.<br \/>\nClick on Generate Linq to SQL Files,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi3.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi4.png\" alt=\"\" \/><br \/>\nConvert SQL query to Linq as below,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi5.png\" alt=\"\" \/><br \/>\nAge&gt; 24 and StudentName contains &#8216;Sco&#8217;<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi6.png\" alt=\"\" \/><br \/>\n<span style=\"color: #595959; font-size: 9pt;\"><em>Screen clipping taken: 10-09-2016 19:21<\/em><\/span><br \/>\n<strong>Self Join in Linq<\/strong><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi7.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi8.png\" alt=\"\" \/><br \/>\nRight click on the table and select Regenerate Model Files.<br \/>\nInsert the connection below in App.config,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi9.png\" alt=\"\" \/><\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 728px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 5px; color: #000;\"><b>&lt;connectionStrings&gt;<br \/>\n&lt;add name=&#8221;TestConnection&#8221; connectionString=&#8221;Data Source=(LocalDb)\\v11.0;Initial Catalog=TestDB;Integrated Security=True;Pooling=False&#8221; providerName=&#8221;System.Data.SqlClient&#8221; \/&gt;<br \/>\n&lt;\/connectionStrings&gt;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Add StudentDetails.cs and data context file as below,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 378px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 5px; color: #000;\"><b>public class StudentDetails<br \/>\n{<br \/>\npublic int Id { get; set; }<br \/>\npublic string StudentName { get; set; }<br \/>\npublic int? Age { get; set; }<br \/>\npublic int? InchargeStudentId { get; set; }<br \/>\n}<br \/>\npublic class UsersContext : DbContext<br \/>\n{<br \/>\npublic UsersContext(): base(&#8220;TestConnection&#8221;)<br \/>\n{<br \/>\n}<br \/>\npublic DbSet&lt;StudentDetails&gt; studentDbset { get; set; }<br \/>\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Insert the below Code snippet in Console,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 728px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 5px; color: #000;\"><b>class Program<br \/>\n{<br \/>\nprivate static UsersContext db = new UsersContext();<br \/>\nstatic void Main(string[] args)<br \/>\n{<br \/>\n\/* Getting the Student Db Collection from DB *\/<br \/>\nList&lt;StudentDetails&gt; obj= db.studentDbset.ToList();<br \/>\nforeach (var item in obj)<br \/>\n{<br \/>\nConsole.WriteLine(&#8220;Student Name&#8221; + &#8220;\\t&#8221; + item.StudentName + &#8220;\\t&#8221; + &#8220;Age:&#8221; + item.Age);<br \/>\n}<br \/>\n\/* Getting the Student Db Collection for Age&gt;24 from DB *\/<br \/>\nConsole.WriteLine(&#8220;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-&#8220;);<br \/>\nConsole.WriteLine(&#8220;Printing Age &gt; 24&#8221;);<br \/>\nvar query =<br \/>\nfrom StudentDetails1 in db.studentDbset<br \/>\nwhere<br \/>\nStudentDetails1.Age &gt; 24<br \/>\nselect new<br \/>\n{<br \/>\nId = StudentDetails1.Id,<br \/>\nStudentName = StudentDetails1.StudentName,<br \/>\nAge = StudentDetails1.Age<br \/>\n};<br \/>\nforeach (var r in query)<br \/>\nConsole.WriteLine(&#8220;Student Name&#8221; + &#8220;\\t&#8221; + r.StudentName + &#8220;\\t&#8221; + &#8220;Age:&#8221; + r.Age);<br \/>\n\/* Getting the Student Db Collection for Age&gt;24 from DB *\/<br \/>\nConsole.WriteLine(&#8220;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-&#8220;);<br \/>\nConsole.WriteLine(&#8220;Printing Age &gt; 24 &amp;&amp; Student Name contains Sco&#8221;);<br \/>\nvar query1 =<br \/>\nfrom StudentDetails1 in db.studentDbset<br \/>\nwhere<br \/>\nStudentDetails1.Age &gt; 24 &amp;&amp;<br \/>\nStudentDetails1.StudentName.Contains(&#8220;Sco&#8221;)<br \/>\nselect new<br \/>\n{<br \/>\nId = StudentDetails1.Id,<br \/>\nStudentName = StudentDetails1.StudentName,<br \/>\nAge = StudentDetails1.Age<br \/>\n};<br \/>\nforeach (var r in query1)<br \/>\nConsole.WriteLine(&#8220;Student Name&#8221; + &#8220;\\t&#8221; + r.StudentName + &#8220;\\t&#8221; + &#8220;Age:&#8221; + r.Age);<br \/>\n\/* Getting the Student Db Collection for getting Incharge on Self join from DB *\/<br \/>\nConsole.WriteLine(&#8220;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-&#8220;);<br \/>\nConsole.WriteLine(&#8220;Printing self join for Students Lead&#8221;);<br \/>\nvar query2 =<br \/>\nfrom s in db.studentDbset<br \/>\njoin s1 in db.studentDbset on new { InchargeStudentId = s.InchargeStudentId.Value } equals new { InchargeStudentId = s1.Id }<br \/>\nselect new<br \/>\n{<br \/>\ns.Id,<br \/>\ns.StudentName,<br \/>\ns.Age,<br \/>\nincharge = s1.StudentName<br \/>\n};<br \/>\nforeach (var r in query2)<br \/>\nConsole.WriteLine(&#8220;Student Name&#8221; + &#8220;\\t&#8221; + r.StudentName + &#8220;\\t&#8221; + &#8220;Age:&#8221; + r.Age + &#8220;\\t&#8221; + &#8220;Incharge:&#8221; + r.incharge);<br \/>\n\/* Getting the Collection from DB *\/<br \/>\nConsole.WriteLine(&#8220;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-&#8220;);<br \/>\nConsole.WriteLine(&#8220;Printing from Array&#8221;);<br \/>\nstring[] ary = new string[] { &#8220;Jan&#8221;, &#8220;Feb&#8221;, &#8220;Mar&#8221;, &#8220;Apr&#8221;, &#8220;May&#8221;, &#8220;Jun&#8221;, &#8220;Jul&#8221;, &#8220;Aug&#8221;, &#8220;Sep&#8221;, &#8220;Oct&#8221;, &#8220;Nov&#8221;, &#8220;Dec&#8221; };<br \/>\nvar res = from months in ary<br \/>\nwhere months.StartsWith(&#8220;J&#8221;)<br \/>\nselect new { MonthStartWith_J = months };<br \/>\nforeach (var r in res)<br \/>\nConsole.WriteLine(&#8220;Month:&#8221; + &#8220;\\t&#8221; + r.MonthStartWith_J);<br \/>\n\/* Getting the Collection from DB *\/<br \/>\nConsole.WriteLine(&#8220;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-&#8220;);<br \/>\nConsole.WriteLine(&#8220;Printing from Collection&#8221;);<br \/>\nList&lt;string&gt; objstring = new List&lt;string&gt;();<br \/>\nobjstring.Add(&#8220;Yahooo&#8221;);<br \/>\nobjstring.Add(&#8220;Google&#8221;);<br \/>\nobjstring.Add(&#8220;HCL&#8221;);<br \/>\nvar obj1 = from company in objstring where company.StartsWith(&#8220;Goo&#8221;)<br \/>\nselect new { companyStartWith_Goo = company };<br \/>\nforeach (var r in obj1)<br \/>\nConsole.WriteLine(&#8220;Month:&#8221; + &#8220;\\t&#8221; + r.companyStartWith_Goo);<br \/>\nConsole.ReadLine();<br \/>\n}<br \/>\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>The Output as below,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi10.png\" alt=\"\" \/><br \/>\n<span style=\"color: #595959; font-size: 9pt;\"><em>Screen clipping taken: 10-09-2016 21:34<\/em><\/span><br \/>\nClick below for download,<br \/>\n<a href=\"https:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6hZlD6medX1rPn9pw\">https:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6hZlD6medX1rPn9pw<\/a><br \/>\n<strong>Reference<\/strong><br \/>\nhttp:\/\/www.dotnetlearners.com\/linq\/linq-to-string-array-with-example.aspx<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429 Create StudentDetails Table in TestDB using the below snippet, CREATE TABLE [dbo].[StudentDetails] ( [Id] INT IDENTITY (1, 1) NOT NULL, [StudentName] VARCHAR (50) NULL, [Age] INT NULL, [inchargeStudentId] INT NULL, PRIMARY KEY CLUSTERED ([Id] ASC) ); &#8211; Create a Console Application Use SQL to Linq Converter, http:\/\/www.sqltolinq.com\/ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,1],"tags":[44,55,58,60,85,86,87,88,89,91,121,125],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-linq-queries-in-net","category-uncategorized","tag-dot-net-linq","tag-dot-net-workshop-in-chennai","tag-dotnet-linq-console-application","tag-dotnet-training-in-chennai","tag-linq-in-net","tag-linq-queries-with-sql","tag-linq-query-with-array","tag-linq-query-with-different-datasources","tag-linq-query-with-list-collection","tag-maria-academy","tag-quick-learning-on-linq","tag-sample-linq-application"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Linq query with different data sources List, Array and SQL | Maria Academy<\/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.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Linq query with different data sources List, Array and SQL | Maria Academy\" \/>\n<meta property=\"og:description\" content=\"Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429 Create StudentDetails Table in TestDB using the below snippet, CREATE TABLE [dbo].[StudentDetails] ( [Id] INT IDENTITY (1, 1) NOT NULL, [StudentName] VARCHAR (50) NULL, [Age] INT NULL, [inchargeStudentId] INT NULL, PRIMARY KEY CLUSTERED ([Id] ASC) ); &#8211; Create a Console Application Use SQL to Linq Converter, http:\/\/www.sqltolinq.com\/ [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Maria Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DotnetTrainingChennai\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-25T14:55:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-10T03:06:54+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:site\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"headline\":\"Linq query with different data sources List, Array and SQL\",\"datePublished\":\"2016-10-25T14:55:32+00:00\",\"dateModified\":\"2017-02-10T03:06:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/\"},\"wordCount\":602,\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png\",\"keywords\":[\"Dot net Linq\",\"Dot net Workshop in chennai\",\"Dotnet Linq Console Application\",\"Dotnet Training in Chennai\",\"Linq in .net\",\"Linq Queries with Sql\",\"Linq Query with Array\",\"Linq Query with Different datasources\",\"Linq Query with List collection\",\"Maria Academy\",\"Quick learning on Linq\",\"Sample Linq Application\"],\"articleSection\":[\"Linq Queries in .net\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/\",\"name\":\"Linq query with different data sources List, Array and SQL | Maria Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png\",\"datePublished\":\"2016-10-25T14:55:32+00:00\",\"dateModified\":\"2017-02-10T03:06:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage\",\"url\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png\",\"contentUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Linq query with different data sources List, Array and SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\",\"name\":\"Maria Academy\",\"description\":\"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Linq query with different data sources List, Array and SQL | Maria Academy","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.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/","og_locale":"en_US","og_type":"article","og_title":"Linq query with different data sources List, Array and SQL | Maria Academy","og_description":"Document by Ganesan &#8211; Ganesanva@hotmail.com &#8211; + 919600370429 Create StudentDetails Table in TestDB using the below snippet, CREATE TABLE [dbo].[StudentDetails] ( [Id] INT IDENTITY (1, 1) NOT NULL, [StudentName] VARCHAR (50) NULL, [Age] INT NULL, [inchargeStudentId] INT NULL, PRIMARY KEY CLUSTERED ([Id] ASC) ); &#8211; Create a Console Application Use SQL to Linq Converter, http:\/\/www.sqltolinq.com\/ [&hellip;]","og_url":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/","og_site_name":"Maria Academy","article_publisher":"https:\/\/www.facebook.com\/DotnetTrainingChennai","article_published_time":"2016-10-25T14:55:32+00:00","article_modified_time":"2017-02-10T03:06:54+00:00","og_image":[{"url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@dotnettraining2","twitter_site":"@dotnettraining2","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#article","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/"},"author":{"name":"admin","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"headline":"Linq query with different data sources List, Array and SQL","datePublished":"2016-10-25T14:55:32+00:00","dateModified":"2017-02-10T03:06:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/"},"wordCount":602,"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png","keywords":["Dot net Linq","Dot net Workshop in chennai","Dotnet Linq Console Application","Dotnet Training in Chennai","Linq in .net","Linq Queries with Sql","Linq Query with Array","Linq Query with Different datasources","Linq Query with List collection","Maria Academy","Quick learning on Linq","Sample Linq Application"],"articleSection":["Linq Queries in .net"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/","name":"Linq query with different data sources List, Array and SQL | Maria Academy","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png","datePublished":"2016-10-25T14:55:32+00:00","dateModified":"2017-02-10T03:06:54+00:00","author":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"breadcrumb":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#primaryimage","url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png","contentUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102516_1454_Linqquerywi2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/linq-query-with-different-data-sources-list-array-and-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretraininginchennai.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Linq query with different data sources List, Array and SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/","name":"Maria Academy","description":"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":1,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":305,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/48\/revisions\/305"}],"wp:attachment":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}