>Is it worth using the RI builder and setting up RI between tables in the DBC or just manage that in code.

Yeah, I use it, and it works well. You may want to also look at Steve Sawyer's custom RI.