Linq to Objects supported Joining Data
Abstract
Joins have been studied as a key operations in multiple application domains. This paper focuses on the study of joins as a first-class LINQ operators and their implementation as integrated component of the query processing. The join methods provided in the LINQ perform inner join, left outer join, and cross join. Our goal is to provide join operations, similar to SQL statements in the databases. We describe an efficient implementation of the following join operators: inner join, left outer join, right inner join, full outer join, left excluding join, right excluding join, full outer excluding join, and cross join. A simple example is used to present the potentialities of LINQ technology to solve the problem with the object-relational mapping.References
Jeff Atwood, Coding Horror (2007): A Visual Explanation of SQL Joins, Last access 10.11.2012, http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html.
M. Goranova and L. Stoyanova (2012): Effective query implementation of scientific data based on LINQ to XML. Annual Journal of Electronics 6(2), pp. 125-128.
Juan Francisco Morales Larios (2012): LinQ Extended Joins, Last access: 10.11.2012, http://www.codeproject.com/Articles/488643/LinQ-Extended-Joins.
Scott Mitchell (2009): An Extensive Examination of LINQ: Grouping and Joining Data, Last access: 10.11.2012, http://www.4guysfromrolla.com/articles/080509-1.aspx.
P. Pialorsi and M. Russo (2010): Programming Microsoft LINQ in Microsoft .NET Framework 4, O'Reilly Media, Inc.
