
This data provider can be used to wrap existing datasources in an In-Memory SQLite database. Besides the performance gains (depending on the original data source) this also is a way to circumvent restrictions of the other providers. For example, by wrapping a CSV data provider into an in-memory database you get features like sorting, filtering etc. that are not available for a "pure" CSV data source. This also allows to define relations between different providers, e.g. a relation between a CSV file and an Excel data source.
'Declaration
Public NotInheritable Class InMemoryDataProvider Inherits SQLiteConnectionDataProvider Implements ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger
public sealed class InMemoryDataProvider : SQLiteConnectionDataProvider, ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger
public ref class InMemoryDataProvider sealed : public SQLiteConnectionDataProvider, ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger
CsvDataProvider csv = new CsvDataProvider(@"D:\datasources\customer.txt", true, "Customers", ','); XlsDataProvider xls = new XlsDataProvider(@"D:\datasources\Orders.xlsx", true); InMemoryDataProvider inmem = new InMemoryDataProvider(); inmem.AddTable(csv, "Customers"); inmem.AddTable(xls, "Orders"); inmem.AddRelation("Customers", "Orders", "CustomerID", "CustomerID"); LL.DataSource = inmem;
System.Object
combit.Reporting.DataProviders.DbConnectionDataProvider
combit.Reporting.DataProviders.SQLiteConnectionDataProvider
combit.Reporting.DataProviders.InMemoryDataProvider
Platforms: Windows 10 (Version 21H2 - 23H2), Windows 11 (21H2 - 22H2), Windows Server 2016 - 2022
.NET: .NET Framework 4.8, .NET 6, .NET 8, .NET 9