Skip to main content

FederationDataSource.FillAsync() Method

Populates the FederationDataSource in an asynchronous manner.

Namespace: DevExpress.DataAccess.DataFederation

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

public Task FillAsync()

Returns

Type Description
Task

A task that populates the data source.

Remarks

Use this method to populate a federated data source in an individual task asynchronously. Unlike the Fill() method call, FillAsync does not lock other actions performed concurrently. For instance, the user interface remains operational while the data source is populated.

Call the FillAsync method with the await operator.

Example

The code sample below creates a federated data source and populates it in an asynchronous manner.

using DevExpress.DataAccess;
using DevExpress.DataAccess.Sql;
using DevExpress.DataAccess.Excel;
using DevExpress.DataAccess.DataFederation;
using DevExpress.DataAccess.ObjectBinding;
using DevExpress.DataAccess.ConnectionParameters;
using System.IO;
using System.Threading;
// Creates and configures an SQL data source.
SqlDataSource sqlDataSource = new SqlDataSource(
    new Access97ConnectionParameters(
        Path.Combine(Path.GetDirectoryName(typeof(ReportCreator).Assembly.Location),
        "Data/nwind.mdb"), "", ""))
{ Name = "Sql_Categories" };
var categoriesQuery = SelectQueryFluentBuilder
    .AddTable("Categories")
    .SelectAllColumnsFromTable()
    .Filter("CategoryID=?Category")
    .Build("Categories");
sqlDataSource.Queries.Add(categoriesQuery);
sqlDataSource.RebuildResultSchema();

// Creates and configures an Excel data source.
ExcelDataSource excelDataSource = new ExcelDataSource() { Name = "Excel_Products" };
excelDataSource.FileName = "Products.xlsx";
excelDataSource.SourceOptions = new ExcelSourceOptions()
{
    ImportSettings = new ExcelWorksheetSettings("Sheet"),
};
excelDataSource.RebuildResultSchema();

// Creates and configures a federated data source.
FederationDataSource federationDataSource = new FederationDataSource();

Source sourceCategories = new Source(sqlDataSource.Name, sqlDataSource, "Categories");
Source sourceProducts = new Source(excelDataSource.Name, excelDataSource, "Products");

SelectNode selectNode = sourceCategories.From().Select("CategoryName")
    .Join(sourceProducts, "[Excel_Products.CategoryID] = [Sql_Categories.CategoryID]")
    .Select("CategoryID", "ProductName", "UnitPrice")
    .Build("CategoriesProducts");

federationDataSource.Queries.Add(selectNode);
// Populates the data source's CategoriesProducts query.
await federationDataSource.FillAsync();
See Also