Connecting to an IBM i Database
.NET applications can connect to an IBM i database using a couple methods.
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 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.