InMemoryDataProvider Class

In This Topic

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

Syntax

Visual Basic
C#
C++/CLI

'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

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

Reference

InMemoryDataProvider Members
combit.Reporting.DataProviders Namespace

Send Feedback