Powerful Data Layer Components for .NET

Take your data management to the next level by building scalable services that run on any .NET platform. 

  • Connect to cloud data sources and CRMs
  • Efficiently load and display large data sets
  • Analyze, slice, and pivot data
  • Supports .NET 6, ASP.NET MVC, WinForms, WPF, WinUI, UWP, Xamarin, and OS X
Download Free Trial (2022v2)

Overview

ComponentOne Data Services is a collection of .NET Standard libraries that make working with data seamless across any .NET application or service.

Why Choose Data Services for Your .NET Applications?

Data Integration

Access and integrate data from various online and cloud-based sources, including Dynamics CRM and Salesforce.

Data Analysis

Extract, transform, and load (ETL) your data. Analyze it by sorting, filtering, and aggregating at runtime—without needing to hit the server.

Data Extraction

Quickly parse text files and HTML pages to extract data from sources other than a database.

High Performance

Take advantage of in-memory caching and data virtualization to deliver faster loading and large data set analysis.

Powerful Server-Side Web APIs

Empower and extend your apps with web services for exporting, uploading, and caching files and data.

Combine Data From Multiple Sources

Blend data from multiple data sources, including SQL Server and JSON, into a single queryable collection of objects in your C# code.

Explore All Data Service Components

DataConnectors

Connect to Cloud Data Sources in .NET

Directly connect to numerous online services, including Salesforce, Google Analytics, and Dynamics 365. Integrate data into your .NET applications with ComponentOne DataConnectors.

DataCollection

Fast Data Binding and Loading for Large Data Sets

Experience a powerful data binding component that provides filtering, grouping, sorting, and virtualization features to incrementally load large data sets with ComponentOne DataCollection.

DataEngine

Analyze, Slice, and Pivot Your Data

Take advantage of in-memory caching to deliver faster extraction, transformation, and loading (ETL) of large and complex data sets with ComponentOne DataEngine.

CalcEngine

Deliver Excel-like Formula Calculation Anywhere

Parse and evaluate expressions, such as Microsoft Excel, that support common built-in functions with ComponentOne CalcEngine.

TextParser

Automate Text Extraction in .NET

Parse text and extract data from text and HTML files to increase workflow productivity with ComponentOne TextParser.

Web API

Extend Your Apps with a Server-Side Web API

Use ComponentOne Web API to retrieve and write data to your server-hosted native, mobile, and web apps with a wide array of APIs for document formats, imaging, reporting, and cloud services.

See What You Can Do With Data Services

Desktop

In this demonstration, we analyze Dynamics 365 sales opportunity data in a .NET application to find opportunities for each product, sales representative, and fiscal quarter.

Integrate Google Analytics Data Into a Dashboard

Retrieve data from Google Analytics and create a dashboard in .NET WinForms. Review basic features like authentication, caching and querying.

Extract Product Information From Amazon in .NET

Extract data from e-commerce websites like Amazon. This blog demonstrates using the C1TextParser library to extract data in a structured format from Amazon product pages to use in your .NET apps.

Creating a .NET Salesforce OData Service

Learn how to build an OData service in ASP.NET Core to avoid excess calls to Salesforce, or any online CRM, by periodically caching data in your .NET applications.

Integrate QuickBooks Online Data Using ADO. NET

Explore how to use the ADO.NET C1DataConnector for QuickBooks Online to connect to QuickBooks Online data and explain basic features like authentication, querying, and caching.

Convert an Excel File Stored in the Cloud to JSON

Allow users to connect to different cloud storage services, such as Google and DropBox, with a single API. The Excel API can generate, split, merge, find, and replace Excel files and convert them to various formats like CSV, JSON, and XML.

Implement a Smart Tag System With TextParser

Smart Tag is a feature initially introduced in Microsoft Word that recognizes parts of a text, highlights it in some form, and adds an optional action that can be performed using the specified text.

Visualize Dynamics 365 Sales Data in a .NET Pivot Grid

The Dynamics 365 ADO.NET connector is helpful when used with an analytical UI control, such as the ComponentOne OLAP/Pivot control.

