We connected dot net with as400 but it is very very slow when i am trying bring 1 lakh records
have you tried the i5_dotnet object suite ? it works perfectly for us. response time are excellent, either with complex sql stored procedure, or sql command.
you can download a trial at www.i5dotnet.com