The support for Language Integrated Query (LINQ), a Microsoft .NET Framework component adds SQL-like data querying capabilities to .NET languages. The addition of LINQ builds on eXtremeDB's C# application programming interface (API) and provides developers with a succinct, extensible and increasingly popular approach to database querying, with additional benefits including protection against software bugs caused by data-typing errors.
Effective immediately, eXtremeDB editions for Windows support LINQ and include a specialised LINQ provider that implements queries using multiple database index types.
LINQ queries can be included in any application that defines and interacts with an eXtremeDB database using the C# API.
Developers accustomed to SQL will find many LINQ query operators, such as “Select”, “Where” and “Join”, to be familiar. Other frequently cited LINQ benefits include high developer productivity (through easy query parameterisation and code re-use, for example), and the ability to query a wide range of data sources including RDBMSs, XML files and .NET collection classes.
The LINQ library also provides useful data source processing (filtering, sorting, grouping, etc.), which can be applied to the results of eXtremeDB queries. McObject claims that LINQ enables eXtremeDB for .NET users to benefit from the IntelliSense feature of Microsoft's Visual Studio, which automatically completes text the developer is typing, fills in symbols and parameters, and provides other services to speed up programming.
In addition, LINQ adds type-safety: queries are checked for correctness when compiled and, if necessary, rejected. This eliminates data-typing errors, which comprise a major source of run-time bugs.
This article originally appeared on EE Times Europe.