combit List & Label 30 - .NET Help
combit.Reporting.DataProviders Namespace / InMemoryDataProvider Class
Members Example


InMemoryDataProvider Class

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.

Object Model
InMemoryDataProvider Class
Syntax
Example
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;
Inheritance Hierarchy

System.Object
   combit.Reporting.DataProviders.DbConnectionDataProvider
      combit.Reporting.DataProviders.SQLiteConnectionDataProvider
         combit.Reporting.DataProviders.InMemoryDataProvider

Requirements

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

See Also