Post-micro-engine will discard system. Data. oracleclient Versions later than. Net 4

Original post

Http://www.cnblogs.com/WizardWu/archive/2010/05/17/1737009.html

 

 

This is a message from Microsoft's official ADO. Net team blog last year:

Http://blogs.msdn.com/adonet/archive/2009/06/15/system-data-oracleclient-update.aspx

I just tested it with vs 2010 to confirm the correctness of the message. Oracleclient Is An ADO developed by Microsoft for Oracle. NET data provider, from. net 1.x has become. net Framework class library, which is highly integrated with Microsoft Visual Studio.

In this blog post, Microsoft will not support the development of the data provider system. Data. oracleclient in the future. This class library will be removed from. Net 4 and later versions.[1]. Therefore. data. oracleclient in vs 2010 /.. Net 4 is still usable, but a large number of "deprecated (not recommended)" warnings appear during development and compilation, such as 1.

According to Himanshu vasishth, product manager of ADO. Net oracleclientCodeWithout any impact, you can continue to use oracleclient to develop applications.ProgramBut ADO. Net team strongly recommends that users and developers use ORACLE providers from other vendors or third-party vendors.

In the future, Microsoft will focus on its own system. data. oracleclient will not launch new features, but will only fix major issues and bugs, and will continue to release these fixes in. the service packs of Net Framework 4.0. In addition, the support for system. Data. oracleclient 3.5 will be extended from 2013 to 2018. The support for system. Data. oracleclient 4.0 is the same as that for. NET Framework 4.0.

Figure 1 tests with Visual Studio 2010 ultimate RC/. Net 4 project. A large number of warning occurs during development and compilation.

The following are some of the system. Data. oracleclient alternatives listed in the subsequent discussions:

2. ODP. Net from Oracle:
   Oracle's own solutions are authentic and permanently free of charge. Users andTechnical CommunityMany, I heard that the performance is better than Microsoft's Oracle Driver (this is not confirmed), but only provides basic data access functions,ADO. NET Entity Framework is not supported.
   In versions earlier than ODP. Net 10.2.0.4, it is often complained that the version number must match the Oracle database correctly. However, I have heard that the new ODP. net 11g is compatible with all versions of Oracle databases (including version 9.2) and multiple versions can be installed on the same operating system.
   Http://www.oracle.com/technology/tech/windows/odpnet/newfeatures.html
   Http://www.oracle.com/technology/tech/dotnet/msoc/index.html
4. Devart dotconnet for Oracle:
   The official name is oradirect. net, which is free of charge. Supports ADO. NET Entity Framework.
   Http://www.devart.com/dotconnect/oracle/
   Http://devart.com/dotconnect/
6. DataDirect ADO. NET data provider for Oracle:
   Supports ADO. NET Entity Framework.
   Http://www.datadirect.com/products/net/net_for_oracle/index.ssp
   Http://www.datadirect.com/index.ssp
8. Oracle multi-tier. net provider from openlink:
   Http://uda.openlinksw.com/dotnet/mt/dotnet-oracle-mt/
   Http://www.openlinksw.com/

