.Net DataAccessLayer is a PHP script for Database Tools scripts design by YeagerTech Consulting, Inc.
It runs on following operating system: Windows.
.Net DataAccessLayer is a class for all DB I/O services.
Publisher review:.Net DataAccessLayer is a class for all DB I/O services. The DataAccessLayer 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 GetData, 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.
Operating system:Windows