I've implemented one of my suggestions: var preparedCommand = new DefaultPreparedCommand(); var findProductStatement = modelStore.GetMappedStatement("FindProduct"); IDbCommand command = preparedCommand.CreateCommand(findProductStatement, 42);
That should allow us to write some tests against the dynamic sql generator without having to execute a query on a real database. ________________________________ From: Ron Grabowski <rongrabow...@yahoo.com> To: user-cs@ibatis.apache.org Sent: Thursday, May 28, 2009 12:50:18 AM Subject: Re: Ibatis.Net - A Call to Arms I'm still alive and forcing my team to use IBatis.Net :-) They've commented on the verboseness and requirement of having multiple xml config files...things like not being able to use one of the built-in DbProviderFactorys strings. Perhaps merging providers.config within sqlmap.config so there are less files. Fluent interfaces seem to be the new hotness these days. Improve the abilitty to configure the mapper without sqlmap.config and providers.config. Migrate the internal Transaction objects to System.Transaction. Expand on the demos of using Castle NVelocity to do the dynamic sql ??? Have a way to generate an IDbCommand without actually executing it: // https://rhino-tools.svn.sourceforge.net/svnroot/rhino-tools/trunk/commons/Rhino.Commons/ToPublic/SqlCommandSet.cs var sqlCommandSet = new SqlCommandSet(); // lots and lots of products foreach (Product product in products) { sqlCommandSet.Append(dataMapper.CreateCommand("Product.Insert", product)); } // one trip to the database when using ADO.Net 2.0 and Sql Server sqlCommandSet.ExecuteNonQuery(); ________________________________ From: Sal Bass <salbass...@hotmail.com> To: user-cs@ibatis.apache.org Sent: Monday, May 25, 2009 5:07:34 PM Subject: Ibatis.Net - A Call to Arms Per Clinton's suggestion, I am making this post to find out if we can keep Ibatis.Net going. As we all know, Ibatis fills an important niche and is still very relevant. We need people to take charge and to commit time for development. So, who's in? If we don't do this there is nothing to keep it going. ________________________________ HotmailĀ® has a new way to see what's up with your friends. Check it out.