Reader Level:
Articles

Remote Data Access Layer

By guru prasad on August 24, 2004
The attached source project is a data access layer library and the main idea of developing such a DAL is to separate the database execution from the client/end user and maintain it on the server side, there by reducing the number of direct simultaneous connection to the SQL Server.
  • 0
  • 0
  • 9083
Download Files:
 

The main idea of devloping such a DAL is that, to separate the SQL execution from the client/end user and maintain it on the server side, there by reducing the number of direct simultanious (for e.g., if an application establishes 2 connections to the SQL server and 10 users are using the application there over all there are 10*2=20 connections to the sql server) connection to the sql server, and also to abstract the database implementation part from the developer, who need not know what kind of database is he working on, where is it etc.

Keeping all these in mind, the RMSDataTier was developed, which uses a remote server to listen for any sql commands (again a client helper is provided caled CommanDataWrapper.cs) and executes the same. Feel free to go through the attached folder, it has got the COMPLETE source code, Dev Env generated help file, a readme.txt , two registry setting file.

guru prasad

Guruprasad L have got around 7 years of exp. out of which more than 3.5 years in .Net technology, currently I am working as a system analyst at iSOFT R&D Pvt. Ltd - India.

COMMENT USING

Trending up