public void LookupEasy(LibCF.DataFlow dataFlow, LibDF.OutputWrapper output, Lib.ConnectionManager connection)
{
LibDF.Lookup Lookup = new LibDF.Lookup("Lookup Easy", connection, "SQL")
.AddComponent(dataFlow);
new LibDF.Path(output, Lookup.DefaultInput).Connect(dataFlow);
Lookup.AddReadOnlyInputColumn("ColumnName")
.AddLookupMapping(new LibDF.LookupMapping("inputColumn", "lookupColumn"));
}
public void LookupAdvanced(LibCF.DataFlow dataFlow, LibDF.OutputWrapper output, Lib.ConnectionManager connection)
{
LibDF.Lookup lkp = new LibDF.Lookup(
"Lookup", connection, "LOOKUP SQL",
LibDF.NoMatchBehaviour.RedirectRowsToNoMatchOutput,
LibDF.CacheType.Partial)
.AddComponent(dataFlow);
new LibDF.Path(output, lkp.DefaultInput).Connect(dataFlow);
lkp.AddReadOnlyInputColumn("inputColumn");
lkp.AddLookupMapping(new LibDF.LookupMapping("inputColumn", "lookupColumn"));
LibDF.LookupAdvancedParameters advPars = new LibDF.LookupAdvancedParameters("select Advanced SQL Query");
advPars.AddParameter("Parameter");
lkp.SetAdvancedParameters(advPars);
}