Luis Ramirez has written an interesting article on Codeproject.Com, comparing Vanilla DAL to plain ADO.NET, Microsoft Data Access Application Block and SqlNetFramework. Link: http://www.codeproject.com/KB/dotnet/SelectDataNetDevTools.aspx
Vanilla DAL 0.6.0 comes with improved support for automatic transaction management using VanillaDal.TransactionScope. Please consult documentation for details.
This maintenance release solves an issue on OLEDB datasources which require statement parameters - even named ones - to be passed at exactly the same order as they occur in the statement (the parameter order might have varied in older Vanilla DAL releases, e.g. when autoincrement columns existed).
This update mainly contains documentation improvements and an enhanced sample application.
Vanilla DAL 0.5.0 adds support for automatic optimistic locking and for sql statement logging. Please consult the documentation resp. the sample application for further details.
The Vanilla DAL documentation has been updated for release 0.2.3. It is part of the download package, and can as well be found here: http://members.aon.at/arno.huetter/vanilla_dal/vanilla.pdf
Vanilla DAL 0.2.3 includes the following changes:
- Support for auto-increment primary keys.
Vanilla DAL 0.2.2 includes the following changes:
- SqlServer: quoted identifiers for table names and column names (square brackets).
- New Property FillParameter.SchemaHandling for defining whether DataSet schema should be preserved or updated by DB schema.
- SQL code may now be passed in directly, as well as pre-processed before execution. The sample application provides more details.
- Class "StatementID" has been renamed to "Statement".
Version 0.2.0 provides support for OLEDB and Oracle databases.
Release 0.1.2 lays the groundwork for additional DBAccessors on an API level. The current SQLServer-DBAccessor will be supplemented by DBAccessors for Oracle and OLEDB in version 0.2.0, scheduled for September 2006.
Screenshots of Vanilla DAL 0.1.1 API usage and configuration files are available at http://sourceforge.net/project/screenshots.php?group_id=162290