combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider
31.1.0
dotnet add package combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider --version 31.1.0
NuGet\Install-Package combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider -Version 31.1.0
<PackageReference Include="combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider" Version="31.1.0" />
<PackageVersion Include="combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider" Version="31.1.0" />
<PackageReference Include="combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider" />
paket add combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider --version 31.1.0
#r "nuget: combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider, 31.1.0"
#:package combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider@31.1.0
#addin nuget:?package=combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider&version=31.1.0
#tool nuget:?package=combit.ListLabel31.CrossPlatform.SqlConnectionDataProvider&version=31.1.0
combit List & Label 31 Cross Platform SQL/Azure SQL Data Provider
This package is required to connect List & Label Cross Platform (LLCP), a fully managed, cross-platform .NET reporting engine, to SQL/Azure SQL 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 a SQL Server connection using your connection string.
using SqlConnection connection = new SqlConnection("Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;");
// Create an instance of the SqlConnectionDataProvider.
SqlConnectionDataProvider provider = new SqlConnectionDataProvider(connection);
// Optional: Filter by specific schema(s).
// SqlConnectionDataProvider provider = new SqlConnectionDataProvider(connection, "dbo");
// 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 SqlConnectionDataProvider 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.CassandraDataProvidercombit.ListLabel31.CrossPlatform.CosmosDBDataProvidercombit.ListLabel31.CrossPlatform.FirebirdConnectionDataProvidercombit.ListLabel31.CrossPlatform.MongoDBDataProvidercombit.ListLabel31.CrossPlatform.MySqlConnectionDataProvidercombit.ListLabel31.CrossPlatform.NpgsqlConnectionDataProvidercombit.ListLabel31.CrossPlatform.NuoDbConnectionDataProvidercombit.ListLabel31.CrossPlatform.OdbcConnectionDataProvidercombit.ListLabel31.CrossPlatform.OleDbConnectionDataProvidercombit.ListLabel31.CrossPlatform.OpenXmlXlsDataProvidercombit.ListLabel31.CrossPlatform.RedisDataProvidercombit.ListLabel31.CrossPlatform.SalesforceDataProvidercombit.ListLabel31.CrossPlatform.SchemaAwareJsonDataProvidercombit.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.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- combit.ListLabel31.CrossPlatform (>= 31.1.0)
- Microsoft.Data.SqlClient (>= 6.0.2)
-
net8.0
- combit.ListLabel31.CrossPlatform (>= 31.1.0)
- Microsoft.Data.SqlClient (>= 6.0.2)
GitHub repositories
This package is not used by any popular GitHub repositories.