.Net DataAccessLayer 1.0

Operating systemsOS : Windows
Program licensingScript Licensing : Commercial License ($5.00)
CreatedCreated : Jun 11, 2007
Size downloadDownloads : 1
Program licensing
Thank you for voting...

The DataAccessLayer component is a class for all DB ...

The layer component is a class for all DB I/O services. You can use these methods to handle all your DB I/O. This includes overloaded data, SaveData, ExecuteNonQuery, ExecuteScalar methods for OLEDB, SQLServer, ORACLE and DB2 databases. access to the ORACLE databases has a choice of two different providers (Microsoft or ORACLE). Use the "SaveData" methods when you are concerned about database concurrency issues. The SaveData methods return updated data in a dataset and can then be further queried for concurrency issues.
The various methods also include different ways of the data being passed to this class like in datasets, datatables, datarows, etc. In addition, you pass an "UpdateType" argument in these methods which will tell . Net how to proceed in case of an error occurring on an UPDATE statement (like concurrency, for instance). The possible . Net "UpdateType"s are: Continue, ErrorsOccurred, SkipAllRemainingRows, SkipCurrentRow which are self explanatory.
Everyone but "ErrorsOccurred" will NOT generate an exception, rather, these rows will be flagged as having errors and you can process them accordingly at your client level. Inside the "ErrorUpdate" region, code exists to capture the identity value of the row being inserted for the OLEDB and SQLClient (CommandText only, since executing a stored procedure can bring back the IDENTITY value) providers. This value is passed back up in the object that called the method through the dataset.
The IDENTITY value is always assumed to be the first column in a table. In order for the IDENTITY value to be returned inside your dataset, you must have the "ReadOnly" attribute set to FALSE for the IDENTITY value field inside the datatable you are updating (only pertains to the OLEDB and SQLClient, for CommandText only) providers. Every possible error exception for all methods are handled.

.Net DataAccessLayer 1.0 scripting tags: layer, identity, ecommerce components, access, data, net dataaccesslayer, methods, access layer, data access. What is new in .Net DataAccessLayer 1.0 software script? - Unable to find .Net DataAccessLayer 1.0 news. What is improvements are expecting? Newly-made .Net DataAccessLayer 1.1 will be downloaded from here. You may download directly. Please write the reviews of the .Net DataAccessLayer. License limitations are unspecified.