SQL Datatype

[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

 

[Miha Markic]

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.

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.

They implement INullable interface instead...

 

[Axel Dahmen]

Null values are accesible through IsPROPERTYNull and through
SetPropertyNull

methods.

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

They implement INullable interface instead...

I see... thanks, that makes sense.

 

[Miha Markic]

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

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,