//----------------------------------------------------------------------------------------------------
/// <summary>
/// 아답터 생성
/// </summary>
/// <param name="table_name">테이블 이름</param>
/// <returns>데이터어답터 객체</returns>
//----------------------------------------------------------------------------------------------------
public DbDataAdapter CreateAdapter( string table_name )
{
if( !Connect() ) return null;
// Select 커멘더 생성
DbCommand command = m_connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM " + table_name;
// 어답터 생성
DbDataAdapter adapter=null;
switch(m_type)
{
case eType.SQLite: adapter = new SqliteDataAdapter((SqliteCommand)command); break;
case eType.MySQL: adapter = new MySqlDataAdapter((MySqlCommand)command); break;
case eType.MSSQL: adapter = new SqlDataAdapter((SqlCommand)command); break;
case eType.Oracle: adapter = new OracleDataAdapter((OracleCommand)command); break;
}
// Insert,Update,Delete 컴멘더 생성
DbCommandBuilder builder = null;
switch(m_type)
{
case eType.SQLite: builder = new SqliteCommandBuilder(); break;
case eType.MySQL: builder = new MySqlCommandBuilder(); break;
case eType.MSSQL: builder = new SqlCommandBuilder(); break;
case eType.Oracle: builder = new OracleCommandBuilder(); break;
}
builder.DataAdapter = adapter;
adapter.InsertCommand = builder.GetInsertCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
adapter.DeleteCommand = builder.GetDeleteCommand();
return adapter;
}