Mitecno

.NET and DB2 united with IBM DB2 .NET Data Provider

Objectives : • .NET • ADO.NET • DB2 and ADO.NET • DB2 - ADO.NET applications

ABIS Training & Consulting

1

DEMO
Win Forms client application queries DB2 according to a parameterized query

ÿþýüûúùøû÷öõûôùóòñøûðóòïûîöíû ÷öõûÿþýüû÷úòúûóøñ 1. 2. 3. 4. The .NET Framework ADO.NET DB2 & ADO.NET DB2 ADO.NET Applications

Result isdisplayed and changed by user

Changes are executed in DB2 database

TRAINING & CONSULTING

.NET and DB2 united with IBM DB2 .NET Data Provider

ABIS

2

The .NET Framework

1

ÿþýüûúùøû÷öõûôùóòñøûðóòïûîöíû ÷öõûÿþýüû÷úòúûóøñ 1. 2. 3. 4. The .NET Framework ADO.NET DB2 & ADO.NET DB2 ADO.NET Applications

Common Language Runtime (CLR) + Class Library Common Language Runtime
1.1

C++C#

VB

C++

is compiled to

IL

IL

IL

runs in
Common Language Runtime

exe

IE

IIS

SQL Srv

runs on / interpretes to
Windows
TRAINING & CONSULTING

.NET and DB2 united with IBM DB2 .NET Data Provider

ABIS

3

The .NET Framework: CLR 1. Compilation and Execution Model • source code: VB, C#, C++, COBOL, ... • result of compilation: binary filescontaining an intermediate representation of the source constructs combination of metadata and Microsoft Intermediate Language (MSIL) In order for these binaries to be executed, the CLR must be present on the target machine • execution: when these binaries are executed they cause the CLR to load the CLR then takes over and manages the execution JIT compilation (converting the MSIL as needed into thecorrect stream of instructions for the underlying processor)

ÿþýüûúùøû÷öõûôùóòñøûðóòïûîöíû ÷öõûÿþýüû÷úòúûóøñ 1. 2. 3. 4. The .NET Framework ADO.NET DB2 & ADO.NET DB2 ADO.NET Applications

TRAINING & CONSULTING

.NET and DB2 united with IBM DB2 .NET Data Provider

ABIS

4

The .NET Framework: CLR 2. The Common Type System (CTS) • The CTS defines the rules by which all types are declared,defined and managed, regardless of source language. • The CTS is designed to be rich and flexible enough to support a wide variety of source languages 3. The Common Language Specification (CLS) • interacting with code that is written in a different programming language

ÿþýüûúùøû÷öõûôùóòñøûðóòïûîöíû ÷öõûÿþýüû÷úòúûóøñ 1. 2. 3. 4. The .NET Framework ADO.NET DB2 & ADO.NET DB2 ADO.NET ApplicationsTRAINING & CONSULTING

.NET and DB2 united with IBM DB2 .NET Data Provider

ABIS

5

The .NET Framework: Class Library The Framework Class Library Any programming language (conform to CLS) can use classes Class Library includes more than 3500 classes with support for: • interaction with databases manipulating tabular and tree-structured data consuming and producing XML • corefunctionality, such as interacting with base data types; console, network and file I/O, exceptions • web-based (thin client) applications • desktop-based (thick client) applications with broad support for the Windows GUI. • SOAP-based XML web services.

ÿþýüûúùøû÷öõûôùóòñøûðóòïûîöíû ÷öõûÿþýüû÷úòúûóøñ 1. 2. 3. 4. The .NET Framework ADO.NET DB2 & ADO.NET DB2 ADO.NET Applications

1.2

TRAINING &CONSULTING

.NET and DB2 united with IBM DB2 .NET Data Provider

ABIS

6

The .NET Framework: Class Library 1. Namespace: a logical design-time naming convenience
... using System.Windows.Forms; namespace WindowsApplication1 { public class Form1 : System.Windows.Forms.Form { private TextBox textBox1; private System.Windows.Forms.Button button1; ...

ÿþýüûúùøû÷öõûôùóòñøûðóòïûîöíû÷öõûÿþýüû÷úòúûóøñ 1. 2. 3. 4. The .NET Framework ADO.NET DB2 & ADO.NET DB2 ADO.NET Applications

• class library is comprised of namespaces • each namespace contains types that you can use in your program • ‘using’ keyword (C#): to avoid fully qualified names (namespace.typename) • Namespaces provide scope: Two classes with the same name can be used in your program as long as they are in different namespaces...