How to setup ADO drivers for Visual Studio (ADO.NET Odoo v23 example)

1. Close all instances of Visual Studio 

2. Download and install the driver: Download ADO.NET Provider for Odoo ERP. 30-Day Free Trial (cdata.com) 

.NET Framework (No-Code approach using the Server Explorer)- 

1. Navigate to “C:\Program Files\CData\CData ADO.NET Provider for Odoo 2023\lib” and run the .vsix file corresponding to your Visual Studio’s year. 

2. Open Visual Studio and add the Data Connection 

.NET Standard- 

1. Open Visual Studio and create a Console App (not to be confused with .NET Framework Console App). 

2. Add a Project Reference 

3. Add “C:\Program Files\CData\CData ADO.NET Provider for Odoo 2023\lib\netstandard2.0\System.Data.CData.Odoo.dll”. **NOTE: This is an example path for the ADO Odoo v23 driver. Your driver’s name might be different – make sure to change the path you use accordingly. 

4. Open a Cmd Prompt window in Admin Mode and navigate to ““C:\Program Files\CData\CData ADO.NET Provider for Odoo 2023\lib\netstandard2.0\” 

5. Issue the command based on what you want to do: 

1. dotnet ./install-license.dll <- Start your 30-day trial. 

2. dotnet ./install-license.dll <license key> <- Use your product key. 

6. You are now set up to begin using the ADO driver. Refer to the “Connecting from Code” section of your respective product’s documentation to begin working: https://cdn.cdata.com/help/OEJ/ado/pg_ADOconnectcode.htm. 

EFCore- 

To use EFCore, you first need to Install EFCore and register the EF Core Provider. Failing to do so is one of the most common reasons customers run into errors when trying to use our drivers in an EFCore project. 

1. Install Entity Framework Core 

Please reference the ‘Using Entity Framework Core’ section of your data source’s documentation for the latest information for that driver version. 

i.e. for the Hubspot data source v23: 

https://cdn.cdata.com/help/DHJ/ado/pg_efCoreOverview.htm#:~:text=Install%20Entity%20Framework%20Core 

2. Register the EF Core Provider.  

Please reference the ‘Using Entity Framework Core’ section of your data source’s documentation for the latest information for that driver version. 

i.e. for the Hubspot data source v23: https://cdn.cdata.com/help/DHJ/ado/pg_efCoreOverview.htm#:~:text=Text.Encoding.CodePages-,Register%20the%20Entity%20Framework%20Core%20Provider,-Complete%20the%20following. 

Entity Framework- 

Setting up the driver for use with Entity Framework usually requires you to first register the Entity Framework 6 provider, and, then either following our Model-First or Code-First approach. 

1. Register the EF6 Provider 

1. Install EF6 

1. Install-Package EntityFramework 

2. Register the EF6 Provider 

1. Navigate to the Using EF 6 section of your data source’s documentation on our website for the latest instructions for your driver version. 

2. i.e. ADO.NET Hubspot v23: https://cdn.cdata.com/help/DHJ/ado/pg_ef6.htm#:~:text=Install%2DPackage%20EntityFramework-,Register%20the%20Entity%20Framework%20Provider,-Complete%20the%20following 

2. Follow either our Model-First or Code-First guide depending on your needs. The most current information for these sections are included under the ‘Using Entity Framework’ section of your data source’s documentation located on our website. 

i.e. ADO.NET Hubspot v23: CData ADO.NET Provider for HubSpot - Using Entity Framework.