Design and Architecture

heyitsAtul wrote:

Hi,

Can anyone suggest how to design application, which support multiple databases (like SQL Server, Oracle) and with minimum change, we can shift database from one to another.

Thanks.

heyitsAtul wrote:

Hi,

Can anyone suggest how to design application, which support multiple databases (like SQL Server, Oracle) and with minimum change, we can shift database from one to another.

Thanks.

CodingYoshi wrote:

However, if my client adds another field to Person, lets say Phone Number, then I will need to modify the database

public class Person
        {
            private string name;
            [Displayable]
            public string Name
            {
                get { return name; }
                set { name = value; }
            }
            private int age;
            [Displayable]
            public int Age
            {
                get { return age; }
                set { age = value; }
            }

            private string officialID;
            
            public string OfficialID
            {
                get { return officialID; }
                set { officialID = value; }
            }	
        }