I tried the WD40 silicone spray for a while. I saw evidence through tests and videos that WD-40 is a long term corrosive. I don't want that WD blended silicone oil in my barrels or on my guns.
Now I use the pure Super Lube silicone oil. I spray a good shot of it around on the foam in a pellet tin and then roll the slugs or pellets that I want to shoot in that tin so it coats them good. Then load them wet in the magazine. When the foam and rolling pellets and slugs gets a little bit dry looking, the foam gets flipped over or another shot of lube from the bottle. There is no mess, or smells, zero lead fouling, and very consistent shot to shot accuracy. There have been good reports about using Pledge, and Ballistol may work the same, but I have not tried that. I use Ballistol to wipe down the guns before putting them away.