private static DbDataAdapter GetAdapter(ConnectionType connectionType, string connectionString, string sqlText, string[] parameterValues)
{
DbDataAdapter adapter = null;
switch (connectionType)
{
case ConnectionType.SqlServer:
adapter = new SqlDataAdapter();
break;
case ConnectionType.Odbc:
adapter = new OdbcDataAdapter();
break;
case ConnectionType.OleDb:
adapter = new OleDbDataAdapter();
break;
case ConnectionType.Oracle:
adapter = new OracleDataAdapter();
break;
}
adapter.SelectCommand = (DbCommand)DatabaseHelpers.CreateCommand(connectionType, connectionString, sqlText, parameterValues, 60);
return(adapter);
}
