Right back at you, Rahul. Rainbow rocks! If you do migrate to iBATIS, be sure to let us know!
People are always looking for real-world examples, and it would be great to point them your way. I'd especially love to see Rainbow running with other databases, like MySQL. One trick I've been using is to push query results into a DataTable, which work well with DataGrids and such. It is such a pity that plain-old Dictionaries don't work with more ASP.NET components :( -Ted. On Wed, 15 Dec 2004 01:41:42 -0500, Rahul Singh wrote: > Guys, > > I've been using iBATIS for a few of the things that I'm working on > and am going to suggest that we use it for our DAL in the open > source Rainbow Portal project. Currently Rainbow works exclusively > with SQL server and uses stored procedures. > > Using IBATIS XML map files, we can move our stored procs to the XML > file and make our system work with other databases. > > Most of Rainbow currently relies on DataReaders for read only views > of the information and are bound using DataLists and DataReaders. I > know that we can map the results to a Hashtable object but I was > wondering if there is a way to access the raw datareaders. > > Thanks, > Rahul