UIC CS 340 - Lecture 11- DB-Programming (31 pages)

Previewing pages 1, 2, 14, 15, 30, 31 of 31 page document View the full content.
View Full Document

Lecture 11- DB-Programming



Previewing pages 1, 2, 14, 15, 30, 31 of actual document.

View the full content.
View Full Document
View Full Document

Lecture 11- DB-Programming

31 views

Lecture Notes


Pages:
31
School:
University of Illinois at Chicago
Course:
Cs 340 - Software Design
Software Design Documents

Unformatted text preview:

Lecture 11 Programmatic Database Access with ADO NET Objectives Programmatic database access typically involves executing SQL queries using classes from the language s framework In NET the Active Data Objects ADO classes in the FCL are the primary means of database programming ADO NET is a vendor neutral object oriented SQL based approach Architecture of ADO NET Basic database access Application design Updating a database DataSets Introducing Microsoft J in Visual Studio CS using NET NET 11 2 Part 1 Architecture of ADO NET Introducing Microsoft J in Visual Studio CS using NET NET 11 3 Relational technology ADO NET is designed to access relational databases Example Sales database with customers orders and products Introducing Microsoft J in Visual Studio CS using NET NET 11 4 Architecture ADO NET architecture based on data providers data providers encapsulate DB specific details NET Programmer ADO NET Data Provider DB Introducing Microsoft J in Visual Studio CS using NET NET 11 5 Existing data providers NET currently ships with 4 data providers one for Microsoft SQL Server one for Oracle one for older OLEDB technology used for ADO VB6 one for older ODBC Open Database Connectivity technology More third party providers are available Oracle s own provider http otn oracle com tech windows odpnet DB2 http www7b software ibm com dmdd downloads dotnetbeta MySQL http www mysql com http crlab com mysqlnet etc Introducing Microsoft J in Visual Studio CS using NET NET 11 6 ADO NET object model ADO NET is an object oriented approach Classes are spread across a number of FCL namespaces some are provider neutral others are provider specific System Data provider neutral System Data Common SQL Server System Data SqlClient other DBs e g MS Access System Data OleDb ODBC Open Database Connectivity System Data Odbc Introducing Microsoft J in Visual Studio CS using NET NET 11 7 Part 2 Basic database access Introducing Microsoft J in Visual Studio CS using NET NET 11 8 Overview of



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Lecture 11- DB-Programming and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Lecture 11- DB-Programming and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?