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


combit.ListLabel24.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.ListLabel24.DataProviders.DbConnectionDataProvider
      combit.ListLabel24.DataProviders.SQLiteConnectionDataProvider
         combit.ListLabel24.DataProviders.InMemoryDataProvider

Requirements

Platforms: Windows Vista - Windows 10 Version 1809, Windows Server 2008 - 2016

See Also

Reference

InMemoryDataProvider Members
combit.ListLabel24.DataProviders Namespace