{"id":1368,"date":"2012-05-08T00:14:32","date_gmt":"2012-05-07T15:14:32","guid":{"rendered":"http:\/\/team-pag.interprism.co.jp\/member\/okazawa\/blog\/?p=1368"},"modified":"2019-12-30T15:28:01","modified_gmt":"2019-12-30T06:28:01","slug":"%e3%80%90clinq%e3%80%91join%e3%83%a1%e3%82%bd%e3%83%83%e3%83%89%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e5%86%85%e9%83%a8%e7%b5%90%e5%90%88%e3%82%92%e8%a1%8c%e3%81%86","status":"publish","type":"post","link":"https:\/\/zawapro.com\/?p=1368","title":{"rendered":"\u3010C#\/LINQ\u3011Join()\u3092\u4f7f\u3063\u3066\u5185\u90e8\u7d50\u5408(inner join)\u3092\u884c\u3046"},"content":{"rendered":"

LINQ\u306eJoin()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\u3001SQL\u306e\u5185\u90e8\u7d50\u5408(inner join)\u306b\u76f8\u5f53\u3059\u308b\u30c7\u30fc\u30bf\u64cd\u4f5c\u3092\u884c\u3063\u3066\u307f\u3088\u3046\u3002
\n\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u304c\u3042\u308b\u3068\u3057\u3066\u3001\u305d\u308c\u3092LINQ\u3067\u7d50\u5408\u3057\u3066\u307f\u308b\u3053\u3068\u306b\u3059\u308b\u3002<\/p>\n

\nPersons<\/p>\n\n\n\n\n\n\n\n
Id<\/th>\nName<\/th>\nAge<\/th>\nJobId<\/th>\n<\/tr>\n
1<\/td>\nJohn<\/td>\n56<\/td>\n1<\/td>\n<\/tr>\n
2<\/td>\nMike<\/td>\n23<\/td>\n1<\/td>\n<\/tr>\n
3<\/td>\nKen<\/td>\n64<\/td>\n2<\/td>\n<\/tr>\n
4<\/td>\nAlice<\/td>\n41<\/td>\n4<\/td>\n<\/tr>\n
5<\/td>\nTom<\/td>\n22<\/td>\n3<\/td>\n<\/tr>\n<\/table>\n<\/div>\n
\nJobs<\/p>\n\n\n\n\n\n\n\n
Id<\/th>\nName<\/th>\n<\/tr>\n
1<\/td>\nProgrammer<\/td>\n<\/tr>\n
2<\/td>\nEngineer<\/td>\n<\/tr>\n
3<\/td>\nSportman<\/td>\n<\/tr>\n
4<\/td>\nKing<\/td>\n<\/tr>\n
5<\/td>\nSlave<\/td>\n<\/tr>\n<\/table>\n<\/div>\n
<\/div>\n

C#\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308b\u3002<\/p>\n

\nProgram.cs<\/p>\n
\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\n\nnamespace ConsoleApplication1\n{\n    class Person\n    {\n        public int Id { get; set; }\n        public String Name{ get; set; }\n        public int Age { get; set; }\n        public int JobId { get; set; }\n    }\n\n    class Job\n    {\n        public int Id { get; set; }\n        public String Name { get; set; }\n    }\n\n    class Program\n    {\n        static void Main(string[] args)\n        {\n            var persons = new Person[]{ \n                new Person{ Id = 1,Name = \"John\",  Age = 56, JobId = 1},\n                new Person{ Id = 2,Name = \"Mike\",  Age = 23, JobId = 1},\n                new Person{ Id = 3,Name = \"Ken\",   Age = 64, JobId = 2},\n                new Person{ Id = 4,Name = \"Alice\", Age = 41, JobId = 4},\n                new Person{ Id = 5,Name = \"Tom\",   Age = 22, JobId = 3},\n            };\n\n            var jobs = new Job[] { \n                new Job{ Id = 1, Name = \"Programmer\" },\n                new Job{ Id = 2, Name = \"Engineer\" },\n                new Job{ Id = 3, Name = \"Sportman\" },\n                new Job{ Id = 4, Name = \"King\" },\n                new Job{ Id = 5, Name = \"Slave\" }\n            };\n\n            var query =\n                persons.Join(jobs, p => p.JobId, j => j.Id, (p, j) => new {\n                    PersonId = p.Id,\n                    Name = p.Name,\n                    Age = p.Age,\n                    JobName = j.Name\n                });\n\n            foreach (var j in query)\n            {\n                Console.WriteLine(\"PersonId:{0}\\tName:{1}\\tAge:{2}\\tJob:{3}\", j.PersonId, j.Name, j.Age, j.JobName);\n            }\n        }\n    }\n}\n<\/pre>\n<\/div>\n
\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u5b9f\u884c\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u305f\u3002<\/p>\n
\nPersonId:1      Name:John       Age:56  Job:Programmer\nPersonId:2      Name:Mike       Age:23  Job:Programmer\nPersonId:3      Name:Ken        Age:64  Job:Engineer\nPersonId:4      Name:Alice      Age:41  Job:King\nPersonId:5      Name:Tom        Age:22  Job:Sportman\n\u7d9a\u884c\u3059\u308b\u306b\u306f\u4f55\u304b\u30ad\u30fc\u3092\u62bc\u3057\u3066\u304f\u3060\u3055\u3044 . . .\n<\/code><\/pre>\n
\u53c2\u8003\u306b\u3001\u4ee5\u4e0a\u306e\u64cd\u4f5c\u3092\u30af\u30a8\u30ea\u5f0f\u3067\u66f8\u3044\u305f\u5834\u5408\u3068SQL\u3067\u66f8\u3044\u305f\u5834\u5408\u306b\u3064\u3044\u3066\u793a\u3059\u3002<\/p>\n
\n\u30af\u30a8\u30ea\u5f0f<\/p>\n
\nvar query =\n    from p in persons\n    join j in jobs on p.JobId equals j.Id\n    select new{ PersonId=p.Id, Name=p.Name, Age = p.Age, JobName = j.Name };\n<\/pre>\n<\/div>\n
\nSQL<\/p>\n
\nSELECT\n    Persons.Id AS PersonId,\n    Persons.Name AS Name,\n    Persons.Age AS Age,\n    Jobs.Name AS JobName\nFROM\n    Persons\nINNER JOIN\n    Jobs ON Persons.JobId = Jobs.Id\n<\/pre>\n<\/div>\n
\u30af\u30a8\u30ea\u5f0f\u306f\u3001\u30bf\u30a4\u30d7\u6570\u306f\u5c11\u306a\u304f\u6e08\u3080\u306e\u3060\u304c\u3001\u4eca\u3072\u3068\u3064\u53ef\u8aad\u6027\u306b\u512a\u308c\u306a\u3044\u3053\u3068\u3082\u3042\u3063\u3066\u3001
\n\u6700\u8fd1\u306f\u5168\u304f\u4f7f\u308f\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u2026\u3002<\/p>\n
\u95a2\u9023\u8a18\u4e8b<\/h1>\n