Create Data-Oriented Apps Faster
Salesforce .NET integration is made easy with fast and direct access to the cloud-based CRM. The .NET Salesforce data connector hides the complexity of connecting to Salesforce and offers a unified interface for performing common operations against multiple data sources.
Manage Data More Efficiently
Integrate sales data from Salesforce into your custom applications without relying on additional software. This empowers end-users to manage data more efficiently and, ultimately, gain better insights.
Connect to Salesforce from Any Platform
The Salesforce .NET API is built against .NET Standard from the ground up, so it's supported across Windows, Mac, Linux and mobile device platforms. Connect to Salesforce from your desktop, web and mobile applications.
ADO.NET, Entity Framework Core & LINQ Support
Connect to Salesforce data using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects like C1SalesforceConnection, C1SalesforceCommand, and C1SalesforceDataAdapter to make it easy to set up a connection. It also has in-built support for LINQ queries for native .NET data queries.
OpenAuth Authentication Support
The Salesforce .NET data connector supports OpenAuth-based authentication to help you protect your data through a secure connection. OpenAuth provides an open-standard authorization protocol or framework that describes how unrelated servers and services can safely allow authenticated access to their assets without actually sharing the initial, related, single login credential.
SQL Query Support
Query against Salesforce data using standard SQL syntax. The Salesforce .NET C# data connector supports most SQL functionality including joins queries, functions, and summaries.
In addition to querying, the data connectors support other CRUD operations such as insertion, updating, and deleting data. The data connector supports these operations using Command and DataAdapter objects. Also, performance could be enhanced in these operations by using the Batch feature to submit changes in chunks over the network.
Fast Cache with Incremental Updates
The data connector has in-built caching in order to support local availability of data for faster performance on repeat operations. It also supports incremental updates so that only new or modified records get synced to the cache. This improves performance over time because your app does not need to perform a full refresh to update the cache. You can set the cache settings in connection object to configure cache database.
Scaffolding is a reverse engineering technique that helps you quickly generate model classes based on the entities of your Salesforce database. The data connector library has built-in support for the scaffolding technique similar to Entity Framework Core. When you run the scaffolding command in Visual Studio, the scaffold engine will generate model classes and a database context for EF Core.
More Data Integration Capabilities
While the Salesforce .NET C# data connector focuses primarily on the connecting and querying, you can use it alongside other .NET Standard and .NET Framework components to do a lot more.
- Integrate Salesforce data with C1DataCollection to provide filtering, grouping, data virtualization to your data-aware controls.
- Import data from Salesforce to C1DataEngine to analyze massive amounts of data in fractions of second.
- Connect Salesforce data to pivot grids & charts, such as FlexPivot, to analyze data visually
- Create business reports using FlexReport and Salesforce for essential business tasks.
- Display sales data from Salesforce in a .NET FlexGrid control in desktop, web, or mobile devices.