Difference between revisions of "DD Class1"

esse quam videri
Jump to: navigation, search
(Homework)
(Homework)
 
(6 intermediate revisions by the same user not shown)
Line 37: Line 37:
 
==Web Application Structure Application Layers==
 
==Web Application Structure Application Layers==
  
===Presentation (mostly we'll use HTML, maybe we'll look at silverlight)===
+
===Presentation ===
 
*XHTML([http://www.w3.org/TR/xhtml11/ 1.1])([http://www.w3.org/TR/xhtml2/ 2]) *HTML([http://www.w3.org/TR/html4/ 4.01])([http://www.whatwg.org/specs/web-apps/current-work/ 5])
 
*XHTML([http://www.w3.org/TR/xhtml11/ 1.1])([http://www.w3.org/TR/xhtml2/ 2]) *HTML([http://www.w3.org/TR/html4/ 4.01])([http://www.whatwg.org/specs/web-apps/current-work/ 5])
* [http://msdn2.microsoft.com/en-us/library/ms973868.aspx WebForms]
+
* [http://msdn2.microsoft.com/en-us/library/ms973868.aspx WebForms] .NET MVC Razor
 
* AJAX ([http://www.asp.net/ajax/ ajax.net])
 
* AJAX ([http://www.asp.net/ajax/ ajax.net])
 
* [http://www.adobe.com/products/flex/ Flash/Flex] Air
 
* [http://www.adobe.com/products/flex/ Flash/Flex] Air
 
* [http://silverlight.net/ SilverLight]
 
* [http://silverlight.net/ SilverLight]
 
* Google API
 
* Google API
 +
* Mobile Platforms
 +
**Android
 +
**iOS
 +
**Win Mo7
  
 
=== Buisness/Object Layer===
 
=== Buisness/Object Layer===
Line 86: Line 90:
 
LINQ
 
LINQ
 
: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
 
: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
 +
 +
Entity Framework
 +
:The ADO.NET Entity Framework enables developers to create data access applications by programming against a conceptual application model instead of programming directly against a relational storage schema. The goal is to decrease the amount of code and maintenance required for data-oriented applications.
 +
 +
http://msdn.microsoft.com/en-us/library/bb399572.aspx
 +
 +
Enterprise Library
 +
:Microsoft Enterprise Library is a collection of application blocks designed to assist developers with common enterprise development challenges. Application blocks are a type of guidance, provided as source code that can be used "as is," extended, or modified by developers for use in enterprise development projects.
 +
 +
http://msdn.microsoft.com/en-us/library/ff648951.aspx
  
 
==Data Servers==
 
==Data Servers==
Line 127: Line 141:
 
*Read Intro and Chapter 1 'Data Modeling Past and Present' in Beginning Database Design (BDD)
 
*Read Intro and Chapter 1 'Data Modeling Past and Present' in Beginning Database Design (BDD)
  
*Install Visual Studio Pro 2008
+
*Install Visual Studio Pro 2010
**PC Requirements Windows XP sp2 or Vista
+
 
**OS X requirements
+
Connect to your dd folder and post a hello aspx page.
***Microsoft Virtual PC (in the msdnaa library)
+
 
***Windows XP sp3 or Better (in the msdnaa library)
+
z:\pub\dd or pub\dd via ftp
  
Install Client tool for MSSQL 2008
+
<!--
 +
Install Client tool for MSSQL 2010 from web platform installer
  
 
  if you have trouble because on an existing MSDE or MSSQLExpress install try the SKUUPGRADE=1  argument
 
  if you have trouble because on an existing MSDE or MSSQLExpress install try the SKUUPGRADE=1  argument
 
  <cd-drive letter>:\servers\setup.exe SKUUPGRADE=1
 
  <cd-drive letter>:\servers\setup.exe SKUUPGRADE=1
  
http://msdn.microsoft.com/en-us/library/ms403393(SQL.90).aspx
+
http://msdn.microsoft.com/en-us/library/ms403393(SQL.90).aspx
  
*Create hello root website in DD folders using Visual Studio ftp see [Visual Studio Website FTP]
+
*Create hello root website in DD folders using Visual Studio ftp see [[Visual Studio Website FTP]]
 +
-->

Latest revision as of 17:33, 18 September 2011

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

http://en.wikipedia.org/wiki/List_of_hierarchical_database_management_systems

Network Databases

Relational Databases

http://en.wikipedia.org/wiki/Relational_database
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

Object DataBases

http://en.wikipedia.org/wiki/List_of_object-relational_database_management_systems

Web Application Structure Application Layers

Presentation

Buisness/Object Layer

Data/ Persisitance

What about MVC, Scafolding and ORM?

Microsoft API's

MDAC Microsoft Data Access Components

http://msdn.microsoft.com/data/learning/MDAC/


OLEDB

Data access in c++. More abstract. Fast

ODBC

Data access in c. Mature open protocol

ADO

Built on top of OLEDB to allow access from other Languages

ADO.NET

.NET Data api. Based on XML

ADO.NET 2

Part of ASP.NET 2
70% reduction in code

LINQ

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

Entity Framework

The ADO.NET Entity Framework enables developers to create data access applications by programming against a conceptual application model instead of programming directly against a relational storage schema. The goal is to decrease the amount of code and maintenance required for data-oriented applications.

http://msdn.microsoft.com/en-us/library/bb399572.aspx

Enterprise Library

Microsoft Enterprise Library is a collection of application blocks designed to assist developers with common enterprise development challenges. Application blocks are a type of guidance, provided as source code that can be used "as is," extended, or modified by developers for use in enterprise development projects.

http://msdn.microsoft.com/en-us/library/ff648951.aspx

Data Servers

Client/Server Model

Older model with dedicated clients

OLTP

OnLine Transaction Processing

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

ASP.NET and ADO.NET Examples

XML File full of cheese

http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/XMLCheese.xml

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

Homework

  • Read Intro and Chapter 1 'Data Modeling Past and Present' in Beginning Database Design (BDD)
  • Install Visual Studio Pro 2010

Connect to your dd folder and post a hello aspx page.

z:\pub\dd or pub\dd via ftp