public bool Insert(Classe classe)
        {
            System.Data.IDbConnection objConexao;
            System.Data.IDbCommand objCommand;
            string sql = "INSERT INTO TABELA(CAMPO) VALUES (?valor)";

            objConexao = Mapped.Connection();
            objCommand = Mapped.Command(sql, objConexao);

            objCommand.Parameters.Add(Mapped.Parameter("?valor", classe.variavel));

            objCommand.ExecuteNonQuery();
            objConexao.Close();
            objCommand.Dispose();
            objConexao.Dispose();

            return true;
        }




         public Coordenador Select(int id)
         {
             Classe obj = null;

             System.Data.IDbConnection objConexao;
             System.Data.IDbCommand objCommand;
             System.Data.IDataReader objDataReader;

             objConexao = Mapped.Connection();
             objCommand = Mapped.Command ("SELECT * FROM TABELA WHERE CODIGO = ?codigo", objConexao);
             objCommand.Parameters.Add(Mapped.Parameter("?codigo", id));

             objDataReader = objCommand.ExecuteReader();
             while (objDataReader.Read())
             {
                 obj = new Classe();
                 obj.Codigo = Convert.ToInt32(objDataReader["CAMPO_BD"]);
             }

             objDataReader.Close();
             objConexao.Close();

             objCommand.Dispose();
             objConexao.Dispose();
             objDataReader.Dispose();

             return obj;
         }




         public DataSet SelectAll()
         {
             DataSet ds = new DataSet();

             System.Data.IDbConnection objConexao;
             System.Data.IDbCommand objCommand;
             System.Data.IDataAdapter objDataAdapter;

             objConexao = Mapped.Connection();
             objCommand = Mapped.Command("SELECT * FROM TABELA", objConexao);
             objDataAdapter = Mapped.Adapter(objCommand);
             objDataAdapter.Fill(ds);

             objConexao.Close();

             objCommand.Dispose();
             objConexao.Dispose();

             return ds;
         }