Oracle vs SQL Server for .NET project

I know that Oracle is usually a good database engine, but I find it too complicated to deploy for .NET projects compared to native Microsoft SQL Server solutions.

(I needed to install both x32 client and x64-bit components and configure the TNS names for both of them, as well as install Distributed Transactions support for Oracle. Not to mention, you need to register with Oracle to get these binary files. )

However, I have seen some .NET projects with Oracle.

What are the benefits of using Oracle over SQL Server? Any specific scenarios where is the only choice?

Would you use Oracle for your .NET project?

+3
source share
8 answers

I'll start with this: the choice of the database engine for performance does not make a difference on this side of billions of lines: it comes down to the quality of the code and the design of the database. With billions of lines, storage planning / SAN / network / BCP is paramount.

From the general ease of deployment and support, it will be SQL Server; there are no shortcomings.

+8
source

, , MS (VS, LINQ ..) MS SQL, , , , . , ; / Oracle , Oracle; MS SQL, MS SQL. BI, , , .

+6

Oracle .

  • - .
  • , .
  • , IDE, ​​ Toad.
  • SQL , Nulls.
  • Oracle . , IDE, SQL Server.

, .NET, , , Oracle/Java 5-6 .

+5

WCF/SOA, Oracle . Oracle - , , . DB non.net. Oracle .Net , .Net, LINQ, Entity Framework, RIA .. Oracle , EF - . DAL, ODP.Net StoredProcedures, .

- Oracle, 32- /SP, . , Oracle , Oracle. SQL Server.

Oracle . , Oracle ( ). , SQL Server, Oracle Cursors SQL-.

// , , , SAN .., . .

, Oracle, SQL Server .NET.

+2

:

  • MS SQL Oracle
  • .NET MS SQL Oracle
  • .NET MS SQL ,
  • MS SQL .NET , , " Microsoft"

MS SQL MySQL, , , , - MS SQL vs MySQL MySQL - , MS SQL, .

+1

.NET , Oracle - . SQL Server . Oracle , .NET.

0

, oracle , , oracle.net . ( ) . : Dll Windows GAC. , ODAC oracle ( ) Oracle, , ODAC 32 64 . , temp ODAC. ODAC oacle .net - .

0

Oracle, OLTP , Oracle. , , Oracle , SQL SQL Server 2005. SQL Server .NET . SQL Oracle . , , .

, Oracle .

-1

Source: https://habr.com/ru/post/1752692/


All Articles