combit List & Label 25 - .NET Online Web Help
InMemoryDataProvider Class
Members  Example 


combit.ListLabel25.DataProviders Namespace : 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.ListLabel25.DataProviders.DbConnectionDataProvider
      combit.ListLabel25.DataProviders.SQLiteConnectionDataProvider
         combit.ListLabel25.DataProviders.InMemoryDataProvider

Requirements

Platforms: Windows 7 SP1 - Windows 10 Version 1909, Windows Server 2008 R2 - 2019

See Also

Reference

InMemoryDataProvider Members
combit.ListLabel25.DataProviders Namespace