Difference between revisions of "Connecting to an IBM i Database"

From MidrangeWiki
Jump to: navigation, search
(Method 2)
 
Line 2: Line 2:
  
 
== Method 1 ==
 
== 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 ==

Latest revision as of 14:55, 21 July 2010

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