Subsonic 2.0 Final Ships!

By Don Burnett

Just when you think Mix is the center of the universe as we know it, everyone's favorite zero-code DAL (Data Access Layer) has shipped a major new release. Here are new features courtesy of Rob Conery's Blog.

Features

• Multple Databases are supported
• You can now use SubSonic in any project, not just Web Sites. We now have command-line tool so you can generate code however you like and do all kinds of cool stuff with MS Build or BAT files if that floats your boat, and Martin's come up with a nice set of macros.
• Query tool has been revamped to allow ORs and INs, and expressions. You can query now by saying IDataReader=new Query("Products").WHERE("ProductID > 10").ExecuteReader(); Love that...
• Code Generation now uses ASP.NET-style scripting so creating your own is ridiculously simple
• We now have ODS Controller-friendly controllers that really make life very simple with the Object Data Source.
• A whole mess of time-saver controls has been added, like dynamic drop-downs, radiobutton lists, server-side paging/sorting tables, and many to many checklists.
• an OracleDataProvider
• many improvements to our MySQL provider
• SubSonicCentral is our new "Sample" web site that will allow you to generate your code, setup your config, and do all kinds of magic on your local machine. It's like our commandline tool, but it's a website. Refer to this for sample code and if you want a good time! It's included with the new installer.
• Scaffolding has had a major facelift and it works a la post-back so you can have multiple on one page. He also made the "AutoScaffold" page - you drop it in your site and it creates an editor on the fly for all your tables.