dotConnect for Zoho Desk

Connect Zoho Desk Data With .NET Application Easily

dotConnect for Zoho Desk is an ADO.NET provider for working with Zoho Desk data through the standard ADO.NET or Entity Framework interfaces. It allows you to easily incorporate Zoho Desk data into your .NET applications, and integrate Zoho Desk services with widely used data-oriented technologies.

dotConnect for Zoho Desk has the same standard ADO.NET classes as other standard ADO.NET providers: ZohoConnection, ZohoCommand, ZohoDataAdapter, ZohoDataReader, ZohoParameter, etc. This allows you to quickly get started and eliminates the need to learn any specific details of accessing Zoho Desk data.

Features

Direct access to the Zoho Desk data
High performance
Comprehensive security features
Broad compatibility with .NET platforms
Visual Studio integration

Compatibility

The following table shows which version of this package to use with which version of frameworks.

Frameworks	Version support
Entity Framework Core	1x-9.0
.NET	5.0, 6.0, 7.0, 8.0, 9.0
.NET Core	3, 2, 1
.NET Framework	2.0-4.8

More information here

Usage

In order to connect to Zoho Desk you need to have the corresponding account, dotConnect for Zoho Desk installed and IDE running. You also have to know the required connection parameters described below.

Note that if you do not use design-time (specifically, if you do not place designer ZohoDeskConnection component from the Toolbox to the form), you have to embed licensing information manually. This is described in topic Licensing.

Required Connection Parameters

To establish a connection to server you have to provide the required connection parameters to dotConnect for Zoho Desk. This information is used by ZohoDeskConnection component to connect to Zoho Desk. The parameters are represented as a connection string. You can compose the connection string manually or have dotConnect for Zoho Desk construct it for you.

The following connection string parameters are required:

Data Center - if your Zoho Desk is hosted in US, Europe, China, India, Australia, Japan, UK, Canadam you need to specify the corresponding data center.

Refresh Token - a renewable access token. Sign in with Zoho Desk, the token will be assigned automatically.

Creating a Connection to Zoho Desk

The following assumes that you have IDE running, and you are currently focused on a form designer.

Open Toolbox and find ZohoDeskConnection component in dotConnect for Zoho Desk category.
Double-click the component. Notice that new object appears on the designer underneath the form. If this is first time you create the ZohoDeskConnection in this application it is named ZohoDeskConnection1.
Click on the ZohoDeskConnection1 object and press F4 to focus on object's properties.
Enter the required connection string parameters, described above, to the corresponding boxes.
Notice that as you assign values to these properties the ConnectionString property is automatically updated to reflect your settings. Now it contains something like Refresh Token=1000.a6fde76542bfbb5244a7e539d4390e72.87e34ea57023c2d0e7dcb9ce55e3e7f.
If necessary, click the Advanced button and configure other connection string parameters. You can find the description of these connection string parameters in the ZohoDeskConnection.ConnectionString topic.

This snippet directly configures a Zoho Desk connection using a connection string.

ZohoDeskConnection1.ConnectionString = Refresh Token=1000.a6fde76542bfbb5244a7e539d4390e72.87e34ea57023c2d0e7dcb9ce55e3e7f;

Read the full documentation for connection here.

Creating Connection in Server Explorer

To create a Server Explorer connection, you just need to:

1. Click Connect to Database on the Server Explorer toolbar

2. If the Zoho Desk Data Source is not selected by default, click the Change button.

3. Select Zoho Desk Data Source (dotConnect for Zoho Desk) and click OK.

4. Click Web Login.

5. In the opened Web Login dialog box sign in to your Zoho Desk account.

Power of SQL

dotConnect for Zoho Desk allows you to perform SQL queries against your Zoho Desk data. Use SQL statements to work with Zoho Desk accounts, contacts, accounts, activities, tasks, calls, events, and other objects.

Our provider offers full CRUD (Create, Read, Update, and Delete) support and allows you to get Zoho Desk data with SELECT statements and manage data with INSERT, UPDATE, and DELETE statements.

No need to study and use complex Zoho Desk API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with Zoho Desk API.

Entity Framework Support

dotConnect for Zoho Desk allows you to access Zoho Desk data via Entity Framework - Microsoft's recommended data access technology. It supports Entity Framework v4, v5, v6, and Entity Framework Core 7.0, and enables you to use the following Entity Framework features with Zoho Desk data:

*LINQ to Entities (no need for Zoho Desk API)

*Entity relations with lazy/eager loading

*No need to post each edited/created object separately - a single SaveChanges() call to persist all the changed objects

dotConnect for Zoho Desk provides enhanced Entity Framework support for Zoho Desk data with a bundled visual designer for ORM models with Visual Studio integration - Entity Developer. Standard Visual Studio Entity Data Model designer is also supported.

Zoho CRM Data Binding

https://www.devart.com/dotconnect/zohodesk/images/zohodesk-data-binding.png

*Build your data access layer without writing code manually

*Configure dotConnect for Zoho Desk components in powerful design-time editors

*Bind data grids and other controls to Zoho Desk data just by configuring the smart tags

*Work with Zoho Desk data just like with a database

License

See pricing options.

Trial Limitations

The dotConnect for Zoho Desk Evaluation License lets you try dotConnect for Zoho Desk Trial Edition for a period of 30 days. You may not use applications developed using Trial versions of the Software for any commercial purposes.

Devart Software