ADO.NET - Chapter 12 ADO.NET Introduction to Database...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 12 ADO.NET
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Introduction to Database
Background image of page 2
Computer Science: the science of data processing using a computational device. Database (DB) : a persistent store of data in a compact, secure, easy-and-fast-to-retrieve form. Database Engine: a software program that creates and manages databases. (e.g. MS Jet Engine) Database Management System (DBMS): a database engine plus user interfaces and other supporting software. DBMS Examples: Oracle, DB2 (IBM), Sybase, Informix, Microsoft SQL Server, Microsoft Access, MySQL (public domain), … Database Server : a DBMS that provides data to its remote clients. X-Base: a DBMS that does not support remote clients. . Definitions
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Definitions Cont. Database API: application programming interface to DBMSs. Database Table: data are stored in a database as “tables”. Each row of a table is called a record, each column of a table is called an attribute. PhoneBook (Database Table Name) Name Office Home Cell Tom 330-972-5809 330-888-8888 330-168-8888 John 330-972-7777 330-777-7777 330-168-7777 Database schema: meta data for databases, defining tables and their attributes.
Background image of page 4
SQL SQL: Structured Query Language, a standardized language for accessing and manipulating databases. The Select-From-Where Clause: Select Office From PhoneBook Where Name=’Tom’; Select * From PhoneBook; Three Parts of SQL: Query: data retrieval DML - Data Manipulation Language: inserting, deleting, updating, … DDL - Data Definition Language: table creation, alteration and drop.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
SQL Example CREATE DATABASE pubs; USE pubs; CREATE TABLE authors ( au_id varchar(11) NOT NULL, au_lname varchar(40) NOT NULL, au_fname varchar(20) NOT NULL, phone char(12) NOT NULL DEFAULT 'UNKNOWN', address varchar(40) NULL, city varchar(20) NULL, state char(2) NULL, zip char(5) NULL, contract bit NOT NULL, PRIMARY KEY(au_id) );
Background image of page 6
SQL Example insert authors values('409-56-7008', 'Bennet', 'Abraham', '415 658-9932', '6223 Bateman St.', 'Berkeley', 'CA', '94705', 1); insert authors values('213-46-8915', 'Green', 'Marjorie', '415 986-7020', '309 63rd St. #411', 'Oakland', 'CA', '94618', 1);
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DBMS Example: SQL Server By Microsoft Free trial version (180 days) http://www.microsoft.com/sql/downloads/trial-software.mspx Latest version: SQL Server 2005 Needs runtime license Best fit for .NET Features http://www.microsoft.com/sql/prodinfo/features/top30features.mspx Installed on WP Server (130.101.10.134) with pubs database created.
Background image of page 8
DBMS Example: MySQL By MySQL AB Free: http://dev.mysql.com/ Latest version: MySQL 5.0 No need of runtime license Not the best fit for .NET Reference menu: http://dev.mysql.com/doc/refman/5.0/en/index.html How to install it at home: http://www.cs.uakron.edu/~xiao/windows/MySQL-Installation.html Installed on WP Server (130.101.10.134) with pubs database created.
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Database Programming
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/09/2008 for the course CS 408 taught by Professor Xiao during the Spring '08 term at The University of Akron.

Page1 / 41

ADO.NET - Chapter 12 ADO.NET Introduction to Database...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online