dotConnect for Salesforce Marketing Cloud is an ADO.NET provider for working with Salesforce Marketing Cloud (formerly ExactTarget) data through the standard ADO.NET interfaces. It allows you to easily integrate Salesforce Marketing Cloud data into your .NET applications, and integrate Salesforce Marketing Cloud services with widely used data-oriented technologies. The provider works with .NET Frameworks 4.5+, .NET Core 2.0+, .NET 5+. It has the same standard ADO.NET classes as other standard ADO.NET providers: ExactTargetConnection, ExactTargetCommand, ExactTargetDataAdapter, ExactTargetDataReader, ExactTargetParameter, etc. This allows you quickly get started with it and eliminates the need to study any Salesforce Marketing Cloud data access specificities. More information at https://www.devart.com/dotconnect/exacttarget/ License See pricing options for ordering https://www.devart.com/dotconnect/exacttarget/ordering.html The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. Key Features * Easy Connection: Allows your .NET application to work with Salesforce Marketing Cloud data. * SQL Engine: No need to study and use complex Salesforce Marketing Cloud API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with Salesforce Marketing Cloud API. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.
Get Started
$ dotnet add package Devart.Data.ExactTarget.EFCoreReadme
dotConnect for Salesforce Marketing Cloud
dotConnect for Salesforce Marketing Cloud is an ADO.NET provider for working with Salesforce Marketing Cloud data through the standard ADO.NET or Entity Framework interfaces. It allows you to easily integrate Salesforce Marketing Cloud data into your .NET applications, and integrate Salesforce Marketing Cloud services with widely used data-oriented technologies.
The provider works with .NET Frameworks 4.5+, .NET Core 2.0+, .NET 5+. The product is compatible with ADO.NET Entity Framework (EF) Core.
It has the same standard ADO.NET classes as other standard ADO.NET providers: ExactTargetConnection, ExactTargetCommand, ExactTargetDataAdapter, ExactTargetDataReader, ExactTargetParameter, etc. This allows you quickly get started with it and eliminates the need to study any Salesforce Marketing Cloud data access specificities.
More information at dotConnect for Salesforce Marketing Cloud.
Compatibility
The following table show which version of this package to use with which version of frameworks.
| Frameworks | Version support |
|---|---|
| Entity Framework Core | 10 |
| .NET | 10 |
More information here
Installation
For projects, using Entity Framework Core 10 with Salesforce Marketing Cloud, install this package. Execute the following command in the Package Manager Console:
Install-Package Devart.Data.ExactTarget.EFCore
License
See pricing options for ordering.
The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial.
Usage
This snippet directly configures a ExactTargetConnection class for an Entity Framework Core DbContext using a connection string.
public class MyDbContext : DbContext {
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {
optionsBuilder.UseExactTarget(@"DefaultConnection": "Url=https://webservice.s7.exacttarget.com/Service.asmx;User=MyCompanyAdmin;Password=mypassword;");
}
}
Configuration Using ExactTargetConnection Instance
using Devart.Data.ExactTarget;
...
public class MyDbContext : DbContext {
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {
var connection = new ExactTargetConnection();
connection.Url = "https://webservice.s7.exacttarget.com/Service.asmx";
connection.User = "MyCompanyAdmin";
connection.Password = "mypassword";
optionsBuilder.UseExactTarget(connection);
}
}
ASP.NET Core and Blazor
Configuration File (appsettings.json):
{
"ConnectionStrings": {
"DefaultConnection": "Url=https://webservice.s7.exacttarget.com/Service.asmx;User=MyCompanyAdmin;Password=mypassword;"
}
}
DbContext Configuration:
public class MyDbContext : DbContext {
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {
IConfigurationBuilder builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");
IConfiguration configuration = builder.Build();
optionsBuilder.UseExactTarget(configuration.GetConnectionString("DefaultConnection"));
}
}
Key Features
- Easy Connection: Allows your .NET application to work with Salesforce Marketing Cloud data.
- SQL Engine: No need to study and use complex Salesforce Marketing Cloud API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with Salesforce Marketing Cloud API.
- Support and Updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.