1，什么是ODT？就是Oracle 为 .NET (ODP.NET) 专门编写了 Oracle Data Provider，一个用于 Microsoft .NET 环境下的 Oracle 数据访问 API 。
详细解说 http://www.oracle.com/technetwork/cn/testcontent/o23odp-084525-zhs.html 对于官方的代码，已不存在了！
ODP.NET你不需要安装Oracle，不需要配置oracle.key文件，不需要配置TnsNames.Ora文件 不需要配置环境变量；完全的傻瓜式的在没有安装oracle数据库或者
客户端等任何oracle的产品的机器去访问Oracle数据库！
下面详细解说ODP.NET如何对Oracle的数据操作【可以完成建表，CURD( 增删查改)】
步骤一：获取支持数据库连接的类库文件：Oracle.DataAccess.dll 如何获取呢？
到官网去相应的版本http://www.oracle.com/technetwork/cn/topics/dotnet/index-088718-zhs.html
下载后安装后会在你的安装目录\DP.NET\BIN\2.X(图1)下出现这个Oracle.DataAccess.dll，把它复制到你的解决方案下 引用一下
图1
顺便点击一下Oraprovcfg.exe 自动配置了环境变量(图2）
图2
成功获取所要的dll文件，有些人还要去一个文件的去解压，去配置，我看不需要，如需要的话这个是详细的配置步骤
http://blog.csdn.net/Sunlihgt_love/article/details/5423926
在引用dll库后，可能会引发下列异常：
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAk0AAABbCAIAAADhiCagAAAgAElEQVR4nO1dS47qyBK9K8FrAXkf9sTLgBGLgDdkCbAANlBC6nHNe3qlHlzpTfq9Qf7im5k2VNm4Ah21blMmf86Mk5GfOL9+//7n4/FpMBgMBsMq8UvkuT/gM3sRDQaDwWCYDJXn/v2r+fevxnjOYDAYDG8Ngef+/Pnz37//87+PX//7+PXfv/9jVGcwGAyG94XMc//+1Tie+2KX7tI1TXcG35yHzWazPdzpk+eh6S/lBN1j56FphpP01w37+GSlP202m6Zp97eYwn2/y/xv/BJmzX/SxMS7nmYassOPnT+vhzY9szteQ/qnHiQOqpCqfztu4/Pw3++F23Gbefvs3aX+cx7iv2EbsmaXesv34dLNXIB14XbcNnxgGn40KM9BZ67WpTsPzhxX5+rtODfrlMwivVXyXDSI4R+nHhFGyJ2ZFTl9zFLE2orGl34pcWF8JmR6PbTdGT6cSuj+dD20wV5fut3xyqy2Z3efNagg4LZT3wgTCAWOQQOP3ve7phFsx6VrGsC7l65pYFPHQobaNaSTnPqmO/v/5jtYfcnRw5jn0vfoNUn9QW2K8PNQU6lZxqKS59Ds53XcfN/vmqrB9WU49bQA10PbTJ6TfQXPgTcu91XRBvIvp6Xj4cfXK7rcj4PAc86Zc5+SS3ff75pmN3TMhGWRd3pQ4j5Zhecyk/TEmtHWg05GjUWR55C31O5v2MdqpMd2x2uJ55hjMcqfC/bRJUh5DswemnZ/pnXXh9NnYFPPqa48211LyMaVKpQHuubp/QJy5TwXy1kw2TlXjFvDF/McaYrPj/OADM3tuG1GdX4pi2qeSxmVJ5fCxELA7bjdtdt5HUq6AFNX8u8DePu3I2sr0QaKX05IB/3Vd2BtvcqgA/EcdOYiz1W4dGP7JTbBN4XnlLVEyCvBEwrQfKzIc8gsAgNXXLdMFtOVFnRZsH6YZv2+JL6mciFVfw4hGOhLh+dxyXCH1VpQbMDfzkyzOSBtOtzyzEFsugMZmff9rt0fhkZu29gyOs+5dsivSYZEigYdvrVXrlvSpmAr7Y/n7c4knnuItjL7vATXi8ou9dcCt2qhXvOiYlJe9QpGpUPaZGnzgDcA5bm4Mwd5rrRLN4Hn4nzf8Rx2s3bHK5km6/4czjfSD7AdjOcCQyCeK/pzkOe6HuXr6Q0umPjnXQpupna8gnXUpmn3B9mfyzuprn32nj/8UkZ3/mT+nCsYXFf8vB7aWM0xps2/X7Ty6Rj0PEj+HGyZjD9XC7RmKADzxKvXLRFSfUkBkiPencFyrrxOlRZ4w0uMBSB/yo8y8A3NKKWTLUno4bRevBg136SuG4mff6O84rR0CXuplAttZJoFogTQDujLNPoyMyFptVyblIzluVHpUAM1ag/C8AF5juzMQZ4ruXTP8xzdl6JWuGLdsgHrS9SovYLnOBvFEjpDfD20Xe8N6/UwhBol1zOto9b6c5euadx0O7+DguqLf75Ju55oaJXIQ3q/yXEB34AFPW7OXsFzdBqE33j2fA3mOeQxvJLnYtXcRiaYd/dwtdN9798pfk3xT/GlZFmN5ytkBJ8XH4DVgVmLJeTfsKJyP6zeM0tPwmKLDYIbOZcpLjZ+BWkwjtnu0glmHM+NTIdwv/HcaCCei84c57niLt0r1i2xxcmsW4KzFWk+6/fDhhPp+hLPhQEzed0S5R7YejgJO1v6/lwA8UqBzye3hvPntMbxz/SX66Hd9sN2d7yeB7fJ150jAU/iubhJEO0js/t+0w54jc/7czLia+XbnLF5X37eUuU56M+hv1JvQ0gh8Fzm4KjcgKh3Mc+JPs9dK2gu0795CaVvpKJeuoacV+LflPoYHLxyLqReLIuYAi12/CGhz9qBkJ1ujuC58emYP/csPM/xY5Ycukv3pD8X57P6zLrobwWr50hCPOPkjX4y8dPXLcEgGU6YM5xXB05kqDwnWt5IJ+gberwFJXjq265v+TmR0+F4hRyPVzUn8Zy3HfuMTXx8wjXM53gu68lpbpyybolWCCb7c4X9OVzH23Eb/QnV+H5CnsseMmQNeB7gmiTNiK1qsgfSml6BiWu+weVkF3LKbOdcFuS4FLxnJdMcz7kyyDyXX7csranU8tykdEhdbH9uNBLPQWeO+3NZl25kuxMLJR6IJ5B5CCzEhQdAN7p0we/hV/ToqJvIc+yxBzmPp/AcnoGyXcY7uVcAcifnX3zt3LqlG6iU48V7CLvjfhrP+ekzW/hCzJHsyBf6c/pStsRzuGtN57nP66HVz1viOgLbdD20cNEsNuYe7c8hEj31cbdJchZhN5MzorMT+gA9PhNzF0uY+SYVdU/agX+Tadvbcdu02x11B2kubDLBM1XXLYVF2hp/LixjsNISLi/x3Ph0xLdfmA8ZBPz6/fsf0ZnjPCe5dHTGXWPI8GaS4B4JvxKNGj5n6A5KpIO50kE+Ym7gzFH2G8QLA3Rmmug2zEb5fgZqLr60xfdd8v4ccVthk7o/0TsVQknqjTsae9qMG1Kpe5jfnyO1eKbjKluS2G+LPEdMwxM8538u358T7Jr3DPphi7aUmuQ/kTNT5LQItnRKA8oZgYsfwgPcsUjf0BLmvoH9MC25g4Vr9E1ux+4ej2uJTS1PJgpZ6OdQ6nkOGwfgNQrvReztfBTXpgNZUH4Fiz2Yuix4niPOnIaXhEcJ8zLfhzDnpZ2DTfbDPRIwbn2PQXYQLt0EJJM9xZ8DQyi4kjB9vgyCsmCX+WK9rtX+HMxLXq+nPEfL/F6AvQL5IpB48FKBaxZ6rCleaXCGw2bH34bKgA8Ga8yXQvXnRm7RGQwGQwG5W5sGa8wvQ9qfq/zMXmKDwWAwGOoh6/IYDAaDwbAOGM8ZDAaDYc0wnjMYDAbDmmE8ZzAYDIY1Y/k8t1YVylfVS7uBC1R7FiFYtYQgDl9XBvlmpMFgWAJm5LnKu1w/k+fYVfHsk5N5jkbDakZIbvI7jlMCGr0EYjD+dK82ExxZSAdFANfVBuAFPhJmtzYpoYRVZdMjVAllG1M1g2GdmInniEpkTjAaRr+c3SHIYGzxijwH4yBk7GCJ57IAPCcL6zxdkcntM6oADYseAr5MwVDyZbjvd+02RWYSk0WhDKRw1UpSgsCmWMLKsgGggJZC2arLYzCsFrPw3CiT+uN5rhCe/CU8pwUqe74ik9tnVAGgpgwXVMvpCURExVHAcyxZ+BOQBQ+Fg5OS3qxcwsqyoT/JIfGw7mC5PK9/LwbDUjAHz2mzVzi1RNPe4UR0I+Un71TlMisFKa35COqLQiJC7kTWkpVEWCYaz3OlWsvpK+H+QEAsKbwsfRI/g94gr4gYVJCGz4cK3TUvIhNO/npoY7NLAS1j1lpbIb2LXLIA8UmqoyQlhRuHR9OnkbJpf1MTlAiYPFlZHoNhvXgXnvtkhlK2+Hq01qIzIaovlvQkZX1IUhJNb3PkumVNrXn6Wvj2x+dHDPosKMWwWmP3Be9X0bD3krglSEf2k2IDTpDB9NuZJMpwXBXcgOi6Ululd4fJgCX7SFMWEkqYyzKIvJK+lEvI31E2QR6fmpatujwGw3qxNp6De37a9F+BFMVcTKSO57goAXZxas+hNChgeanWiC0wz0nN7hjr1Dck/LHUdLF9OLGhwNyKuOV9v2u6HmvBFDL6RHxf8+IgL4bEQchvua3g0p+8binRLWy0+CslKfATuMbISyjp1mZ3AVW56iboMY0oj8GwUsy1PycZr1fznMimhXVLxnNCImN5TlW5rF23rM73cxrPeUenoG+ZVO6wcSzyXOKYZtciwlBlWsfIYOJElMW9TFtRPZSNOzhalSyR2VOSCinopKJJreYSzB4hcWWbXB6DYVWY57wlFat05y3BrBkLxYk8x58kVkwUacxANK956Ustd5VxpXqJ0HhOzjcaLCF98YCfV8uk5y3hnpnQdLfjdjd0tGCldUty1hEJk4oZjfTnkLMlHHEii4pSW0kPi8kC4bqwe0eyUPPNLCdgJ5K+I+kxKVOlbBPKYzCsDPPdn4PaoWB8+ql6kotEKqabsJkkPcmWccZdElLMq5SIlDuVtSzpbYrnROBPBPuu1roPK2Boe5Klz6Qa2U5b5uCMf17azBt5DgWKkssndEatWwoSr6jN8X6b1FaoguLJF/7q4c8LPCcKbMollOQ0xVykpVSxbLXlsQsGhvVi+fFQ1o63Eku0YwurxVv1Q4NhFIznZsY7iSXalH+9eKd+aDCMhPGcoQruBoKZQoPB8HYwnjMYDAbDmmE8ZzAYDIY1w3jOYDAYDGuG8ZzBYDAY1gzjuS+FFPllKcKnbw1yr068Zpd0apSfAIW/nkYg47fc3DEceKkOB0xBcQ9AOvCWPVDDKQjxvDF45Bratv1FDPUCPy4cHfvhUYiHVwRrbVnk4fGJoyXQuxbfWK9CIpt055iFXkqBYYWYcDRAR6lqMBgs/r7d38jtWxipQArEM+tRbeO5euDgWFV4U57jNXURkHmxoToE6txCtz4rF7SxBGgMuVkQRIXFI/8rf6mEmHHPBIsWjtfDcGUpDoDjOaLiRmyEjxmWBrzAc6OuIToGRTy6/BdEf56bhcQrDeLdhlPfdGcgmIebpbINwVuTO4MP8kAqnr9TOEu9MGeHh2FQCDEyuy9GszteJaPE2ofWRSibdMtosbdTjOeqcTtud+3IC2RKJE+PCZJs3yLCJ9T0vt812x0dDDBCjRhHuxhulEmAuqFFBxgC8pba/Q37WCyOcyhhgefY9HOUPwcMjcBzOCr3OYWAgSmrXcjZJqJLsOQXhKEE0qzgg2wo9lE852rR9YrXQiclgjsiEtUM9cKzJVoLOLfD8zxUWsbQZX/u8flxHmDgXCF3XP1FwXiuFlGscqSY6vvxnFTT+37XdIcjs63t/qCrdaNg03I7UAlQNzhF/ywiqc+7ZBEHRDOR7IVPzRsveaVF9eeE0vLXmqbDLh1x3dITiTybVt9pSJAsoC36BZHyy1PDKj5o+sup96/4hH2OkTyXB/Z0+6MvG+0V31ovYZ3gkV3xPg/dAbyXOEywOw6rDOPuqv6ca4QbmpxtD8du13awz4Mf8oVZzIUzYBaeuytyl+l7LpSKe5UozqlKqsbfSgEAM8EYyZqPKAOdV3ZFkqFAU21g0qxyFfCXx68Xm83XFC+4uQd4pGb6ov3g3PesdgUJUAWY57oeGRFvJrBATxAT8DsfTcg0vPf0jtKYZJ6iPHR3x70vvG9nr7HHprckNChRzBkzd1n8C4pwFnbXdmfOo7BlkmVnfHCMU5nTod0eLuP35zyHKXac6IrEQZTluW+pF+IeuPEGd3kbSM8XONg3YfkhzK4UUY7Qz7X3K/3Ja1/vA89BwWFAZvlZ/rdiNp7T5C4JA0mKnVyLsqSGSvsx/KEqCkp8dkAbKC+1wOEbKhkqS+qoiqOq5NiXiM3mahpUUnHha8woXCJLDJSeH8tznI2A6EH4ph+CJtwQsgNqD/Gl1Ppz/l0U5WwUk+ENDVCEgGGgx5iD5b8g3GKhSfERj8QHKFA7coDOg5/ShdbbHi6cRSobDdrimAusFNiiy/PcN9Wriufiv58MT3oT1tLDEMMOBpxa9X5/WjgIA8o/chr3JZjRn+P/S/cPZMVOvpGgynWSnXn2TV4UFMfph/vwXDxaSu1TDr0v8pxYBSHBKp4jezCsZXJvp1TTu5d0iWUrmFFBxs8lm5cAzYGuW/oUgkV2Tttwojtb2f25ADL1Bj4fmvQQf040EHDifD20237Y7o7X8+Bm2d05EvA4k/0GLyjkxUni1DcN9pmIQAR4icJxR8gH45D6THqtdEq6GzrfbYZO3Z/7vnpN8ediynGtUiew2IG1c7+In0he/gTWsL/hYZUGFGTEvAbZd+C9eE7RPlW30EO/RGwHvsmKgpIZHOoctcquI3hOqMIreG682GyppucBLNZlzWj8Ez0k1sCFGjRQa/qPxHPAvqR37bw6YKFUnhPXJ2OfRN/Q4y0owVPfdn3Lz4OcDsdrbAR0/JqWuYR3eEHYxRFW7fyxoGFPzvcDgfXrQ5ylQT4QDitW9JnIAcckDkXJRvPnvrVe5f057s+RjNio1xZveedHWUPG4uehpJPPYA4XZoqzqmHMt24pyF0K7CIpdnItSlkNdY+2/aRviqKg8Xu2Oyi5fWLB6nhOVRwlCRKee7XYbFVNL9BAZBsNrapJ+qWxYM/6c6BrYX89L2V3O26xi89OHLBjBSl3cv7FL4hF1fUNP/Mi2q/dcV/Pc2/wgiibKqds7mXPLO/3+Pa8C8eLlD6DT5+iRjj10iFSVIBvrpdCS5X+3IOtVYA/yQuJt2PHdH3ZY5jnyJHdlCk/e/Hac0OjMZ8/J8hd8nUV5RwK16KUdEH5VEKaXBRFQYUDxOEbVmBasDzP4WPforQpq+mXis1W1hRds8VmVJoD0nbmxXhyfw7nkhoq7sxnprGkMBLPFfw5ouQAzRPamVdPylVYxvd6QRjP8MEGf7aHS5qswJOo+fOft+O2abdlwd48z31vvTJ1gUzG/Dn43vl5IlBI2pGu58seH5VCPMfuiXe9n1ujs7iNduRnZixh3dJgGAPBnwOTlf7ywewyX5ZEg1zZw4jLUDX+HMxLHufU1tAyrxU6H+SWy/wWI7tNwUTey/5c8CTUHNW7XxN57iX1UpNl7BUPs9xhpwLp8LVuH81E7aiKoj0sM6kCXJawewXpnRnPGQwGg+EbYDxnMBgMhjXD4qEYDAaDYc0wnjMYDAbDmmE8ZzAYDIY1w3iuEpeOHhYacRxcw7x3SgwGg+EnYEae88FAlfgOGuhtXxgqXjgmi699hLvhU/iJH/+lx4XZw8U0qbZFukgXb9opcoViZR/0Nig718tlKnPHoBt4O4epwJCINqmRn9EsZVeLyEc+vqS0RnwLuiAA6U7SXXKlL4UmlWV9cMWr86pKJ95nkM+Lh8SZcMHba8zeQbwSUh00ovHok+ejC+sbioainj6MbpGJz87fBaw4f0wJHiTWPd/HloXZeK4Q3BOOlpxaJriIrfAcjdOjMUQZPm4pKIkQkk7sXldFv1j351K9XOi8PRMClhtQ0sjIyjneaayjNA/Q7emu5cHuXqJZyquTn7uE23JSM8KgVmy6gFRm4k+YrYFzBWACmN2UL1ppof/kvGrTqYl3tRaNWdYOIEEhdLI4rJT3tai+oXV1DfBhzHNCSExWMG0WnkxKTV+t6WOLwTw8V+7r8eWdh6YfBFEJLK3CP9Hv8VF0fXxx6r6Mvrqo3CnmYTVi+TcboqNYukaa0pHUNKAWwe541WaLWAWNJ168PLsBjeztVzBtTXDEpZA/wtxzlH+QmZPSPsOCDKW6u4BePlAIjw2WgvTDEl5FvVYYl1Jbeyjasmpt2Gw6qAFzI2glGrO8HUSRB8wut+N2dzxpwqFe0GpJfaPU7cXItxN5TgnoioQFXqhjvBjMwHNAryG3DgB4Tpk1kCDFuj+XeO5w3EbrPGICdZckrITVEq2n+t4QQnXAiGIkFCzjOeJjlTYFceCfsTKV8hpO5VriyzVLH/oYfqQcSZytEBi+cZqTVy8T6gNAuDCn27BGiuOqyHqtyJbR4EnJlslvXFhsyOZVs8ZVse63Eo1ZYRhiPpPimLB+wr29hfUN0RQIdUc8OnHdEvAcjOlFeK6m7lV9bDGYbd0ydDIp3hIZLf0lG7qXvi3yJeQ5p6jp3sSYARbTF4K4+0JK0QILiwPh31ifEHKq6s8BYRE8jCnPFeQcq7g5OyFwzfgqzVK+FAY/JIzeJuw4Ui1cV7YwpBH5nYEbWqPX+hBsWbCkyJYV/bmqvCrm/tfzsN2126bteqGhgr9C8r2vQmNWm+QRCZhGHzvENC+jb5A0ZeBTBa/w5yp5brKOcd07/SbMxHOC5KkykQ+9BKyzFaKoIbMYeK4Lol8xLPfos46kN8AuiN+raCDi3PbUU8si7P36vLL+HAy0KC6S1MpUyvs9uJqC1dhM9w9ymqWwG8j/xotFoFJMNCS8ej+TAMtxzPPwll0Ir/4inqvKq2wTL10/dM1wUizdR1AjCmcN1qQxq/Ac0fbcBb8zzX7Y6ZVF9Q3/v9kJdMaJxzyHQsC/bt2S1L22jy0Gc/CcF0MZx3PAOxYHxj0Ji+BOQHnODwByqKQCWJJY6IuPQC39JTNL1Q6nkXTy/hxqoodgs+i/czKVModhGhNPsij7cyBHPBMsa5bW+nNsYuH89XEHHMp6rZ8oO2DLAh9MXrdU8iqlcz0McB0JTsDDnvd9vRqzhZOTH07nLzd2qvP6zr6RAVhH5Q3LivpF65a87tV9bDGYgef8jtFYnvPIbR7EwcNyRBpjp77dn6nYUhklfw4szvADitEu1/WGcf4c+iHx5+BHkamc7s/RfSNpqug+MLR8+kbULAXbrnA0Cv7cAxWPbXjEboa2hSCpSIvhd6p9GtVGnLEWjqqOXrdU8yqlczoAy0I2k/AayXWFGrPQM0NaMETUNPzprvlzS+obWU9Oc+MUb54qgL9i3VKte00fWwzm2p8r81x63yWec6oQ+pwiOHDwAAtTGN8Ud1DPw/Zw7Jqhy/hzIlCHu3TNcApHwvxaUFhaZNN/xHMuX+bz+Vzi7Bt23xo5x8n+3AcxUreXaZb6F3QWFrdRybH0LnoLSbIE2bhw5rbd37TxjLoZ0ZaLPZNOxifynPBY/b2CZNSAnYIj6H01ZpXz2Fwhz++okYr71ji0vg+QJl1a38hAEQZSzmpp53Q+RZ6DL6KC56RiF/vYYrBcnqvz55CSfXgAfoOmJNebv452uqGDl2WpxnSevrw/R4EnX+7oBL6NFPqfm5KLo4WAGSkxX8JbipxjnT+X4zl5oiDZzVr/II5DYZxHfSxgOv0JCHDpEE8UcGdwlq5Or1XsA7TjVaxbVuVVf08cHjZOHkyik3fWmFUsJjz7AN97KKpwjjoUmMwIl9U3dJQvuj2wqWT707SdRX+ODOfX6BgvC0vgubBNnX3xyfCBzQk1eIq8T0b28CIjjjsRC+fRfBR5wDOB2q47vnPDdrlVNyvcFvjMLXr0lw/BnyNyjurPUzpZn094Zcr9wkrN0uiVip59qhc6h0IOkaN5D404Iy5wJcOqa58KeYH99in+nJTXyHvi8W2SfTVyLEXoGy96X3yQyiaP8lxeY7Z4EZ6+ZZQFOBcNY0Tw7JbSN5h5AeML+2exANJ9Knm/HE8KtegEKLuX6xgvABbf0mAwGAxrhvGcwWAwGNYM4zmDwWAwrBnGcwaDwWBYM4znDAaDwbBmGM8ZDAaDYc2YgeeWqfEYrlHrd8BLcZKqQE7JN/7C6QuCfLvTwFQQNSBbcUEwTC/z5gmNxw/pCjAJbA1/2PVINnbyYWVwt0lqmVKy8bi8/sZ5uEL9kozptX7tWEZhU0iRyAVzWBH2Zmve6Tu2z0/EfHGcCzFk6d0dcDXnKzQe7yHYNu7KpN88z3O+GOQWXVZqpxLwsjC7NgQ/7hYduYIT7hFWlOQ5jccPHL2evZFwsRIHChgdu5J0NidUK/JZUZ5paZqcpbxq01mtXivkOaqcFbVKEPlhBpKvmont/Jbt8xMxP889N8d5kcaj7x91PCeUeQxRnQcfThoo7KAeXJFIUauBhiKjMf7zBqJQ/qk8l7uWDmJJJJ7j1Rw9sQBBNMSRn3NDd8vT5DS91uxYRpes+6PMc35mibql+y0MMlLZzu/VPuPGzoowP88tQeMRqGkUhMuz8QDrKt5AE3Psdm0nRzgbCfbzjAVPVctqqIrjcPPcuiUscD6GoZjLhNbWA+J8fpT0zxanyWl6raWxjIOei1wYf+sjqAnxIV+oNbq49vmJmEWvYGkajzFEG4xzE6ZO1J9TImBNWQr3EdP3ofuOseZsSp5cKDH+XkUYOraCCiKQvULjkUDlORJ8aCLPwT05EndR3fPQmiXEOgrSJKbXuly9Vpddgzy29LwSzj/0PSFIut7O79k+PxPL9+e+XOPxmrQZ4a+Yab6Jsnm5yaNgO+KvoFJPD5WrKoHW9P0YQNYzNYtQEi0QrbjZkJn4j9F4LI9nPI3YHo6ChFh/rGnnPe4ttG+k0zp6gFA8v7kuRJPT9FqzY/njcd/3Q+fV0dw/ULJpn0KcCwKeK7bze7bPD8XcPBdArPx3ajyeDk4iRzhsGfIauhQW9jl/Dq9bhoj7g3AEpgC+xXLf75wOQ5rcbTYbrgemB4knEifhsVdpPLLs5Bi+zJ+jp2bGY/QxllFn1UyvdTFjOZyazp63jBNWrZXoYqbYzm/ZPpNH0LtjZp4TjeP3azxiO3jf9+22abcHFpU8/PwKD61NOS2Jj7rdjttdWzzdjsH9OUkQ66GcYpdEkaC6aWD00nrjKI1Hkl1/CUdycMsIQdOHvaKgWwmJ57KeHDq31i5Gk7M6r5+q13o6QJkFed0yLDv7biavsrxQa3RJ7TN5BL075uO5JWk84v2bYNfIthDqOk0qzPM8dx4EfgIVLPkirgzQQxJHrNC24HVI47OovTJK4xHUtyGeBK0LWIGJkrNPuHSj/bnIE7eFaXKaXmtpLNfcKyCaf9lRk23n92sf6aTMD8Bs98QXpfEIz1vCQ/9oywqvP1zPl3DHdtylAtT/mrbrk3yrZIvF9UzUOE0ghqjgiopa9OeounpqT3G1cLrGo28uulwJdQTDBliYZGA10cmrl2N5DrrIYf9fug58M73WxY3l/D0WgedgA+r7c2I7v1/71GlKrw+zxv2SLt6GV1s7x4lQbRl994JeYljWb7Tpnt/romdVgIDhJJCjHxK11Pgx0L9kQyvvz7H4KdKN5tdoPOZ0cTn/nYdtP5DDAuykzIh2LvKcqm/J/gp7Dm5heF7X9FrnGcuj/blH4hVp41lt5/dsH/PnDAaDwWBYHYznDAaDwbBmGM8ZDAaDYc0wnjMYDAbDmmE8ZzAYDIY149fv3//8sY997GMf+9hnpR/jOfvYxz72sRsCipYAAAAUSURBVM+aP8Zz9rGPfexjnzV//g8m7uimU3ZclwAAAABJRU5ErkJggg==" alt="" />
这就需要将项目的平台改成相应的平台即可：
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVcAAACKCAIAAACRhJ4KAAAUIElEQVR4nO2d23MT2Z3H+w9J1WbybJypAlTEVN52a5KdXWopdiYVioEeQ9jMVpYtMiTDmzfLxqKwd/CKzIVUkTLMTBi5sx60M0MAmaXM1QbRDBdryPiGLfmGLFkYWbaZB+WhL+f06dMX3Vvq76dOFfLp7tMtpN+nf+d0q4+QrRzvHj+ey+X6P794596IUmJfxdOZZz/511N/uzN08cpX+Xz+3ePHOVvKwUAgKFs0K4n6Mno9ORgQJWY5d2tBWU3fivwtiQK7MBAIGKqUlagqdW+GduwP2ox+6Eo7PKi22f8c8zuye/8AOCJUsC3GAnfvx59Mz3524d7f7Qz97J1P5ubmc7kc3wKu4Xzl7SVgawFmodK4sY4VBb8d3m6VprgBbrSAuRlDJfMG3FQAUBRVscDIX8Ynp2dGHo8tP8/tPnj6lV2/G7gWHx0bs7KA1QlRh8Q5qwHHM6GNBeRggGpZb0oSSS392nTIjqHHCU8qwPmOYN+2+Q2aWkU2AMqj8ha4MXx3+N74R/1D6Uzm0uDIj3e/v+/Xn6ytrY2MxN3mAtwTJLWQfOedT4McC5jdoq6oVlChb2sBbv7O7Ns+2TdkMuQl/RbN79BNDQBFUHkLTDyZOtDR98qu3917NP0vh8++Kn7w5ysj+Xx+bHzC3gIk9m0tQIWmZYwaV+bnAkyuz88AyssF6LUtDtQqIeAJgf+ObJsHwAWVt8Dde/cnphZ+9MZ7P97z/qviB2++/fHa+otcLjc1PW1rAeqrzPQQzN9wbQUXcWjTI6A9YI5G3RXcAHO2gF3CTyczyAVAvam8BW4O3X66mO06Gf37PR/8w5sfnrt4f319PZ/Pz87O2lmAHop3yAVIhJVnAWpggB0EJH/LwYDBQy6vERh3bDhZkz/sRwas8h3euAAsAMqg8ha4fSf2zTejk9ML3Scv9Zy6vPw8v5hOp1KLCwtPrS2gfNclUR8Rs/hWq0mA8QxuGwG21wiU9kTJfCXAUENHKxGVfbrCs4C2ET99t7jYgWsEoNpU3gIKKysr6+vra2trKysrOQquBeivsdWImlJvFScuE4N6weu4O14Y0d6tQ68fgwKgXCpsATelgnv0CUoCwxWFmwFSAOyppAUAAI0ILACA34EFAPA7sAAAfgcWAMDvwAIA+B1YAAC/AwsA4HdgAQD8DiwAgN+BBQDwO7BAszE0NPSDnx5sFTtb2rtQql1axc4f/PTg0NBQvT/2soAFmo2Nrx9s+/mxzlPSB31foFS7vCddaPv5sY2vH6z3x14WsECz0bKns/OUdOnOyEQ6j1LtcunOyHvShZY9nfX+2MsCFmg2Wtq7+gZuTaRXpp+to1S7jC/m+gZutbR31ftjLwtYoNloae86d01+8uwFSm3KuWsyLAC8RUt7V/81eTz7AqU2pR8WAF4DFoAFiqVqFrB8vi79gCz9gZvmtfUn/drBmfnH98/famnv6huUH2deoNSm9A3CAlbwH4zLhKnDHIPmNh0ew2n7BFLjclowam1zPMOvpb3rj1fkh4vrVIm/s1kQdkeMlaWVyGv6f5vaYPydzcTLr32qr7blndvUhre7X97c/WUFDsBz5Y9XYAErHCxgOMvbT+9LP3jccgJBVgGG7Qx75izU222GXKKlvevM5bvywhopQ92tm7a0CntDdGUJ5exeQRB2nCV/th4ZkRdGDm3acmhI25GgvI7sELRKcgzdkTIPwJPlzOW7sIAFbnoEboNOmxxAiVZmKnF21lGmF0HO8/QkpZY5Q+M/299sgciRLa1HRkJvUAFcSonsELgtUBZYWAu9IbQeGYEFGot69ghkSQwEAgEhIIq87r9ZENweAasb4ypkPhCbmf94B8hMaNw4tLR3/SEaG55b1cqjg5u2HLy5OvzJXmFT1/+qlee2C1sO/mav8l+24TePhuceHdykvFgdnmNWtqhh2p9bHZ5b7dmlNHJuu0Aqh+dWh292beBv3gCFezbTl/4hGoMFLHC2gCSKoiiIEh3bxjh3N7d3kUdD9yVI3kDPiiJK2ca2wO8v3bk+k1fLR+3CxmOfzuSvz5zbJmw5cEOpP7dNEIRd567P5K/fONai1JM18927hG0f5UkjhnaY8vDARq1ZvSnDvrRF/M0bozDfO3rR7y/dgQUscOoRyEExKJOgV4NPEpWJyoqaw8vmUgKZT8xyRCFrNFbDDw20tHcd7rvx4f0lpfzin4Xv/Vo2ve77obD59c+VdeTXX1Ze65V9PxTEX2gtqOU9UXi58z+ZSnVz/f9bb5Nuf+nD+0sfft75Pf7mDVP0N8nUH+67AQtY4JQLSMGgrIe1Xq1UWPXcbSzAX51OAOizvc38nw0/MNDS3vX22esn5PQJOX1CDm9lxbjnLbV+846Isk5sR6v6uuPQ5pcOxToObRZ2hLUW0lRT+iZ0IZsbK4WtIaomtEdo/W0Hu22DFUEQzJVvn70OC1hQzJVCsq4W5/x0oCwLMOOHTM/DNHTYyD0CYoHQHi3siRS2hiwtcCLy25da92zlRLXqCIEWQWjPS4diFhZQVtZ3Hd4qCC8ditU9jKtRYAFr3N81REeo/TW7knsEZikZN6EHJqgZyxvVAgc+vtp9O9V9O7VvuyBs/1R5baz5dIuweVu/Ujm8bYP+OrVvuyBs+K/D1CaG8j+7yf+a2rJhc3ZfGt/95TC/wcYvBz6+CgtYUORdQ3pU2qXjpecCLvv7DT8okM1mW9q73jp9pfPmfGlF/Cfhb/59qOTNfVjeOn0FFmgYbGb+VWiaewf3nbrccXWmlHL2P74j7NpZ2rZ+LftOXYYFgLco2QI7/1EQBGFjV/3jqrEKLAA8R0t71+6T0cOXp1FqU3afjMICwFu0tHftfP/CLy9OotSm7Hz/AiwAvMWGN4++Fvry374cQ6lNeS305YY3j9b7Yy8LWKDZeOVA9/f3Hdv7p4f7P/sapdpl758efn/fsVcOdNf7Yy8LWKAJefVXJ1r3ddf9Wf1+KK37ul/91Yl6f+DlAgs0G+OTT450/jdKLcv45JN6f+xlAQs0GzdvPdh4soBSy3Lz1oN6f+xlAQs0G7AALFAssECzAQvAAsUCCzQbsAAsUCywQLNhtkBvplCYqMzXfbCgMUE1rjE4QFbrlagNpcJUprCz3rFaVQskk8n5+flUKpXJZJaWlur9LSgOWKDZYC0gFaYyhalCoaPM7/qAIc43DhSmZNUCasBLhSkt+H1ogVgsFo/HE4lEKpWCBUCdYSywUy5MyYWOCSqASyqDBX4LxAInCx0Tqhp8aIFwOByNRuPx+NzcXCaTqfe3oDhggWaDsYAapQOFAhWHg4VCr6ym8fopXXmx8SS7Mr8GFjBaIBQKhcPhWCyWTCZ9bYGIOyq4R2DGYAEqeunIHNQ79noaT63JSRzcWMDfPYKjR4+eOXNmaGgokUik0+l6fwuKo8IWMFc+e/ZseXn5+fPnuVxuZWXF1gLxaG9vNE7/1T+c0P5MDPfrfyaG+6Nx/Z/KE4+S44hH6aPwPrQF9JMz85qOUj2MB6kYZgcRbC2gQ1vGbxbo7Ow8ffo0LMCxAKMAKwvEo70OqDGpRiRvfW6k6itSskgM9/eaa5nNDK3R/jFUqiZiD7O+3qAtQIb0NTqsLaCMIOyU+RcU2MA+yW7OVBqyCWuJNEeBBQhMhDMKyOfz+XzeRY/A6QxPTtT2a5KlVI5BBbgWx5wd9A8nrMykbJEY7lfbIa8oW1CVNYdYYICEvR7JSnByLaCcsQd5Ua04gj7bc64RmFbuoPZLBh2ascACBDrCl5eXl5eX9fhfXV1dW1tbW1uztIB1PhCNZ/VTrjG2XPcI+GdnfqxaysHYnraKoRGyH7pPUVt0C3RMsGd1vYZvAWUFm5P2AJVUTHA2Z/el0dwKgAUMRCKRZ8+eKSkAE//rGjYW4J49DYFue5K2iTqLFJ0bqfGo1hS7mLRCR76FBeqXDZRz7yA9doACC5RCJBKh8//V1VU9+F9olJoLqOvQwaeGqk2waX12i7yfo4bEcH9/f78p7WfWp/3A7RFk65gMlG4BqRI3F/mywAKESCTCKEAP/m+//dbRAi5zAe1lr7MFyHZsX8J4NYKuj8YN4w68qDbYgR4dpPdRt2SgNAsoCXyZdxb5tsAChEgkQncBXlC4sUARuQDd/1ZeOJx6DSd+KwWQxeZ4N7RvkQtYtVJb8GsiWKBYKmwBswK+NVJOLqAEnPG6HTkVszFHbUltwr3qxx6JOcaNR0c7xcICbsYYq8PNWw9M1wdBdYEFCJFIhJsFuLSAQy4Qj/b2kj67Gzh3BrB7cTdoaIp0q+6BXSO1AhaoPbAAIRKJ2CugnFxAW264S8flNYLiiEd7o3FLKbm6IaDO9wvUOyh8ByxA8NXvCJSUnyuKut87WO+g8B2wAPAWDhYY7WnTZmfdf56qP7+fWw3cAAsAb2FrgfP79Sgf7WkT2npGtWrtJSgBWAB4CycL6OGuvx7taYMDygIWAN5Ct8BoT5t+4tdzAC0DoDKB0Z62tp4erUMAH5QALAC8BZ0LqKd7Q8KvDwxo/f/z+wVuNwG4BhYA3sLYI1AG/cy9ACrgjYMCGCIoAVgAeAs7C3AD3jgsAAuUACwAvIW5R0DSfEPCbxorYFcAboEFgLfQLXB+v0AHN4l4zo0BuFugLGAB4C1w72DtgQWAt4AFag8sALwFLFB7YAHgLWCB2gMLAG8BC9QeWIDw7vHjbkoF9wjMwAK1BxYgvHv8eM4JFxaQREGUzNVyUAzK5I9AgPxF1Qr2sA3z2zEfkHlLUwNyMCBK2awkkgaNxyOKovFgnPdcCrBA7YEFCIoF+j+/yJTPvrj0xcXL0f8fdGEBCwUwy1wFrxKFTutJov0qahsWq1EHolrAvFNtgWnHVK0cDAiixHojEAw6HB0HWKD2wAIE3QJ37o3o5auHj0cej42OTw5eu+FkAaMCOEJQT7Tcc7450iSRV+uQMNBBJwcDVAuc5uhDpILdEPdUDkPLi5aAIaFg9uFSeARnC1jdIjTa04bfFJYELEBgLHD3fvzByDePRyfGJ6emE8mbt4bsLMANWX5mQAKDTr9dNZi1PDVrG2kNcrsBcjBAe8KYIEhiQBQDrE6YHoLWIl1NvUuzBezTIw4OFrD8ncBoT1tbG+4fLglYgKBb4O79r7969JdHX4+Ojk9OTSdmZmfn5+djd+9aWsD+/BwIyvoaokQHkKUFlHANBETJdC6lLWAKMKVBSRQEMWhxTGJQTfklURCEQFCi1+NqQ38T5HDpg6CPkGeBIrMBWwtYPlBEWYCfEpUGLEBQLPB/fx4YeTz2zdjkk6nE/Pz84uJiOp1Op9OPRuLO4wJ6dHDza4ugNSGJghAIytqGVqN7bk+y3DCUg4GAKNILOKupB0Lbxdz9YLoV5s5JccmA3VNGrB4ooskBFigNWICgWOBC9Mr45FRyZubp06dLS0vLGmPjE84W0MOam7cr4WCKJWPQkM48c9YXBFFycRnBPBzHtYAUDMrMAtMxS6IoipQFTM2qA4LGqwqm911cMmD3lBH+A0VGe9rUSligNGABgmKBgStXE8mZhYWFdDqtT16cy+WmpqcdLWC4CmBlAUMFEx6G0z7bBt2Nd2zKyjW0JdjwtB7PlMRAMCgaWwmqa7O5gMvRESuKfb4AcQAsUCqwAEGxwNXrNxUFZLPZXC6X15idnXWwAB0CTMdZea2Eg8UYmzmErMcB5WBQu3ivjwNYx5nludi0gHhGWyRZ5wISsYDTuEClLMB5oMh56qfGGvh1cZHAAgTFArfvxB49GhkdHXsyNTU7N/c0lUotLqZSiwsLT+0swFxmN2bz+ni7IAh0wNpdI3C4GqA1oH/1rVd1bwFyZYIKcet+hkDLjak0NFnqNQL2KSNODxRBLlAasACh5HsHecN3dEZueTG9FAvI/DF9tVppz7o7wB4QZ/8GV3FyAbMY7Dr+pd8vwH3KiP0DRWCB0oAFCPgdQckogjPrxunORg64d7D2wALAW8ACtQcWAN4CFqg9sADwFrBA7YEFgNd4/mB0BqWWJZt9DgsA75JMJmOxWDgcDoVCR48e7QTVIRQKhcPhWCyWTCYzmUy9P/bigAWanPn5+Xg8Ho1Gw+HwmTNnToPqEA6Ho9FoPB6fm5uDBYC3SKVSiUQiHo/HYrEhUDVisVg8Hk8kEqlUamlpqd4fe3HAAk1OJpNJpVJzc3PJZDIBqkYymZyfn0+lUplMBhYA3mJpaWlpaSmTyWQymTSoGsr/sPK/Xe/PvGhgAQD8DiwAgN+BBQDwO7AAAH4HFgDA7+CXxQD4HU88ZUSFnmdAe1Io7xE9+hOJrR9D7rFZwwDwMh6aoYx6qg55yBb7mA3q8VtWFqjwrGHm5w6JUgkP/wDAs3hnhjLukwZZjE/u4k7vU/FZwwy7154kVvSDwADwLF6aoUyUrGYL4D7nT7OAaTbBCs8aRh+i4cmnRT0UFADP4o0ZyphIzkpiICixSTszSaAStPrsP1qdUPFZw6jNmOeeIxsATYEnZihT49KYyDNddzkYELSZfhSUDjuzThVmDdN3b54BBckAaAY8MUOZJIqS8aH81CyD1DrszASmAK/KrGFZrgOQDICmwTMzlBkmJ1NnKTbNVqb2FLSJP3gn/crPGsZ2V2xaBqAR8cwMZVpM6VOPWFnANDqobc63QPmzhlnMX1bkxGEAeBbPzFBGbhSyiX1LC5DtKj1rGGeaItO8YgA0NJ65d1ASBTHIXAk03dBnPH0bApQa6a/6rGHOiwFoIPA7AkusZg0TSpo4DADPgt8UAuB3YAEA/A4sAIDfgQUA8DuwAAB+BxYAwO/AAgD4HVgAAL8DCwDgd2ABAPwOLACA34EFAPA7sAAAfgcWAMDvwAIA+B1YAAC/81euNKgu5izFjQAAAABJRU5ErkJggg==" alt="" />
步骤二：在正式使用之前，需要在项目中添加引用：
Oracle.DataAccess.Client 设置数据库的连接等等通用功能，
Oracle.DataAccess.Types 设置 oracle自定义的一些数据类型
步骤三：实例解说
如提供以下数据库的信息
数据库服务器地址：192.168.10.20
库名：44410g242
账号：44bikll
密码：487gf,.q
连接oracle的字符串就是这样的（提供我测试的2种方式）
//string conString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.20)(PORT=1521))" +
//"(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME = 44410g242)));User Id=44bikll;Password=487gf,.q;";
string conString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.20)(PORT=1521))" +
"(CONNECT_DATA=(SID=44410g242)));User Id=44bikll;Password=487gf,.q;";
//写连接串以上2方法连接都可以，也可以放到Web.Config中。
以上的连接协议TCP和端口1521都是默认的 ，无需修改，如端口被占用了就需要改下。
本案例中涉及2个表TBLOCKLOG和TBACCOUNT
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types; namespace DHH_Bill_TBLockLog
{
class Program
{ static void Main(string[] args)
{
#region 测试数据库
Console.WriteLine("获取testid031用户在2013-4-11 15:53:40到2013-04-12 00:00:00的消费清单");
Console.WriteLine();
string conString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.20)(PORT=1521))" +
"(CONNECT_DATA=(SID=44410g242)));User Id=44bikll;Password=487gf,.q;"; //这个也可以放到Web.Config中。 //实例化OracleConnection对象
try
{
using (OracleConnection conn = new OracleConnection(conString))
{
conn.Open();
string sql = "select TBACCOUNT.username,TBLOCKLOG.accountid,TBLOCKLOG.amount,TBLOCKLOG.locktime FROM TBLOCKLOG,TBACCOUNT WHERE TBLOCKLOG.accountid=TBACCOUNT.accountid ";
sql += " and TBLOCKLOG.serviceid=1 and TBACCOUNT.username='testid031' and TBLOCKLOG.status=1 and TBLOCKLOG.locktime >= to_date('2013-4-11 13:53:40','yyyy-mm-dd hh24:mi:ss') and TBLOCKLOG.locktime <= to_date('2013-04-12 00:00:00','yyyy-mm-dd hh24:mi:ss') order by TBLOCKLOG.locktime"; using (OracleCommand comm = new OracleCommand(sql, conn))
{ using (OracleDataReader rdr = comm.ExecuteReader())
{ while (rdr.Read())
{
Console.WriteLine("UserName：" + rdr.GetString() + ",UserId：" + rdr.GetInt32() + ",点数：" + rdr.GetInt32() + "," + rdr.GetDateTime()); } } } }
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
#endregion Console.WriteLine(); Console.WriteLine();
Console.WriteLine("计算2013-4-11 15:53:40到2013-04-12 00:00:00时间的testid031用户消费的amount的总和");
Console.WriteLine(GetBillByDateAndGameId(conString, "testid031", , Convert.ToDateTime("2013-4-11 13:53:40"), Convert.ToDateTime("2013-04-12 00:00:00"))); } public static int GetBillByDateAndGameId(string conString,string accountId, int gameId, DateTime beginTime, DateTime endTime)
{
try
{
using (OracleConnection conn = new OracleConnection(conString))
{
accountId = accountId.ToLower();//全部转换为小写
conn.Open(); string sql = "select sum(TBLOCKLOG.amount) sumamount FROM TBLOCKLOG,TBACCOUNT WHERE TBLOCKLOG.accountid=TBACCOUNT.accountid ";
sql += " and TBLOCKLOG.serviceid=" + gameId + " and TBACCOUNT.username='" + accountId + "' and TBLOCKLOG.status=1 and TBLOCKLOG.locktime >= to_date('" + beginTime + "','yyyy-mm-dd hh24:mi:ss') and TBLOCKLOG.locktime <= to_date('" + endTime + "','yyyy-mm-dd hh24:mi:ss') order by TBLOCKLOG.locktime"; using (OracleCommand comm = new OracleCommand(sql, conn))
{ using (OracleDataReader rdr = comm.ExecuteReader())//创建一个OracleDateReader对象
{
int sum = ;
while (rdr.Read())//读取数据，如果odr.Read()返回为false的话，就说明到记录集的尾部了
{
if (rdr.GetOracleValue().ToString() == "null")//防止为空
{
sum = ;
}
else
{
sum = int.Parse(rdr.GetOracleValue().ToString());
//sum = int.Parse(rdr[0].ToString());
} }
return sum;
} } }
}
catch (Exception ex)
{
return -;
}
}
} }
显示结果：
以下是: 1. 建立数据库
建立一个名为OracleTypesTable的表
"create table OracleTypesTable (MyVarchar2 varchar2(3000),MyNumber
number(28,4) Primary key ,MyDate date,MyRaw RAW(255))";
插入一行数据
"insert into OracleTypesTable values ('test',4,to_date('2000-01-11
12:54:01','yyyy-mm-dd hh24:mi:ss'),'0001020304')";
其他操作的说明：（使用说明：http://www.oracle.com/technetwork/cn/testcontent/o23odp-084525-zhs.html）
注意：
1，案例中的sql语句还是和mssql有一点区别的；
2，统计的话如果获取不到统计的数据的会报错，这就是我为什么加上if (rdr.GetOracleValue(0).ToString() == "null")//防止为空
3，WebSERVICE的时候不知道为什么他对用户名的大小写也有区分。
步骤四：部署说明
在部署到真实服务器的时候，你也同样按照步骤一中的步骤安装客户端ODP.NET文件，点击执行EXE文件自动配置环境变量，查看一下是否安装成功。
注意版本是否一致，这个是运行你的程序的关键，打开cmd，执行：C:\Documents and Settings\Administrator>sqlplus /nolog 就可以知道版本
我的结果：
以下找了很多与版本相关的文章---版本的问题 ODP.NET开发和部署的相关问题
http://www.cnblogs.com/yjmyzz/archive/2011/04/19/2020793.html
http://www.cnblogs.com/codingsilence/archive/2011/07/14/2146497.html
http://blog.chinaunix.net/uid-20049824-id-1980177.html
补充 其中11.2.0.3.50 Beta的将更合适快速操作Oracle，但是需要win7和.NET Framework 4的支持，一般企业估计还没有把win7当服务器的吧！
http://www.oracle.com/technetwork/database/windows/downloads/odpmbetainstall-1696475.html
网上的这个http://www.bitscn.com/pdb/oracle/200904/160401.html Instant client批量安装Oracle客户端-
安装配置还需要从安装过Oracle的机器上拷贝oracle.key文件还要配置环境变量。
就这么多吧，希望对你有所帮助。,下面是ODP.NET的dll