Data access layer for .NET that replaces ADO.NET



Please take a look at the attached screenshot of a Visual Studio 2010 test project. That's the UI code for the web page. The business layer for this test project consists of 4 lines of code. Stored procedures are astoundingly simple. That's with databinding, supports optimistic and pessimistic record locking, transactions, supports user security to the database, including server farms and does cloud easy. No gotchas. Faster than ADO.NET.

Drop two abstract classes (PersistentObject & PersistentObjectList) into a new project and the database access layer is done.

Andrew
+1 480 406 1401
andrewbb@gmail.com

Visual Studio screenshot
- framework for complex business applications with fully functional classes and object models. No limitations.
- automatic data persistence of classes/objects with full choice of back-end database (text files to SQL Server to Oracle to Access)
- multiple application support with single user login
- fully secure login (one-way encrypted password with salt value) with password reset and login creation
- role-based security for each web application
- automatic pagination
- shopping cart with encrypted credit card numbers unavailable to developer or database
- configurable payment methods that support instant or installment payments
- efficient load-balancing across multiple servers for server farms
- programmable HTML menu system
- JavaScript functions for dates and data validation
- small DLL (~400k) runs in process


In essence, it’s a fully-functional application server that is easier to use than .NET or any Java-based solution and is without limitation on class, object, database design or HTML layout.

The persistence layer maps stored procedures directly to business objects. Every call to the data layer includes the logged in user so database access can be locked by user or through role-based security. The mapping layer is faster than anything in ADO.NET by a margin of at least 50%. Optimistic and pessimistic record-locking is supported although optimistic is the default. Business objects in .NET 2010 consist of a few lines of code and support custom search algorithms and transient properties. Naming conventions are standardized, however can be customized to suit the development standards at any company. Database access is centralized so DBAs will be quite pleased with the level of control and security allowed to prevent unauthorized access to sensitive data.

This solution combines the best practices from both Java and Microsoft technologies and can be ported to other platforms. It is currently designed for SQL Server and .NET.


Blogs
keihatsu
Projects
Promise Language. A solution for money.

Facebook
Personal
The Arbiter Official Facebook Page

Software
The Arbiter. Decision-making software.
Hidden Desktop

Older sites. Same content. Before move.
The Arbiter. Decision-making software.
Hidden Technology
keihatsu
Projects
Traumology