Re: Provider independant Data Access

Tech-Archive recommends: Speed Up your PC by fixing your registry


"Massimo" <barone@xxxxxxxxx> wrote in message
news:eq9k7Au6GHA.4348@xxxxxxxxxxxxxxxxxxxxxxx
"Philipp Brune" <philipp.brune@xxxxxxxxxxx> ha scritto nel messaggio
news:egabkd$1fn$00$1@xxxxxxxxxxxxxxxxxxxx

what I want to achieve is to build my own set of
DbCommand/DbConnection/DbDataAdapter/etc. classes
that wrap a given .NET Data Provider like
MySql, Firebird, SqlClient, OleDbClient, etc
and provide the following functionalities on top :

- @ as parameter identifier for parameters in every CommandText

I'm also trying to overcome this awful limit of the standard ADO.NET 2.0
classes; this alone, I think, is the biggest problem of the ADO.NET 2.0
library... and it's even worse because it could have been easily fixed by
having any data provider implement a GetParameterDelimiter() method and
using a generic delimiter in the DbCommand class!
I really don't know why Microsoft didn't handle this better :-/

Wow, guys, it is not that easy at all. It is not just parameter naming
convention. It goes way beyond parameters.
There are a ton of databases out there each with its own perks and features
and slightly different sql language, etc.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/


.

Relevant Pages

  • ANN: MySQLDirect .NET Data Provider 2.30 Released
    ... Core Lab company has recently released new 2.30 version of MySQLDirect .NET ... Data Provider, 100% managed full-featured .NET data provider for direct ... Data provider can access MySQL server either using native MySQL network ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Provider independant Data Access
    ... DbCommand/DbConnection/DbDataAdapter/etc. ... and it's even worse because it could have been easily fixed by having any data provider implement a GetParameterDelimitermethod and using a generic delimiter in the DbCommand class! ... I'm trying to build a generic data access layer for variable data formats, and there is simply *NO WAY* to do this, other than building my own type mapping method! ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Provider independant Data Access
    ... DbCommand/DbConnection/DbDataAdapter/etc. ... that wrap a given .NET Data Provider like ... real problem WITH the real problem. ... Lead developer of LLBLGen Pro, the productive O/R mapper for .NET ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Delphi refocussing on .Net - good or bad?
    ... I never got the impression Robert was trying to start a negative ... I don't think that was his intent, ... I never mentioned our .NET data provider, ...
    (borland.public.delphi.non-technical)
  • Re: Delphi refocussing on .Net - good or bad?
    ... discussion about our .Net data provider. ... FWIW, I never got the impression Robert was trying to start a negative discussion about your products. ... I think he was speaking of assemblies created from Delphi for .NET in general, and only used your data provider as an example because *you* brought it up. ...
    (borland.public.delphi.non-technical)