Server independent in c # Project

o abuzaid

6y797Learn iOS Programming

i appriciate if any one can let me know how a project can be server name independence ?

this means can be run in different servers names with small changes

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kiran Mohanty5y ago
Accepted answer
1. <connectionStrings>
2. <add name="Database1" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Database1;Integrated Security=True;" providerName="System.Data.SqlClient" />
3. <add name="Database2" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Database2;Integrated Security=True;" providerName="System.Data.SqlClient" />
4. <add name="Database3" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Database13;uid=sa;pwd=sa;" providerName="System.Data.SqlClient" />
5. connectionStrings>
If you wish to switch between databases in SQL, then you should define multiple connection strings and then point your application to the specific database via connection string name . Above code may help you in this scenario.

But if you wish to switch between providers (like SQL or Oracle or OLE db), then you may have to use Factory design pattern.
o abuzaid5y ago
thanks kiran your answer is helpful
o.
o abuzaid5y ago
thanks Sachin
Sachin Singh5y ago
- If you just want to switch between different databases inside same server then define different connection strings.
- if you want to switch between different servers thenuse Interface and change your architecture like below, this is just an example you could use DI
public interface IDAL where T:class
    {
      IEnumerable GetAll();
      T GetById(int Id);
      void Save(T obj);
      void Update(T obj);
      void Delete(int Id);
    }

Public Class SqlDAL: IDAL where T:class
    {

public IEnumerable GetAll()
        {
             implement it
        }

and implment all

}

Public Class OracleDAL: IDAL where T:class
    {

public IEnumerable GetAll()
        {
             implement it
        }

and implment all

}



In your Business layer Don't use concrete Obj just use interface

public class EmployeeBusiness
{
IDAL _db=null;
public  EmployeeBusiness(IDal db)
{
    _db=db;
}
Public Void SaveEmployee(Employee emp)
{

_db.Save(emp);

}

Your application layer

public class web/mvc controller/console
{

public void Save(){

EmployeeBusiness ebo= new EmployeeBusiness(new OracleDAL())

ebo.Save(emp);

}
o abuzaid5y ago
i mean Database Server please if you have an idea
thanks
omran
Sachin Singh6y ago
are you talking about database server or Hosting Platform?