I'm not really a fan of IBATIS. Personally I would go with an O/R mapper for easy database independence. Both have their advantages and disadvantages tough.
----- Original Message ----- From: "Charles Carroll" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, April 06, 2005 6:02 PM Subject: [AspNetAnyQuestionIsOk] IBatis: 1 app supporting ANY database > > IBatis is an amazing .net Library. > > http://www.ibatis.com/common/download.html > and for support JOIN => http://groups.yahoo.com/group/IbatisDotNet > > You code your app and place your ad-hoc SQL statements and stored > Procs outside of the code in an XML file. Your code works against the > database and SQL specified in the XML. > > Lets say for example your XML file supports Access. Then later you > want to switch the app to SQLserver. You add a XML file for SQLserver > and adjust an app config file. And later you want to migrate the app > to Oracle. New XML file with all the Oracle info and you change config > and you are running against Oracle now. > > Even if the XML file is ad-hoc SQL later you can change to Stored > Procedures or Packages with merely adding an XML file and changing the > config to point to it. The DBAs can write efficient Sprocs or > packages and change your code to sue them without touching the code > just adding some new XML and a config file change. > > It is possible to change databases by merely adding XML files and > changing confuigs without recompiling the code. In fact the person > making up the XML files need know little about the code, just needs to > know the DB well. For example, someone who knows mySQL or DB2 can > change an app written by another coder, that was running in another DB > quickly transformed to be running DB2 or mySQL in no time. > > > > Yahoo! Groups Links > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.3 - Release Date: 4/5/2005 > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
