How do I embed the Connection Manager inside the C# code of the SSIS Script Component?

When I open a Script component, I can choose a Connection Manager from a dropdown list:

This Connection Manager has it all, if I had it as an object in the C# code, I would not need to write a hardcoded connection string anymore.

I tried it with an OLEDB provider and SQL but failed.

Question(s)

• How should I use an OLE DB Connection Manager in a Script Component of an SSIS Data Flow Task?
• Or if an OLE DB provider cannot be used, how can I embed the Connection Manager in an SSIS Script Component instead?

This is well documented on MSDN, covering both VB and C# type of scripts: http://msdn.microsoft.com/en-us/library/ms136018.aspx