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); }