SqlType

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello!

When is it any point to use the type that exist in sqltype like sqldecimal ,
SqlInt32 and so on ?
Is it any recommendation when it a good point to use them.

//Tony
 
When is it any point to use the type that exist in sqltype like
sqldecimal ,
SqlInt32 and so on ?
Is it any recommendation when it a good point to use them.
Click to expand...

These types uses the same format as SQLServer uses internally.

If you use .NET types then they get automatically converted
to and from these types.

I would say that there is a point in using them if the .NET type
and the SqlType uses different representation and you need to
control the conversion more than relying on the automatic
conversion.

That said, then I have never used for this purpose. I have
only used them when writing CLR SP's (stored procedures in C#).

In some cases the SqlType types are needed there (return values
I think).

Arne
 
Back
Top