Re: Can someone please tell me...
- From: "Miha Markic [MVP C#]" <miha at rthand com>
- Date: Tue, 21 Mar 2006 09:42:29 +0100
Hi David,
"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message
news:8972ED45-CA94-43C4-B80B-09235E231319@xxxxxxxxxxxxxxxx
Hi;
I am finding the following very frustrating and if someone could just tell
me why - I think it would be less frustrating:
1) Why is setting parameters in ADO.NET vendor specific? JDBC has had this
vendor neutral since version 1.0.
Because each database is different from others. You could use factory
pattern though (nicely supported in ado.net 2).
2) Why no simple vendor independent way to get the value of an
auto-generated primary key? This has been a need forever and instead
everyone
has to implement this on their own.
Because it doesn't make sense. Again, this should be a part of your logic.
3) Why no vendor independent way to get all tables, views, & stored
procedures in a database and to get all columns in a table/view? OleDb has
this but not ADO.NET.
It has in ado.net 2 (DbConnection.GetSchema method)
4) Why is DbProviderFactory.CreateDataSourceEnumerator() only provided for
SqlServer? The OleDb info is in the registry and the Oracle info is
(partially) in the root Oracle config file.
Don't know but you could use oracle's own managed provider or any other
(that supports it).
5) Why only 2 clients? Back in the ODBC and OleDb days MS was doing
everything it could to have tons of clients shipped with Windows. Now it's
SqlServer, Oracle, and the two bridge clients (OleDb & ODBC)?
Should MS cover any database on the planet? You can easily use 3rd party
managed provider.
If someone at MS could just explain why...
I am not exactly from MS but I hope my answers will shed some light...
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
.
- Follow-Ups:
- Re: Can someone please tell me...
- From: David Thielen
- Re: Can someone please tell me...
- From: Martin Aupperle
- Re: Can someone please tell me...
- Prev by Date: Re: ADO and ADO.net
- Next by Date: Re: Something is wrong in my SQL ConnectionString but what?
- Previous by thread: RE: Can someone please tell me...
- Next by thread: Re: Can someone please tell me...
- Index(es):
Relevant Pages
|
Loading
