ADAL (Automatic Database Access Layer) creates VB.NET classes and SQL Server 2000 stored procedures that remove a lot of the redundant code required when building a new .NET application.
This is a wonderful bit of code. I was able to create a simple import/export program for a project in just a few clicks.
This release has a lot of new features. The most notable are: - Mapping columns that allow null to System.Nullable - Updates to make using and ADAL file with a web service easier. - Added some instructional documentation. - Support for VARBINARY SQL Server Type. - Select All and Select None buttons - Option to create inline (parametrized) SQL instead of stored procedures. - Added ExecuteExtension_Collection, ExecuteExtension_SingleItem and ExecuteExtension_DataSet to make writing extensions easier and faster. - Moved the Command and Connection Objects to the DALBase object with a Friend accessibility to make support for transactions and paramaterless constructors easier.
Revision: 113 Author: FirstDivision Date: 3:41:27 PM, Friday, April 17, 2009 Message: upgrade to parameterless constructor ---- Modified : /trunk/libADAL/Generators.vb Revision: 112 Author: FirstDivision Date: 3:20:49 PM, Friday, April 17, 2009 Message: Moved sqlConnection to "Friend" accessibility in DALBase ---- Modified : /trunk/libADAL/Generators.vb Revision: 111 Author: FirstDivision Date: 3:25:27 PM, Wednesday, April 01, 2009 Message: Added "Save and re-load checked tables to Saved File ---- Modified : /trunk/Source/Form1.vb Modified : /trunk/libADAL/ADALFileStructure.vb Revision: 110 Author: FirstDivision Date: 2:21:53 PM, Thursday, October 23, 2008 Message: Added new ExecuteExtension_Dataset functionality ---- Modified : /trunk/libADAL/Generators.vb Revision: 109 Author: FirstDivision Date: 11:37:46 AM, Wednesday, October 08, 2008 Message: upgraded to ANKHSVN 2.0 ---- Modified : /trunk/ADAL.sln Revision: 108 Author: FirstDivision Date: 11:50:57 AM, Tuesday, August 26, 2008 Message: Close readers in extensions ---- Modified : /trunk/libADAL/Generators.vb Revision: 107 Author: FirstDivision Date: 11:27:27 AM, Tuesday, August 19, 2008 Message: Remove "CommandBehaviour.CloseConnection" from Select and SelectAll to allow transactions to keep the connection open. ---- Modified : /trunk/libADAL/Generators.vb Revision: 106 Author: FirstDivision Date: 11:12:51 AM, Friday, June 06, 2008 Message: added support for NCHAR data type ---- Modified : /trunk/libADAL/Generators.vb Revision: 105 Author: FirstDivision Date: 9:18:46 AM, Wednesday, May 28, 2008 Message: Made command object friend class to start creating support for transactions ---- Modified : /trunk/libADAL/Generators.vb Revision: 104 Author: FirstDivision Date: 11:14:37 PM, Thursday, May 01, 2008 Message: Added "Catch" exceptions ---- Modified : /trunk/libADAL/Generators.vb Revision: 103 Author: FirstDivision Date: 11:13:24 PM, Thursday, May 01, 2008 Message: Added SingleItem extension helper ---- Modified : /trunk/libADAL/Generators.vb Revision: 102 Author: FirstDivision Date: 11:05:56 PM, Thursday, May 01, 2008 Message: Add ExecuteExtension helper method (returns collection) ---- Modified : /trunk/libADAL/Generators.vb Revision: 101 Author: FirstDivision Date: 3:33:54 PM, Wednesday, April 23, 2008 Message: Update WinForm to support new "No Stored Procedures" option. ---- Modified : /trunk/Source/Form1.vb Modified : /trunk/Source/frmConfig.vb Modified : /trunk/libADAL/Generators.vb Revision: 100 Author: FirstDivision Date: 3:01:35 PM, Wednesday, April 23, 2008 Message: Finish updating Generators VB for option to use SPROCS or not ---- Modified : /trunk/libADAL/Generators.vb Revision: 99 Author: FirstDivision Date: 2:41:14 PM, Wednesday, April 23, 2008 Message: Started update to allows choice of sProcs or not (Did INSERT) ---- Modified : /trunk/libADAL/ADALFileStructure.vb Modified : /trunk/libADAL/Generators.vb Revision: 98 Author: FirstDivision Date: 3:47:46 PM, Monday, March 31, 2008 Message: Fix VARBINARY Sproc ---- Modified : /trunk/libADAL/Generators.vb Revision: 97 Author: FirstDivision Date: 2:34:01 PM, Monday, March 31, 2008 Message: Added Select all and select none buttons ---- Modified : /trunk/Source/Form1.vb Revision: 96 Author: FirstDivision Date: 1:42:08 PM, Monday, March 31, 2008 Message: Added SQL Server VARBINARY datatype to translation map (goes to Byte()) ---- Modified : /trunk/libADAL/Generators.vb Revision: 95 Author: FirstDivision Date: 4:25:55 PM, Thursday, March 06, 2008 Message: Added some instructiones (In-struck-she-own-ehs) ---- Added : /trunk/Docs Added : /trunk/Docs/Instructions.doc Added : /trunk/Docs/Instructions.pdf Revision: 94 Author: FirstDivision Date: 2:52:24 PM, Monday, February 25, 2008 Message: Added ADALCollectionBase ---- Modified : /trunk/libADAL/Generators.vb Revision: 93 Author: FirstDivision Date: 12:38:18 PM, Monday, February 25, 2008 Message: Select all tables by default. ---- Modified : /trunk/Source/Form1.vb Revision: 92 Author: FirstDivision Date: 12:29:57 PM, Monday, February 25, 2008 Message: Added Insert sub procedure to ItemCollections. This makes it easier to add a new item (particularly for forms applications). ---- Modified : /trunk/libADAL/Generators.vb Revision: 75 Author: FirstDivision Date: 3:44:01 PM, Tuesday, September 25, 2007 Message: Fixed error that caused update and inserts to be attempted for auto increment columns. There was an error that was introduced when ADAL was refactored into a class library. This error only effected a very specific case: When a table had a column that was set to auto-increment integer and was not the first column in the table ADAL would try to insert and update that column. ---- Modified : /trunk/libADAL/Generators.vb Revision: 74 Author: FirstDivision Date: 3:10:29 PM, Tuesday, September 25, 2007 Message: Update to make it more web service compatible ---- Modified : /trunk/libADAL/Generators.vb Revision: 73 Author: FirstDivision Date: 10:13:11 AM, Wednesday, September 12, 2007 Message: Update to create nullable columns as System.Nullable(Of ColumnType) ---- Modified : /trunk/libADAL/Generators.vb
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?
Thanks for your review!
Get credit for your review by logging in via OpenID. Click your account provider: