private List <ProductInformation> GetProductInformationData(int vendorID) { try { using (var db = new PetaPoco.Database(Environments.Current.Connection, "System.Data.SqlClient")) { db.CommandTimeout = 600; //10 minutes var products = db.Fetch <ProductInformation>(string.Format(QueryHelper.GetProductInformationQuery(), vendorID, VendorSettingsHelper.ExportOnlyProductsOlderThanXXXMinutes(vendorID))); return(products); } } catch (Exception ex) { log.Error("Error while retrieving products to export to Wehkamp.", ex); return(null); } }