A possible extension / addition to the data project

Jun 15, 2012 at 3:48 PM

Hi, this seems like a really nice library, thanks.

The data project returns datasets, however often you may want to convert the data in the datatable to an IList<T> and have some strongly typed object. I use some utility functions which can be used to do just that.

I wonder if it may make sence to add those to this library, either in the data, or as a separate folder as it would take away the need to interate over the rows.

Appreciate that an ORM is a better way, however where one has to use sql for business reasons, then having these utility functions may help.

Regards

Mickey

Coordinator
Jun 21, 2012 at 7:27 PM

Mickey...there is already some functionality like this in the Database class. Take a look at the following files for more information:

* {"<root>\src\lib\CommonLibrary.NET\_samples\Example_Database.cs"}

* {"<root>\src\lib\CommonLibrary.NET\Data\RowMapper.cs"}

* {"<root>\src\lib\CommonLibrary.NET\Data\DataQuery.cs"}

The DataQuery.cs contains extension methods to the Database class. They take in a parameter that represents a rowmapper.

Let me know if this is what you were looking for. If you have any other suggestions... please post here. 

Thanks.

-Kishore