>>>>For the Generic class do not use CS, but for the instances, use it.
>>>>
>>>
>>>Why?
>>
>>Becuase that way you could be sure every time for the exact length of the fields.
>>You could set DEFAULT values for the fields.
>>You could easily transform DateTime to Date ....
>
>Good points. Maybe in the next revision of my code I will make my generic CA class to work with CursorSchema property in a generic way. I am making only baby steps.
>
>I have not noticed that when you initially creates test samples, you used ODBC (not ADO); I was under impression that using ADO is better. Is this correct?


Yes, for new SQL Servers (2005 and 2008).
ADO handles new data types better.