DD Class1

esse quam videri
Revision as of 13:12, 20 July 2009 by Jeff (talk | contribs) (Web Application Structure Application Layers)
Jump to: navigation, search

Into and Data Design

Read Syllabus

DD Syllabus

C# Review

Important c# concepts

If you feel you need help with c# I strongly suggest getting and reading

Learning C# ,Jesse Liberty O'Reilly & Associates;
(September 2002), ISBN: 0596003765

History of Databases

Flat Files

Hierarchical Databases


Network Databases

Relational Databases


Object DataBases


Web Application Structure Application Layers

Presentation (mostly we'll use HTML, maybe we'll look at silverlight)

XHTML(1.1)(2), HTML(4.01)(5), WebForms, AJAX (ajax.net), Flash/Flex, SilverLight, Google API

Buisness/Object Layer

Data/ Persisitance

What about MVC, Scafolding and ORM?

Microsoft API's

MDAC Microsoft Data Access Components



Data access in c++. More abstract. Fast


Data access in c. Mature open protocol


Built on top of OLEDB to allow access from other Languages


.NET Data api. Based on XML


Part of ASP.NET 2
70% reduction in code


language-integrated query. Native data access library extend c# and vb.net to provide naticve access to sql. http://msdn.microsoft.com/en-us/netframework/aa904594.aspx

Data Servers

Client/Server Model

Older model with dedicated clients


OnLine Transaction Processing

ADO.NET used the Data Provider and Data Consumer model.

ASP.NET and ADO.NET Examples

XML File full of cheese


The New way. This example uses a flat file as a Data Source. If also has ZERO code.

HelloData.aspx Source

The Old way.

The old model usually involved

  • Connection
  • DataAdapter or DataReader
  • Command
  • DataSet
  • DataTable
  • Bindable Controls

HelloDataOld.aspx Source

In class

Make HelloData.aspx and HelloDataOld.aspx


  • Read Intro and Chapter 1 'Data Modeling Past and Present' in Beginning Database Design (BDD)

  • Install Visual Studio Pro 2008
    • PC Requirements Windows XP sp2 or Vista
    • OS X requirements
      • Microsoft Virtual PC (in the msdnaa library)
      • Windows XP sp2 (in the msdnaa library)

Install Client tool for MSSQL 2005

if you have trouble becuase on an exsisting MSDE or MSSQLExpress install try the SKUUPGRADE=1  argument
<cd-drive letter>:\servers\setup.exe SKUUPGRADE=1