Monday, September 29, 2003

My #1 grip with the Framework deals with ADO.net and the way they chose to implement the provider-specific mappings to native framework types.  The "generic" way to access a db is almost completely useless unless you are married to Sql Server.

There is no base type to deal with high-precision numbers that come out of a database.  Even with Sql Server you're forced to use the provider-specific types like SqlNumber and OracleDecimal, which are not related (which is impossible with ValueType I know) and provide horrible conversion implementations to the native types.

Of course the root problem is the lack of a true standard for dbs to represent data, and dbs like Oracle that have zero compatibility with accepted number standard like IEEE, but that's another story.  If System.Decimal better represented the numbers a db is capable of storing that would be a huge help.  Or even adding something like BigDecimal to handle high precision cases would be nice.

In my opinion, ADO.net has not succeeded in providing a cross-db interface to data.  Instead of providing the Bridge pattern to many different database API's, the managed providers are forced to implement features missing from the bridge, thus eliminating its advantages.  Some people may never run into these problems, but working with Oracle at work (which I've grown to hate) keeps me from using the managed providers without creating my own wrappers for the "special cases" that happen every time I query.

posted on Monday, September 29, 2003 4:29:53 PM (Pacific Standard Time, UTC-08:00)  #    Comments [0]
Tracked by:
"propalene diet pills" (propalene diet pills) [Trackback]
"Psychology Research" (Psychology Research) [Trackback]
"incontinence underpads indianapolis" (incontinence underpads indianapolis) [Trackback]
"cheapest erotic massage delaware ohio" (cheapest erotic massage delaware ohio) [Trackback]
"octopus" (octopus) [Trackback]
"enalapril 2.5 milligrams" (enalapril 2.5 milligrams) [Trackback]
"complete 2005 earnings calendar" (complete 2005 earnings calendar) [Trackback]
"1-800 directory" (1-800 directory) [Trackback]
"serpent Alchemy dragon lore" (serpent Alchemy dragon lore) [Trackback]
"omega psi phi fraternity songs" (omega psi phi fraternity songs) [Trackback]
"aggiungi sito" (aggiungi sito) [Trackback]
"personal injury lawyer virginia" (personal injury lawyer virginia) [Trackback]
"sturgis web cam" (sturgis web cam) [Trackback]
"naughty college girls gone wild" (naughty college girls gone wild) [Trackback]
"likable cameriera prostituta" (likable cameriera prostituta) [Trackback]
"BODY FORTRESS GLUTAMINE" (BODY FORTRESS GLUTAMINE) [Trackback]
"cascade locks" (cascade locks) [Trackback]
"lava lamps" (lava lamps) [Trackback]
"DMAE Cream" (DMAE Cream) [Trackback]
"the talon tallahassee community college newspaper" (the talon tallahassee commu... [Trackback]
"biology diagrams" (biology diagrams) [Trackback]
"nyc oral surgeon" (nyc oral surgeon) [Trackback]
"cable guy jokes" (cable guy jokes) [Trackback]
"park rapids resort" (park rapids resort) [Trackback]
"ugg australia in vancouver" (ugg australia in vancouver) [Trackback]
Name
E-mail
(will show your gravatar icon)
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):