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
<*> 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/