But as far as I see it on the network, Oracle's own ODP. Net has powerful functions, but it is not very good at integrating with Microsoft's. Net/Visual Studio. You must download, install, set up, and maintain ODP on each machine to be developed and deployed.. net provider and its Oracle client libraries (complaints about difficult installation on the network); and its library version is in ODP. for versions earlier than net 10.2.0.4, the corresponding version of Oracle must be used. For example, if Oracle is 10 Gb, 10 Gb ODP must be installed. net, Oracle 9i must install 9i ODP. net (this is mentioned later in this article. I have not tested it and are not sure whether it is correct), and Microsoft's oracleclientYou do not have to spend time installing and configuring. Another important point is that,ODP. Net still does not support Microsoft's ADO. netEntity Framework and LINQ to entities (may be Oracle's business policy ).

On the surface, it seems that a large proportion of customers, MVPs and developers tend to use ORACLE providers from partner vendors or third-party vendors, and because of the rapid revision and update of Oracle databases, these third-party vendors can quickly provide support for new Oracle database functions. Microsoft believes that it does not need to spend any more resources and time, and it will be followed by Oracle's R & D team and third-party providers.

I personally think that Microsoft is absolutely strategic. As this blog post says, it only aims to save R & D resources from. Net to Oracle, such as version control or performance. One of Microsoft's goals may be to pull some of its customers back from Oracle. If the customer's project has special requirements and key applications, or wants to use some. Net to access the database, the specific syntax and Performance Optimization[2]We recommend that you use Microsoft SQL Server; otherwise, I'm sorry, if it is in the future. net 4.X, 5, 6, 7 ,... what functions, frameworks, and syntaxes are available on the platform. If Oracle's official prodvider does not support this function, you are requested to take responsibility for it or use SQL Server to develop new projects.

Therefore. the net platform and Visual Studio are getting better and better, and marketing is becoming more and more exaggerated. In the future, more and more developers and it policymakers will "strongly suggest" their customers, it is best to use Microsoft's SQL Server (which saves time and trouble) instead of Oracle. Otherwise, some advantages such as convenient development and execution performance, such as some ADO. net/datareader[2], Or like the lightweight and convenient nature of LINQ to SQL, or some new types and features of SQL Server 2008: hierarchyid class type, storage of filestream large objects, spatial data type, service broker information exchange (SOA Implementation), or some new ones in the future.. NET Framework. If you insist on using the Oracle database, the above may not be effective.. Net Program integration.

If the customer still believes that Oracle can handle a large number of key applications, it doesn't matter. Microsoft will tell you in the future that "general" Application Development uses ORACLE data provider. net (ODP.. net) or some ORM frameworks can still operate normally. you will not be able to enjoy many new features and benefits of the. NET Framework Platform. If you still don't like SQL Server and want to use other solutions such as Oracle, Java, and Sybase (SAP), do not forget that enterprise application development is becoming increasingly popular.. Net/Visual Studio. Your project does not use my SQL Server. In the next few years, if your system needs to be revised or added with functions, you will be at your own risk. Of course, SQL Server can only operate on Windows operating systems. It is best to bind all new enterprise projects in the future.. Net/Visual Studio + SQL SERVER + windows, if Java cannot be effectively developed in the next few years or the schools continue to disagree, it may also affect the customer's willingness to select Oracle databases for new projects. In this way, two decades later, Microsoft will unify the system backend of enterprises all over the world, and then decide who dares not to win the world.

This article is also published in the "ADO. Net-blog group 」:
Http://home.cnblogs.com/group/ado/

--------------------------------------------------------------------------

RelatedArticle:

[1] Oracle and ADO. Net (. NET 4, Chinese version has not been updated)
Http://msdn.microsoft.com/en-us/library/77d8yct7.aspx

[2] datareader program performance is optimized. The changedatabase method of sqlconnection is used to switch between different databases without enabling distributed transactions.
Http://www.cnblogs.com/WizardWu/archive/2008/07/11/1241174.html
Http://www.cnblogs.com/WizardWu/archive/2010/02/16/1668769.html
Http://www.cnblogs.com/WizardWu/archive/2010/02/04/1663127.html

[3] system. Data. oracleclient will go into history by Li Ming Ru (Traditional Chinese)
Http://blog.darkthread.net/blogs/darkthreadtw/archive/2010/05/14/bye-ado-net-oracleclient.aspx
Http://blog.darkthread.net/blogs/darkthreadtw/archive/2009/10/11/road-to-oracle-linq.aspx

[4] migrate to the Oracle data provider for. net
Http://www.oracle.com/technology/tech/dotnet/msoc/index.html
Http://cshay.blogspot.com/2009/07/microsoft-deprecates-oracleclient-time.html

[5] other network articles (Simplified Chinese)
Http://bbs.dameng.com/viewthread.php? Tid = 859
Http://www.pin5i.com/showtopic-24628.html
Http://hi.baidu.com/coollzh/blog/item/51b4f235ddc2b81b91ef3964.html
Http://lichao.net/weblog/web-development/aspnet/140.html

[6] Oracle 11g Study Notes
Http://www.cnblogs.com/WizardWu/archive/2008/11/25/1340867.html
Http://www.cnblogs.com/WizardWu/archive/2008/11/27/1342174.html
Http://www.cnblogs.com/WizardWu/archive/2008/11/28/1343100.html
Http://www.cnblogs.com/WizardWu/archive/2008/11/30/1344096.html
Http://www.cnblogs.com/WizardWu/archive/2008/12/07/1349665.html