Connecting to an IBM i Database

From MidrangeWiki
Jump to: navigation, search

.NET applications can connect to an IBM i database using a couple methods.

Method 1

Method 1 gets you going pretty quickly on connecting to your IBM i database. It uses the XSD objects in DataSets.


  • Quick to create.
  • Easy wizard to set up.


  • Less control over the logic on how it gets processed.
  • Potentially slower processing times of statements.

Method 2

Method 2 involves manually setting up your connections and manually moving your data around for your program to process.


  • You have more control over how your data is processed.
  • You can build SQL statements that are extremely fast.


  • It takes longer to code.