Enterprise Patterns and Practices

[Mythran]

I downloaded the patterns and practices enterprise library and found that it
is much different for the Data library that I am used to (SqlHelper)..It 's
not just an update but a total rewrite. Anywho, figured out how to get it
to work which wasn't too hard. What I haven't found and am having trouble
with is updating and inserting into a database. In the SqlHelper library,
there were methods such as ExecuteScalarTy pedParams and such which allowed
all parameters to be inside a dataset and you just passed the dataset. This
was great because all of our data access routines returned a dataset. We
would just modify the data and pass this same dataset/table/row back to the
SqlHelper method and it would get updated using our stored procedures in Sql
Server.

Now, afaik, there are no methods which take a dataset for parameters. I
have to manually created the parameters, one by one and then add them to the
collection. Is there a better way, maybe they do exist but I haven't seen
them? Anywho, I could always write a method in my applications that would
take a dataset and build the parameters based on column name, column data
type, and compare vs the stored procedures, but if it already exists, I
don't want to reinvent the wheel.

Thanks in advance,

Mythran