👁 Image
combit.ListLabel31.CrossPlatform.OdbcConnectionDataProvider 31.2.0

combit List & Label 31 Cross Platform ODBC Data Provider

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

LLCP allows you to 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 ODBC connection using a DSN or connection string.
using OdbcConnection connection = new OdbcConnection("DSN=MyDataSource;UID=user;PWD=password");

// Create an instance of the OdbcConnectionDataProvider with specified identifier delimiter and parameter marker format.
// The first parameter is the connection, second is the identifier delimiter format (e.g., "[{0}]" for SQL Server),
// and third is the parameter marker format (e.g., "@{0}" for named parameters or "?" for positional parameters).
OdbcConnectionDataProvider provider = new OdbcConnectionDataProvider(connection, "[{0}]", "?");

// Optional: Disable relation discovery for better performance if relations are not needed.
// provider.DisableRelations = 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 OdbcConnectionDataProvider page.

Related packages

List & Label Cross Platform uses separate NuGet packages for data access, export etc. Depending on your needs, you may need one or more of these packages.

Data access

• 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.OleDbConnectionDataProvider
• combit.ListLabel31.CrossPlatform.OpenXmlXlsDataProvider
• combit.ListLabel31.CrossPlatform.RedisDataProvider
• combit.ListLabel31.CrossPlatform.SalesforceDataProvider
• combit.ListLabel31.CrossPlatform.SchemaAwareJsonDataProvider
• combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider

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

Export

• combit.ListLabel31.CrossPlatform.Export.OpenXml

Miscellaneous

• combit.ListLabel31.CrossPlatform.Object.Chart
• combit.ListLabel31.CrossPlatform.Printing.Pdf
• combit.ListLabel31.ProjectConverter

Feedback

Please contact us at with any feedback.