I find it best to approach the studio with an open mind re. what may or may not work. Every situation is different.
Bring your best equipment (basses, amps, preamps, effects, etc), and set it up in a way that makes sense and sounds good in the context of the particular project you're working on. Maybe it's the bass you use live, or maybe it's the bass that feels most comfortable in your hands... doesn't really matter. Try a few takes, and see how it sounds. This is your starting point.
If the producer/engineer thinks it'll work, YAY! Run with it!
If the producer/engineer thinks it sounds like garbage in the context of the project, and wants you to try something completely different, then cool! Run with it! Make suggestions or compromises if you have to, but work together to find something that will work.
Each producer is different in terms of the sounds they prefer, mixing style, etc, but they should hopefully have the best interest of the project in mind when making these decisions. But that same "project first" expectation extends to you... If that means trying a take with the crusty old P bass in the corner, plugging into a little Pignose guitar amp, or bypassing your $5000 amp rig and plugging direct into the ProTools interface, then at least be open to trying it once. By all means, don't compromise your artistic vision if you abosultely must play your Stingray 5'er through your ABC amp rig with XYZ mics to achieve your end goal, and don't waste time/money trying anything and everything under the sun chasing that last 5%, but it is the producer's job to ensure that you maximize your results, and they (hopefully) should have a pretty good idea of types of tones will or will not work on a record.
It's a team effort between you, your band, whatever management, and the producer, to produce the best possible results within your budget. Hopefully you can trust the opinion and expertise of everyone involved in their respective rolls.