Ayende @ Rahien

Ayende Rahien commented on Converting an object collection to a DataSet

Thu, 14 Jun 2007 13:41:24 GMT

Writing your own grid :-) I don't kid, BTW. A simple option is nested repeaters

richard commented on Converting an object collection to a DataSet

Thu, 14 Jun 2007 13:37:38 GMT

I think have the same problem with grid controls (radGrid, ms grid etc.) NHibernate does a great job of getting me a List of Orders (with a property for a collection of OrderItems). While I can bind the Orders to a Grid, when I wat a second level nested table for the OrderItems I cannot do this. Despite this feeling natural to me. I am now thinking I need to start looking at DataSets to do this, unless any of you cna think of other options? Thanks

Ayende Rahien commented on Converting an object collection to a DataSet

Thu, 10 May 2007 09:05:36 GMT

That you don't always need a super smart framework to do this kind of things. People asked how I am doing it, this is stupid code, very simple, one purpose only. It is used for something that I need once every blue moon, so I just wrote it instead of building a framework. In other words, this is a post about "no magic involved"

Nikola Malovic commented on Converting an object collection to a DataSet

Thu, 10 May 2007 08:41:54 GMT

I'm sure I'm missing somthing big here because I don't see anyything worth the Ayendes blog in the post about how to iterrate through collection and put the collection members in the data set rows So, what I'm missing? :)

Darius Damalakas commented on Converting an object collection to a DataSet

Thu, 10 May 2007 06:54:32 GMT

For converting object lists into datasets we've written a simple class, which would put required properties (even nested ones) into a new datatable. why write so many code :)

Ayende Rahien commented on Converting an object collection to a DataSet

Thu, 10 May 2007 03:35:35 GMT

Frans, I didn't do it because I needed it for ~4 reports. Wasn't worth the time to invest in it. Thanks.

Frans Bouma commented on Converting an object collection to a DataSet

Wed, 09 May 2007 20:09:46 GMT

Why didn't you go for a projection engine for nhibernate instead? It shouldn't take that long to write and it then gives you the ability to project any graph to datasets/tables etc. (took me about a week or so for llblgen) the fun thing is that you then could put that engine to work for projecting entity graphs onto webservice message objects for example (object-document mapping) Btw, good luck next week in Montreal with the ORM Smackdown against Ted 'I-don't-like-orm' Neward :D

Ayende Rahien commented on Converting an object collection to a DataSet

Wed, 09 May 2007 18:23:19 GMT

Not going to work, I am also doing some flattening of the data, so it is actually something like: row["MotherMaidenName"] = customer.Mother.Maiden.Name;

Derik Whittaker commented on Converting an object collection to a DataSet

Wed, 09 May 2007 18:19:54 GMT

I was also going to suggest that you could serialize the objects to xml then load them into the dataset. this would save you from having to do a bunch of property assignment. Would also lessing the chance of breakage do to coding changes. Not sure if it would work though. Derik

Bobby Diaz commented on Converting an object collection to a DataSet

Wed, 09 May 2007 17:33:27 GMT

I have used XML Serialization in the past for a similar situation but I am not sure if it would be a good fit for you or which would perform better.

Adam Tybor commented on Converting an object collection to a DataSet

Wed, 09 May 2007 17:26:03 GMT

I have used this code in projects before. Sorry for the bad code formatting I am still a little new to this blog thing. http://abombss.wordpress.com/2007/05/09/nhibernate-to-dataset/

Ayende Rahien commented on Converting an object collection to a DataSet

Wed, 09 May 2007 17:16:20 GMT

That is not possible because I need to talk to a Reporting Service that calls me via web service, while I may be able to hand the data directly to a local instance, in this case, they are two distinct application, on different servers.

Nermin DIbek commented on Converting an object collection to a DataSet

Wed, 09 May 2007 17:12:05 GMT

I am wondering what reporting tool are you using? If you are building on top of.Net 2.0+, anything that you pass the DataSet to you should be able to pass BindingList. Then the code could just be: BindingList boundCustomers = new BindingList(customers); return boundCustomers;

Andrea Dottor commented on Converting an object collection to a DataSet

Wed, 09 May 2007 16:07:02 GMT

Simply perfect! ;o) "Do the simplest thing that could possibly work" [Kent Beck]