combit.ListLabel31.CrossPlatform.OleDbConnectionDataProvider 31.1.0

combit List & Label 31 Cross Platform OLE DB Data Provider

This package is required to connect List & Label Cross Platform (LLCP), a fully managed, cross-platform .NET reporting engine, to OLE DB data sources.

LLCP allows you to design, generate, export and print reports using a single API across Windows, Linux and macOS, without requiring any native components.

For a general product overview and supported scenarios please visit the List & Label Cross Platform product page.

Key features

• Fully managed .NET implementation (no native dependencies)
• Cross-platform: Windows, Linux, macOS
• Suitable for desktop, server, container and cloud scenarios
• JSON-based project files
• Report export (e.g. PDF)

Getting started

We recommend to download the fully functional free 30-day trial version from our website.

Usage

// Create an OLE DB connection using a provider-specific connection string.
// Example for Microsoft Access:
using OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Data\database.accdb;");

// Create an instance of the OleDbConnectionDataProvider with a specified identifier delimiter format.
// For Access and SQL Server, use "[{0}]"; for other databases, adjust accordingly.
OleDbConnectionDataProvider provider = new OleDbConnectionDataProvider(connection, "[{0}]");

// Optional: Enable Microsoft Access SQL syntax if connecting to Access database.
// provider.UseMsAccessSqlSyntax = true;

// Create a ListLabel reporting engine instance and assign the provider as the data source.
using ListLabel listLabel = new ListLabel();
listLabel.DataSource = provider;

// Configure export settings to generate a PDF.
ExportConfiguration exportConfiguration = new ExportConfiguration(LlExportTarget.Pdf, exportFilePath, projectFilePath);
exportConfiguration.ShowResult = true;

// Export the report to PDF.
listLabel.Export(exportConfiguration);

Documentation

The official documentation with API reference, concepts and guides is available on our documentation portal. You can find detailed information about this data provider on the dedicated OleDbConnectionDataProvider page.

Related packages

List & Label Cross Platform uses separate NuGet packages for data access. Depending on your data source, you may also need one or more of the following packages.

• combit.ListLabel31.CrossPlatform.CassandraDataProvider
• combit.ListLabel31.CrossPlatform.CosmosDBDataProvider
• combit.ListLabel31.CrossPlatform.FirebirdConnectionDataProvider
• combit.ListLabel31.CrossPlatform.MongoDBDataProvider
• combit.ListLabel31.CrossPlatform.MySqlConnectionDataProvider
• combit.ListLabel31.CrossPlatform.NpgsqlConnectionDataProvider
• combit.ListLabel31.CrossPlatform.NuoDbConnectionDataProvider
• combit.ListLabel31.CrossPlatform.OdbcConnectionDataProvider
• combit.ListLabel31.CrossPlatform.OpenXmlXlsDataProvider
• combit.ListLabel31.CrossPlatform.RedisDataProvider
• combit.ListLabel31.CrossPlatform.SalesforceDataProvider
• combit.ListLabel31.CrossPlatform.SchemaAwareJsonDataProvider
• combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider
• combit.ListLabel31.ProjectConverter

Refer to the documentation for details on configuring and using these data providers.

Feedback

Please contact us at nuget@combit.com with any feedback.