ADO.NET 2.0 Validation

22 Nov 2005 10:20 PM

Giovanni

Hi all,

     Real issue for me here: I'd like to know where it would be best to put
validation and which are the events best suited to deal with such
record-related operations. There are many options, and I seem to be a bit
lost. Many people like the Partial Dataset class as opposed to putting
client-side/control-based validation, while others, its the opposite.

     Do TableAdapters fit into the picture anywhere in terms of validation?
How about BindingSource? Should I use that to respond to "Adding New row",
"Deleting", "Modifying", etc... or should I use the DataNavigator? All this
is kind of confusing. Thus, the best place to put validation code and the
best place to capture record navigation (with the possibility to add some
logic). I'd like to use the ErrorProvider, etc...

     What is the best practice/modern OOP way of doing things?

     Regards,

          Giovanni

23 Nov 2005 2:55 AM

Luxspes [MCP]

Giovanni wrote:
Show quote

> Hi all,
>
>      Real issue for me here: I'd like to know where it would be best to put
> validation and which are the events best suited to deal with such
> record-related operations. There are many options, and I seem to be a bit
> lost. Many people like the Partial Dataset class as opposed to putting
> client-side/control-based validation, while others, its the opposite.
>
>      Do TableAdapters fit into the picture anywhere in terms of validation?
> How about BindingSource? Should I use that to respond to "Adding New row",
> "Deleting", "Modifying", etc... or should I use the DataNavigator? All this
> is kind of confusing. Thus, the best place to put validation code and the
> best place to capture record navigation (with the possibility to add some
> logic). I'd like to use the ErrorProvider, etc...
>
>      What is the best practice/modern OOP way of doing things?

Mmmm.... IMHO the only REAL "best practice/modern OOP way of doing
things" is... to stop using the DataSet and start using
an Object Relational Mapper (or build your own one)

http://sharptoolbox.com/Category74089b0a-1105-4389-b1db-eedf27e20cfb.aspx

IMHO one of the best is NHibernate and it is opensource, but the license
allows for commercial use

Show quote

>
>
> Regards,
>
> Giovanni