TransformationNodeBuilder.Build() Method
In This Article
Builds a transformation node.
Namespace: DevExpress.DataAccess.DataFederation
Assembly: DevExpress.DataAccess.v24.2.dll
NuGet Package: DevExpress.DataAccess
#Declaration
public TransformationNode Build()
#Returns
Type | Description |
---|---|
Transformation |
A transformation node. |
#Example
The following example demonstrates how to unfold and flatten the Products array of two data sources and unite data from these sources.
Show JSON Data (Products1.json)
[
{
"CategoryID": 1,
"Products":
[
{
"ProductName": "Chai",
"UnitPrice": 18
},
{
"ProductName": "Chang",
"UnitPrice": 19
}
]
},
{
"CategoryID": 2,
"Products":
[
{
"ProductName": "Ikura",
"UnitPrice": 31
},
{
"ProductName": "Konbu",
"UnitPrice": 6
}
]
}
]
Show JSON Data (Products2.json)
[
{
"CategoryID": 1,
"Products":
[
{
"ProductName": "Chai",
"UnitPrice": 18
},
{
"ProductName": "Chang",
"UnitPrice": 19
}
]
},
{
"CategoryID": 2,
"Products":
[
{
"ProductName": "Ikura",
"UnitPrice": 31
},
{
"ProductName": "Konbu",
"UnitPrice": 6
}
]
}
]
using DevExpress.DataAccess.DataFederation;
using DevExpress.DataAccess.Json;
// ...
var source1 = new Source("Products1", jsonDataSource1);
var source2 = new Source("Products2", jsonDataSource2);
var query1 = source1
.Transform()
.TransformColumn("Products")
.Build();
var query2 = source2
.Transform()
.TransformColumn("Products")
.Build();
var query = query1
.Union(query2)
.Build("ProductsUnited");
var federation = new FederationDataSource() {
Queries = { query }
};
The following schema is the result of the transformation:
"CategoryID": int
"Products_ProductName": string
"Products_UnitPrice" : string
See Also