dotConnect for BigCommerce is an ADO.NET provider for working with BigCommerce data through the standard ADO.NET interfaces. It allows you to easily integrate BigCommerce data into your .NET applications, and integrate BigCommerce 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: BigcommerceConnection, BigcommerceCommand, BigcommerceDataAdapter, BigcommerceDataReader, BigcommerceParameter, etc. This allows you quickly get started with it and eliminates the need to study any BigCommerce data access specificities. More information at https://www.devart.com/dotconnect/bigcommerce/ License See pricing options for ordering https://www.devart.com/dotconnect/bigcommerce/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 BigCommerce data. * SQL Engine: No need to study and use complex BigCommerce API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with BigCommerce 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.BigcommerceReadme
dotConnect for BigCommerce
dotConnect for BigCommerce is an ADO.NET provider for working with BigCommerce data through the standard ADO.NET interfaces. It allows you to easily integrate BigCommerce data into your .NET applications, and integrate BigCommerce 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: BigcommerceConnection, BigcommerceCommand, BigcommerceDataAdapter, BigcommerceDataReader, BigcommerceParameter, etc. This allows you quickly get started with it and eliminates the need to study any BigCommerce data access specificities.
More information at dotConnect for BigCommerce.
Compatibility
The following table show which version of this package to use with which version of frameworks.
| Frameworks | Version support |
|---|---|
| .NET | 10, 9, 8, 7, 6, 5 |
| .NET Core | 3, 2 |
| .NET Framework | 4.8, 4.7, 4.6.2, 4.6.1 |
More information here
Installation
For projects, using general ADO.NET functionality of dotConnect for BigCommerce, you need to install the Devart.Data.BigCommerce package. Execute the following command in the Package Manager Console:
Install-Package Devart.Data.Bigcommerce
For projects, using Entity Framework Core 3, 5, 6, 7, 8, 9, 10 with BigCommerce, install the Devart.Data.Bigcommerce.EFCore package.
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
In this example, a new instance of the BigcommerceConnection class (part of the Devart.Data.Bigcommerce namespace) is created.
BigcommerceConnection.ConnectionString = "Server=https://bigcommerce-store.mybigcommerce.com/api/v2/;UserId=User;AuthenticationToken=qweASDzcx1234567890rtyuiqweASDzcx1234567;";
ASP.NET Core and Blazor
Configuration File Snippet (appsettings.json):
{
"ConnectionStrings": {
"DefaultConnection": "Server=https://bigcommerce-store.mybigcommerce.com/api/v2/;UserId=User;AuthenticationToken=qweASDzcx1234567890rtyuiqweASDzcx1234567;"
}
}
Dependency Injection of IConfiguration:
private readonly IConfiguration configuration;
public YourController(IConfiguration config)
{
configuration = config;
}
Retrieving a Connection String:
var connectionString = configuration.GetConnectionString("DefaultConnection");
var connection = new BigcommerceConnection(connectionString);
Key Features
- Easy Connection: Allows your .NET application to work with BigCommerce data.
- SQL Engine: No need to study and use complex BigCommerce API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with BigCommerce API.
- ASP.NET Core: Supports ASP.NET Core Identity.
- Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.