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


In This Topic
    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
    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 8.1, Windows 10 (Version 20H2 - 21H2), Windows 11 (21H2), Windows Server 2012 - 2022

    See Also