Connecting to an IBM i Database

.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.

Pros:

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

Cons:

• 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.

Pros:

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

Cons:

• It takes longer to code.