McObject®, developer of the eXtremeDB® In-Memory Database System (IMDS), announced it has added support in eXtremeDB for Language Integrated Query (LINQ), a Microsoft .NET Framework component that 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 specialized 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 parameterization 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.
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.
About eXtremeDB and its C#/.NET Framework API
McObject’s eXtremeDB In-Memory Database System delivers the responsiveness demanded in real-time applications that cannot tolerate the latency imposed by on-disk database systems. Key features include all-in-memory data storage and manipulation; support for ACID (Atomic, Consistent, Isolated and Durable) database transactions, complex data types and multiple database indexes; a powerful debugging environment and multiple, intuitive APIs; custom collations; optional multi-version concurrency control (MVCC) transaction manager; RC4 encryption and page-level cyclic redundancy check (CRC), for security; exceptional portability; available source code, and more.
Specialized eXtremeDB editions provide additional powerful capabilities including high availability, hybrid (in-memory and on-disk) storage, database clustering, 64-bit support, transaction logging, and support for kernel mode deployment.
The eXtremeDB C# API delivers the speed of a compiled C language database run-time, with the convenience of using a familiar development environment. Developers work with the real-time database entirely from within C#’s object-oriented domain. There is no external database definition, and no requirement to compile a database schema. Instead, the API relies on C#’s reflection capability to discover database classes and their fields that are defined in the application, in the class definition syntax. This streamlines coding, and the developer’s experience is one of working with plain old C# objects.
Optionally, the C# class definitions can be used to generate a schema that, in turn, can be processed by McObject’s schema compiler, so that C/C++ and C# programs can use the same database.
About McObject
Founded by embedded database and real-time systems experts, McObject offers proven data management technology that makes applications and devices smarter, more reliable and more cost-effective to develop and maintain. McObject counts among its customers industry leaders such BAE Systems, Siemens, Phillips, EADS, JVC, Tyco Thermal Controls, F5 Networks, CA, Motorola and Boeing. McObject, based in Issaquah, WA, is committed to providing innovative technology and first-rate services to customers and partners. The company can be reached at +1-425-888-8505, or visit www.mcobject.com.