Difference between revisions of "Connecting to an IBM i Database"
From MidrangeWiki
(Created page with '.NET applications can connect to an IBM i database using a couple methods. == Method 1 == == Method 2 == Category:.NET_FAQ') |
|||
(One intermediate revision by the same user not shown) | |||
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 == | ||
+ | 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. | ||
[[Category:.NET_FAQ]] | [[Category:.NET_FAQ]] |
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.