Developed with VB.NET, ASP.NET, and C#.NET programmers in mind, the DataLayer.NET™ Database Interface Library shields you, the programmer, from having to learn and work with all the ADO.NET database objects at a low level, and encapsulates all this power into objects with many additional capabilities and features that are not offered in the standard ADO.NET Framework.

Our goal when designing the DataLayer.NET™ Library was to create an easy to use database access layer set of classes using 100% managed code in C# so that VB.NET, ASP.NET and C# programmers can use it to build database applications (Client/Server, Web, and 3-tier) without having to be consumed with the programming involved with the retrieval, handling, management and storage in memory of the data while it is being worked on, and updating of the data. We have accomplished this, resulting in as much as a 75% reduction in the data access source code needed to build a typical database application.

Here is some sample code for a typical task of connecting to the database:

And here is some sample code showing a typical retrieval of data from a single table:

When the GetAllRows method executes, it retrieves all of the records from the database, and stores them into an internal DataSet object inside the DataHandler object. This DataSet object is directly available to you as a property, should you need to directly use it (for populating a DataGrid, etc.).

Finally, here is what it looks like when you are updating the database:

Key features of the DataLayer.NET™ Library include:

• Can work directly with SQL Server, any ODBC data source, or any OLE-DB database source.
  
• Classes provided are intuitive and easy to understand how to use.
  
• TRUST and EMPOWER the programmer. Provide programmers with the power and capabilities of the library, but do not limit or block them from directly sending some SQL to the database, if they deem it necessary. Extend their SQL Knowledge, not replace it.
  
• Design optimized for performance using 100% C# managed code.
  
• Strongly typed interface to table columns, fully taking advantage of IntelliSense in Visual Studio for auto-syntax completion (eliminates errors typing column names).
  
• Code Generator included for automatically generating the entity classes needed for the strongly typed interface to the DataHandler objects.
  
• Facility for automatically handling Null values when read from database.
  
• Facility for building Parameterized SQL for best practices (prevents SQL Injection attacks and performs much faster than dynamic SQL).
• Can be used for both the update portions of your application (edit windows) as well as displaying lists of records (browse or list windows).
  
• Supports paging through result sets, retrieving only the page of data requested, if desired.
  
• When using the DataHandler in paging mode, a full suite of page navigation functions are provided, such as GetPage(n), GetNextPage(), GetPrevPage(), GetFiirstPage(), GetLastPage(). Properties such as CurrentPage and PageCount are available as well.
• Supports the IList or IListSource interface, so that it can be used directly as a DataSource for a DataGrid (in an ASP.NET web application or a VB.NET / C#.NET desktop application).
  
• You can use any custom SQL statement needed to populate data into a DataHandler object, allowing for complex JOIN or SUBQUERY statements.
  
• The DataHandler object is Serializable, so the object, including all of its data, can be stored in a Session variable for an ASP.NET web application as the user works with the data records.
  
• Logical units of work (transactions) fully supported via BeginTransaction, CommitTransaction, and RollbackTransaction methods.
  
• Ability to run any SQL statement that does not return a result set by using the RunSQLStatement method of the DataConnection class.
  
• Ability to run any SQL statement that returns a single row, single column result of any data type desired.
  
• Automatic generation of sequence numbers for child tables that need a secondary primary key column to be generated in sequence. For example, you have a parent table called PATIENT, and a child table called PATIENT_VISIT. The child table may have two primary keys such as ID_PATIENT (integer), and NUM_SEQ_VISIT (integer). There is a method provided by the DataHandler class called GetNextSequenceNumber() that will scan all of the current rows for the parent and determine the next available sequence number (NUM_SEQ_VISIT) to use.

Here is a screen shot of the code generator included:

Click here to download or view the DataLayer.NET User’s Guide
Click here to download or view the DataLayer.NET Getting Started Guide
Click here to download or view the DataLayer.NET Reference Guide

There is an evaluation version of the DataLayer.NET library available so that you can try it out for a full 30 days before deciding if you would like to make the purchase of the product.

Click here to download the 30-day Evaluation of the DataLayer.NET™ Library

The cost of the DataLayer.NET™ Library is $149.95 (US Dollars) plus 7.0% sales tax (applicable only for sales to Florida based customers). Because of the aggressive offering of this unique product at such a low price, we are only distributing our product electronically over the Internet to save on manufacturing and distribution costs. The 3-Volume set of manuals is delivered electronically in PDF format.

Purchase of this product includes one full year of free technical support. Additional annual support subscriptions (if needed) are available for only $99.00 per year*, which also entitles you to download and use the latest version of the library. Technical support is available via email submission of issues. On our website, we also have an on-line knowledgebase of solved customer cases that you can search to find solutions to common issues.

To purchase the DataLayer.NET™ Library, or to obtain more information, simply email us at techsupport@creativedatatech.com, or call us at (850) 997-1464.

* - Subject to future rate changes at the option of Creative Data Technologies, Inc.