The UI control enables users to analyze records from Dynamics. 

Import Data From Salesforce to QuickBooks Online

There are several cases where users would need to import data from Salesforce to QuickBooks Online. Explore them using C1DataConnectors and ADO.NET.

In-Memory Analytics With Salesforce Data and C1DataEngine

This blog demonstrates fetching data from Salesforce and applying Pivot transformations, such as aggregating values in one column, using C1DataConnectors, and C1DataEngine.

Build a Leads to Opportunity Salesforce Report Using .NET

Learn how to create a sales opportunity report from multiple lead sources in Salesforce using the .NET FlexReport Designer.

Paste and Format Hyperlinks in a WPF Rich Text Editor

Combine the WPF RichTextBox component with TextParser to automatically convert and format URLs to hyperlinks within a rich text editing application.

Pivot Transforms With C1DataEngine

Apply pivot transformations, such as grouping and aggregation, to large data sets. Quickly analyze large data sets with C1DataEngine—featuring optimization techniques like column-oriented and memory-mapped files.

Create an Excel-like Formula Bar in .NET WinForms

Creating and evaluating expressions with C1CalcEngine is Excel-like, straightforward, and familiar. Discover how to create a simple expression and use the Evaluate function to obtain the result.

Extract Text From HTML Emails Automatically

Emails follow an expected structure and make it possible for predictable and automatic parsing. When using C1TextParser, individual pieces of information can be recorded or analyzed through email.

Query Data From Salesforce and Display in FlexGrid

How are ComponentOne DataConnectors and FlexGrid useful for businesses? Learn how to consume data from Salesforce and perform actions that are unavailable out-of-the-box, such as sorting, grouping, and caching.

Integrate Dynamics 365 CRM With .NET Using Entity Framework Core

Access data using Entity Framework Core and LINQ to update Dynamics 365 Sales entities. Explore various use cases for accessing Microsoft Dynamics 365 Sales data outside of the CRM in an external application like reports, BI dashboards, and data process application integration.

Use Visitor WEB API for Targeted Marketing

Internet browsers are capable of collecting considerable amounts of visitor data and retrieving browser-specific information. This information is useful for product creation, marketing, and audience strategies.

Easy Licensing and Distribution

Manage your licenses through your GrapeCity account.

Licensing FAQ

ComponentOne is licensed per developer. Once you purchase a license, you can build and publish your .NET applications using ComponentOne controls. Licensing is perpetual and royalty-free.

Learn more about licensing

Become an OEM Partner

To create your own commercially licensed SDK or web application builder, choose the Commercial OEM license. Commercial OEM and SaaS licenses are customized per customer. 

Become an OEM Partner

End-User Licensing Agreement

Our End-User License Agreement (EULA) includes information on ComponentOne's licensing, legal agreement, and the terms and conditions that govern software usage. 

Read the EULA

ComponentOne Customer Feedback and Awards

"Prompt responses, quality feedback, and help with code examples. Fantastic service!"

RICHARD HERBERT

"Excellent product with good support"

MIKE WEBSTER

"I am very appreciative of the effort your entire team gave to make this transaction happen. Thank you for your efforts!"

SAM COLE

ComponentSource #2 Publisher 2022 Award ComponentSource #3 Product 2022 Award

"When I run into complex problems, I turn to my ComponentOne Studio Enterprise toolbox."

KEN SPENSER, MICROSOFT REGIONAL DIRECTOR - FRAMEWORK MASTERS

"I love to use C1 components! I can be confident that if I need to do a particular task, ComponentOne will have the control to do the job."

SILV SORDELLO, SOFTWARE DEVELOPER

"As an ISV, I need tools that allow me to be competitive. Therefore, it's a must to use reliable and stable tools for customized solutions...ComponentOne provides all that to me and even more!"

DENNIS WALLENTIN, MICROSOFT MVP (EXCEL)

"Easier to use right off the bat. I liked using the Scheduler for drag-and-drop capability."

MICHELLE GIBSON, SOFTWARE ENGINEER