Publisher: ComponentOne Primary Category: SQL Product Type: Component / .NET Class / .NET LINQ Class
Speed up LINQ queries in memory. ComponentOne LiveLinq is a class library that extends the functionality of LINQ using indexing and other optimizations to speed up LINQ queries in memory. ComponentOne LiveLinq also offers live view that is a LINQ query result that is kept constantly up-to-date without re-populating it every time its base data changes. LiveLinq uses indexing and other optimizations to speed up LINQ queries in memory. Speed gains can be hundreds and even thousands of times on queries with high selectivity conditions.
Compare and synchronize databases programmatically. ApexSQL Diff API is a programmable API that allows you to use ApexSQL Diff's and ApexSQL Data Diff's comparison and synchronization engine in your own applications. ApexSQL Diff API offers full programmatic access to our comparison tool engine API, incorporate database compare and sync functionality into your own custom applications, integrate our compare algorithms into your automated build process and other internal systems, includes full working example and complete object model documentation. ApexSQL Diff API can be used with any .NET language.
Audit SQL databases programmatically. ApexSQL Log API is a programmable API that adds transaction log auditing capabilities to your own applications. It enables you to tap into ApexSQL Log's auditing capabilities and functionalities eliminating the need to code them yourself. ApexSQL Log API is primarily intended for development of specialized auditing modules for your applications. Because it exposes SQL Server's transaction log to your application, it can also be used for data recovery (although ApexSQL Log offers more advantages and features in this regard) and performance tracking (e.g. track most updated tables and pages).
Publisher: Red Gate Software Primary Category: SQL Product Type: Component / .NET Class
Automates comparison and synchronization tasks. SQL Comparison SDK provides full API access to Red Gate comparison tools. The SQL Comparison SDK provides a means to compare and synchronize database schemas and data from within your own applications, with a greater degree of control than the command line interfaces. With SQL Comparison SDK you can automate tasks using all the new objects, XML datatypes and CLR assemblies in SQL Server 2005 and 2008. Use SQL Comparison SDK to schedule any of the tasks you require from the SQL Bundle of tools.
Publisher: Active Database Software Primary Category: SQL Product Type: Component / ASP.NET WebForms / .NET WinForms / .NET Class / 100% Managed Code
Build complex SQL queries via an intuitive visual interface. Active Query Builder .NET Edition is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder .NET Edition supports Visual Studio 2005, Windows.Forms environment (100% Managed Code, No direct Win32 interop calls). The new Active Query Builder ASP.NET Edition is designed for ASP.NET 2.0 environment, it provides native and easy way to embed visual query building functionality into your ASP.NET projects. Active Query Builder ASP.NET Edition is based on Active Query Builder .NET (Windows Forms) Edition. Utilizing the same powerful SQL parsing engine, it's end-user web interface has much in common with the ancestor.
Build complex SQL queries via an intuitive visual interface. Active Query Builder is a query builder component suite for Borland Delphi and C++Builder which gives your end-users the ability to create complex SQL queries containing unions and sub-queries via an intuitive visual interface. Active Query Builder has complete support of Oracle, Microsoft SQL Server, MySQL, PostgreSQL, InterBase, Informix and more SQL dialects and can be integrated with your application by setting a few properties or adding a few lines of code.
Build complex SQL queries via an intuitive visual interface. Active Query Builder is a .NET-ready ActiveX visual query builder component which gives your end-users the ability to create complex SQL queries containing unions and sub-queries via an intuitive visual interface. Active Query Builder has complete support of Oracle, Microsoft SQL Server, MySQL, PostgreSQL, Interbase/Firebird, SQLite and ANSI-92 SQL dialects and can be integrated with your application by setting a few properties or adding a few lines of code.
Build complex SQL queries via an intuitive visual interface. Active Query Builder Java Edition is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder Java Edition is a Swing-based Java bean component built using JRE 6 (1.6) and supports all modern Java development environments including NetBeans, Eclipse and IntelliJ IDEA.
Provide data access to SQL Server databases from your VCL applications. SQL Server Data Access Components (SDAC) library offers a set of nonvisual components for Delphi and C++ Builder. They provide access to Microsoft SQL Server and are an alternative to the standard way of accessing databases using Borland Database Engine (BDE). SDAC supports SAL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7 and MSDE.
Powerful functions for string, date and time manipulation. SQLUtilities extends and enhances your T-SQL programming environment by adding: 21 date and time related functions, including a table-valued date and time sequence generator; random date and time generators; working days calculations; date and time arithmetic; formatting, parsing and type conversion, 37 string and text processing functions including string concatenation functions and aggregates; scalar and table-valued tokenized string parsing; advanced formatting, searching and substitution; regular expressions processing; collation-free comparisons; type conversions., 3 useful numeric functions - including a table-valued numberline sequence generator - allowing you to generate any required set of incremental numeric values of any size on the fly without having to create and maintain lookup tables, and two excel-like random number generators that are easier to use than the built-in T-SQL RAND() function and 3 relative column reference aggregate functions, allowing you to select values from multiple columns in an aggregation from the row that contains the maximum, minimum or a matching value of one column.