Re: ADO.NET and SQL, Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Miha Markic [MVP C#] wrote:

> Hi Frans,
>
> > I also think that deciding which database to use (!) based on the
> > .NET client is the most unwisest thing you can possibly do.
>
> Dito.
>
> Oracle supports
> > at the moment a large pack of feature which are absent in SqlServer
> > 2000 (oh, of course they're coming in the next version).
> >
> > Don't get me wrong, I like SqlServer too, but for databases with
> > terabytes of data and large tables (millions of rows) with a lot of
> > users, it's key you have a feature like MVCC or isolatable
> > transactions which are not blocking readers and readers who aren't
> > blocking writers (so the only option you have is NOLOCK hints... )
> >
> > Personally I never had that much problems with ODP.NET. It has its
> > quircks, but so does SqlClient if I may add. Also, SqlServer isn't
> > bugfree either.
>
> I like Sql server more than Oracle becuase:
> - better tools (SqlPlus anybody? :-))

haha yeah, that's pretty retarted indeed :). I use SQLTools 1.4 now
for oracle. There are other tools which cost a small fee which are good
as well and offer more features than for example QA.

> - way easier to manage and install

Installation is indeed easier, manage... I'm not sure. People often
forget that Sqlserver, when used in a large application, needs proper
tweaking and tuning as well.

> - install size is smaller

true.

> Perhaps Oracle is a better database (not saying that it actually is)
> but only if there are very skilled administrators and programers that
> take care of the huge monster.
> And perhaps it is just me :-) but the ease of development with Sql
> server is a huge point in favour of it.

Isn't this a myth more or less? What's so horrible on developing
against an Oracle db, from .NET's POV? You use the same interfaces, and
have even more functionality at hand...

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
.

Relevant Pages

  • Re: Size of SQLServer databases with indices
    ... > I am starting to examine using SQLServer instead of Oracle. ... I then checked the size of the database. ... In SQL Server, yes, indexes take up space. ...
    (microsoft.public.sqlserver)
  • Re: Multiple Database Support - .NET 2.0
    ... > that's not bound to any particular database. ... sqlserver has named parameters, ... sqlserver uses SCOPE_IDENTITYfor identity fields, oracle / ... > This is something different than Object-Relational Mapping (ORM). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: synchronization with heterogeneous tables and referential integrity
    ... In my application's database design there are entities which have foreign keys referenced to some tables that should be maintained by the accounting application in SQLServer. ... My idea is to build "shadow" tables in Oracle with the same structure of the SQLServer tables and implement a scheduled batch process that keep them synchronized with SQLServer using a database link and Heterogeneus Services. ...
    (comp.databases.oracle.server)
  • Re: customize paging in asp.net
    ... datatables that have no 'real' physical relation in a database. ... > different databases one from sqlserver and one from oracle. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Item cannot be found in the collection corresponding to the requested name or ordinal.
    ... database and write the result on the same ASP page, ... I'm a little hesitant to reply, never having used Oracle, but in SQL Server, ... Microsoft MVP - ASP/ASP.NET ...
    (microsoft.public.data.ado)