Well, if it was Oracle you'd add a reference to your project that includes Oracle.DataAccess, include the ODP.Net namespaces, then just use the functionality in your code.
You could also have a look at the provided examples, for example in a 10.2.0 machine I have handy, they're in C:\oracle\product\10.2.0\db_1\odp.net\samples