SQL Datatype

  • Thread starter Thread starter Axel Dahmen
  • Start date Start date
A

Axel Dahmen

Hi,

we have a discussion here about Typed DataSets and I'd like to get your
opinion:


* Why do Typed DataSets cast database values to intrinsic values instead of
SqlInt32 etc.? The way it's implemented now we're losing NULL values.


* Why don't Sql data types like SqlInt32 have a common base class providing
IsNull() etc.? The way it's implemented now we can't write one single common
function on SQL data types.


TIA,
Axel Dahmen
 
Hi Axel,
* Why do Typed DataSets cast database values to intrinsic values instead of
SqlInt32 etc.? The way it's implemented now we're losing NULL values.
Click to expand...

Null values are accesible through IsPROPERTYNull and through SetPropertyNull
methods.
* Why don't Sql data types like SqlInt32 have a common base class providing
IsNull() etc.? The way it's implemented now we can't write one single common
function on SQL data types.
Click to expand...

They implement INullable interface instead...
 
Null values are accesible through IsPROPERTYNull and through
SetPropertyNull
methods.
Click to expand...

Where can I find these? Searching the MSDN I didn't find these keywords.

They implement INullable interface instead...
Click to expand...

I see... thanks, that makes sense.
 
Axel Dahmen said:
Where can I find these? Searching the MSDN I didn't find these keywords.
Click to expand...

Those are generated for typed dataset (when you create a typed dataset those
methods are added).
For example, if you have strong type MyDataTable then you'll have also
MyDataTableRow which will have such methods.

HTH,
 
Back
Top