Powerful Data Layer Components for .NET

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

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

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

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

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

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

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.

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

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.

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.

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.

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.

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.

The UI control enables users to analyze records from Dynamics. 

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

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

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

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

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.

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.

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.

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.

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.

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.