RMSDataAccessLayer
By Guru Prasad

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 simultanwous connection to the sql server.

The following are the various .net concepts you will find in the RMSDAL
.Net remoting - to run the remote sql server listener

Delegates - to implement the SQL events desired by the client

Mutex threads - to ensure that that only on instance on the application is run

SqlClient namespace - to provide native connectivity to the sql server

Interop namespace - The SQL database and connection related configurations are done using an INI file (go through the attached xconfig.ini file). reading and writing on to the INI file is using standard win32 methods.

User definied exception- defined our own exceptions to be thrown on some expected cases.

File Operations- logging of data on the client side

and implementation of design patters such as singleton and abstract factory pattern

Steps to the use RMSDAL
-------------------------
1. Configure server setting using the server.reg file provided
2. configure the client setting using the client.reg file provided
3. change the xconfig.ini to suite your needs
4. start the remote server exe
5. copy RMSDataTierClient.dll and the RemoteDataTierInterface.dll 
   to the client, and add reference to the same
6. go through the method definitions and use accordingly