static void LoadListOfValues(Dictionary <string, PIMListOfValue> lovs, Dictionary <string, PIMAttribute> attributes, List <PIMProduct> pimProds) { PIMServices ps = new PIMServices(); // Identify all attributes with list of values var qryLovs = from lov in lovs where lov.Value != null select lov.Value; long lap = 0; Console.WriteLine("-- Importing Mapped List of Values"); lap = DateTime.Now.Ticks; ps.ImportLookupTablesMapped(qryLovs.ToDictionary(x => x.ID)); Console.WriteLine(string.Format("-- Time taken {0:N4} secs", new TimeSpan(DateTime.Now.Ticks - lap).TotalMilliseconds / 1000D)); Console.WriteLine("-- Importing Unmapped List of Values"); lap = DateTime.Now.Ticks; ps.ImportProductSpecificationLabelAndKeyLookup(attributes); Console.WriteLine(string.Format("-- Time taken {0:N4} secs", new TimeSpan(DateTime.Now.Ticks - lap).TotalMilliseconds / 1000D)); Console.WriteLine("-- Importing Custom List Of Values"); lap = DateTime.Now.Ticks; ps.ImportLookupTablesCustom(pimProds); Console.WriteLine(string.Format("-- Time taken {0:N4} secs", new TimeSpan(DateTime.Now.Ticks - lap).TotalMilliseconds / 1000D)); }