public void SetConnectionString(sqlServerTypeEnum sqlServerType)
{
switch (sqlServerType)
{
case sqlServerTypeEnum.sqlServer:
_connectionString = ConfigurationManager.ConnectionStrings["sqlConnectionString"].ConnectionString;
break;
case sqlServerTypeEnum.sqlServerExpress:
_connectionString = ConfigurationManager.ConnectionStrings["sqlExpressConnectionString"].ConnectionString;
break;
default:
throw new ServerNotSupportedException();
}
}
public void SetServer(sqlServerTypeEnum sqlServerType)
{
switch (sqlServerType)
{
case sqlServerTypeEnum.sqlServer:
_server = new Server(@".");
break;
case sqlServerTypeEnum.sqlServerExpress:
_server = new Server(@".\SQLEXPRESS");
break;
default:
throw new ServerNotSupportedException();
}
}
private void InitializeCompenent(sqlServerTypeEnum sqlServerType)
{
SetConnectionString(sqlServerType);
_sqlConnection = new SqlConnection(_connectionString);
_sqlCommand = _sqlConnection.CreateCommand();
}
