POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Monday, May 20 • 10:30am - 11:30am
23AL Get Running with the IBM .NET Data Provider and Db2 for i

Log in to save this to your schedule, view media, leave feedback and see who's attending!

If your company is doing .NET programming alongside IBM i development, it is important to know that one of the best ways to access Db2 for i from a .NET program is to use SQL and the IBM.Data.DB2.iSeries.dll managed data provider. This session will hit all of the main steps required for using this .dll within a Visual Studio Community Edition web project.

This session seeks to show that it is no big deal to get Db2 for i data into Microsoft programs with little, if any, advance reformatting or extract steps. We'll visit installation steps, web.config syntax, and web page examples (web forms framework).

One detailed example will show how to churn out a simple inquiry on a web page using the least amount of specifications.  This will basically include a select statement, a default presentation view, IBM Db2 metadata and a little bit of c#.  The view part is specified in XHTML. We'll provide other examples and comparisons with data providers as time permits.
Learning Objectives:

  1. Help provide Microsoft developers at your company with an efficient way to access Db2 for i in real time (and without data staging prerequisites such as work files or extracts)
  2. See examples of relational DB file access used in web programming, where there is no open data path, so files are opened and closed as a part of each data access, data update process or server round-trip
  3. For DIY folks (as they call it), be able to create and run your own web page inquiry to prototype and run SQL statements

avatar for Rex Smith

Rex Smith

Sr. Developer (ERP & Web), Tegratecs Development Corp.
Rex is a Sr. Developer at Tegratecs and enjoys developing business applications in traditional IBM i environments and in web environments.   Rex enjoys interacting with customers and designing business application software that solves problems and meets user needs.  He is currently... Read More →

Monday May 20, 2019 10:30am - 11:30am PDT
Fantasy Tower North Ballroom A
  • Level Intermediate
  • Operating System IBM i
  • Audience IBM i developers who work in companies with .NET or ASP.NET programming that consumes or updates Db2 for i.