DB Unaware application and webforms

[salman108]

--- Hello M8s.
I am designing an application which will be web based, and it will have an Oracle 10G DB on the back end.

I wanted to know, if it is possible to write a middle layer in C# that would make the application independent of the underlying data base schema.

I know that the schema will be revised several times, So i wanted to decide a DATA_ACCESS Component that could be used in several applications ... Like a code library in C++. The DATA_ACCESS component can be configured by a UI Admin Panel Application.

This would make the application independent of the DB Schema ..... ??

How would I go about implementing it ??? :confused:

[Shuja Ali]

yes it is a good idea to have a middle-tier data access component that will encapsulate all database related access. The implementation basically depends on your requirements.

These two links will be helpful
Implement a Data Access Layer for Your App with ADO.NET (http://msdn.microsoft.com/msdnmag/issues/03/04/DataAccessLayer/default.aspx)
The Enterprise Library Data Access Application Block (http://msdn.microsoft.com/msdnmag/issues/05/07/DataPoints/)