SQL / Software Components & Controls

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.

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.

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.

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.

Add grid, reporting, charting, scheduling, data manipulation, user interface and more to your .NET, ASP.NET, Mobile Device, Windows Presentation Foundation and ActiveX applications. ComponentOne Studio Enterprise includes components from all ComponentOne Studio subscriptions offering you over 180 components for .NET, ASP.NET ( AJAX ready), WPF, Silverlight, ActiveX, and Mobile Devices. ComponentOne Studio Enterprise delivers the latest components, new releases, updates and upgrades, and email and online support for one full year from your date of purchase. ComponentOne Studio Enterprise 2011 adds support for .NET 4.0 and Visual Studio 2010.

Build line-of-business and data analysis applications. ComponentOne Ultimate includes all 9 of ComponentOne's Studios - ComponentOne Studio for WinForms, ComponentOne Studio for ASP.NET Wijmo, ComponentOne Studio for WPF, ComponentOne Studio for Silverlight, ComponentOne Studio for Windows Phone, ComponentOne Studio for iPhone, ComponentOne Studio for Compact Framework, ComponentOne Studio for SharePoint and ComponentOne Studio for Active X. It also includes ComponentOne Livelinq and ComponentOne's OLAP tools - ComponentOne OLAP for WinForms, ComponentOne OLAP for Silverlight and ComponentOne OLAP for LightSwitch as well as ComponentOne XapOptimizer, ComponentOne IntelliSpell and Doc-To-Help Enterprise. ComponentOne Ultimate includes datagrids, user interface controls, charting, reporting, scheduling and data manipulation components for .NET, ASP.NET, WPF, Silverlight, ActiveX and Mobile devices and development tools for analyzing data and increasing productivity. By purchasing ComponentOne Ultimate you will save thousands of dollars over buying the products individually.

Create rich user interfaces, thorough help systems and printed documentation. ComponentOne Studio Enterprise Doc Edition includes ComponentOne Studio Enterprise and the help authoring tool Doc-To-Help Enterprise Edition. ComponentOne Studio Enterprise will allow you to add grid, reporting, charting, data manipulation and user interface capabilities to your .NET, ASP.NET, Mobile Device, WPF and ActiveX applications. ComponentOne Studio Enterprise includes components from ComponentOne Studio subscriptions offering you over 180 components for .NET, ASP.NET, ActiveX, Silverlight, WPF and Mobile Devices. With the ComponentOne Studio Enterprise Ribbon components, combined with Scheduling and Calendar, you can build fully functional Office 2007-style applications. New ComponentOne Studio for Silverlight and ComponentOne Studio for iPhone now included along with support for .NET framework 4.0 and VS2010. Doc-To-Help Enterprise, the one-click RoboHelp replacement, is designed to give you every feature you need to create fully functional and customized Help files and printed manuals from a single source.

Create transparent object-relational mapping (ORM). eXpress Persistent Objects for .NET (DevExpress XPO) represents a bridge between the object world and the world of relational databases. eXpress Persistent Objects for .NET (DevExpress XPO) gives developers the freedom to build true business objects without having to deal with the tedious complexities of mapping them onto database tables. eXpress Persistent Objects for .NET (DevExpress XPO) completely abstracts the database layer from a developer, leaving him or her fully in the object-oriented realm. With DevExpress XPO, you can build applications that work with multiple database systems (presently supports MS Access, MS SQL Server, MySQL, Oracle, PostgreSql, Firebird, PervasiveSQL, VistaDB, SQL Anywhere, Advantage, DB2 and Sybase) without making any changes to your code. DevExpress XPO Source Code Licenses Available.

Automatic database synchronization with a royalty-free .Net component. SQL Schema Sync API is a component designed to automatically synchronize database structure. SQL Schema Sync API can integrate directly into applications and installation of additional software on the client side or development of patches is not required. The component is compatible with applications of any type: Win, Web, Console, Service, and WPF. SQL Schema Sync API provides developers with the ability to create the database structure programmatically, for example, based on business objects structure. Support for LINQ to SQL object model is provided. Full source code is available in the Professional edition. The component is developed for SQL Server 2005/2008 and contains only managed code.

Automatic database synchronization with a royalty-free .Net component. SQL Schema Sync API is a component designed to automatically synchronize database structure. SQL Schema Sync API can integrate directly into applications and installation of additional software on the client side or development of patches is not required. The component is compatible with applications of any type: Win, Web, Console, Service, and WPF. SQL Schema Sync API provides developers with the ability to create the database structure programmatically, for example, based on business objects structure. Support for LINQ to SQL object model is provided. Full source code is available in the Professional edition. The component is developed for SQL Server 2005/2008 and contains only managed code.