Difference between revisions of "DD Class1"

esse quam videri
Jump to: navigation, search
(→‎Microsoft API's)
(→‎Homework)
 
(23 intermediate revisions by the same user not shown)
Line 17: Line 17:
 
If you feel you need help with c# I strongly suggest getting and reading
 
If you feel you need help with c# I strongly suggest getting and reading
  
−
[http://www.oreilly.com/catalog/learncsharp/index.html Learning C#] ,Jesse Liberty O'Reilly & Associates;<br>(September 2002), ISBN: 0596003765
+
[http://www.oreilly.com/catalog/learncsharp/index.html Learning C#] ,Jesse Liberty O'Reilly & Associates;<br>(September 2002), ISBN: 0596003765
  
 
==History of Databases==
 
==History of Databases==
Line 24: Line 24:
  
 
Hierarchical Databases
 
Hierarchical Databases
 +
:http://en.wikipedia.org/wiki/List_of_hierarchical_database_management_systems
  
 
Network Databases
 
Network Databases
  
 
Relational 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 ===
 +
*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] .NET MVC Razor
 +
* AJAX ([http://www.asp.net/ajax/ ajax.net])
 +
* [http://www.adobe.com/products/flex/ Flash/Flex] Air
 +
* [http://silverlight.net/ SilverLight]
 +
* Google API
 +
* Mobile Platforms
 +
**Android
 +
**iOS
 +
**Win Mo7
 +
 +
=== Buisness/Object Layer===
 +
*.NET DataProviders
 +
*WCF [http://msdn.microsoft.com/en-us/netframework/aa663324.aspx Windows Communcation Foundation]
 +
*[http://msdn2.microsoft.com/en-us/library/a6cd7c08(VS.80).aspx Web services]
 +
*Framework design
 +
===Data/ Persisitance===
 +
*[http://msdn2.microsoft.com/en-us/library/dz12d98w(VS.80).aspx SQL]
 +
*[http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.xmldatasource(VS.80).aspx XML]
 +
*[http://msdn2.microsoft.com/en-us/library/h43ks021(VS.80).aspx ADO.NET]
 +
*JSON
 +
 +
What about MVC, Scafolding and ORM?
 +
*[http://www.asp.net/mvc/ .NET MVC]
 +
*[http://www.asp.net/dynamicdata/ Dynamic Data]
 +
*[http://msdn.microsoft.com/en-us/netframework/aa904594.aspx LINQ]
  
 
==Microsoft API's==
 
==Microsoft API's==
  
−
MDAC Microsoft Data Access Components
+
[http://msdn.microsoft.com/en-us/library/ms810811.aspx MDAC Microsoft Data Access Components]
  
 
http://msdn.microsoft.com/data/learning/MDAC/
 
http://msdn.microsoft.com/data/learning/MDAC/
  
−
ODBC
 
−
:Data access in c. Mature open protocol
 
  
−
OLEDB
+
[http://msdn.microsoft.com/en-us/library/ms722784(VS.85).aspx OLEDB]
 
:Data access in c++. More abstract. Fast
 
:Data access in c++. More abstract. Fast
 +
 +
[http://support.microsoft.com/kb/110093 ODBC]
 +
:Data access in c. Mature open protocol
  
 
ADO
 
ADO
Line 49: Line 86:
 
ADO.NET 2
 
ADO.NET 2
 
:Part of ASP.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.
 +
 +
[http://iam.colum.edu/DD/classsource/class1/HelloData.aspx HelloData.aspx] [http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/HelloData.aspx Source]
 +
 +
The Old way.
 +
 +
The old model usually involved
 +
*Connection
 +
*DataAdapter or DataReader
 +
*Command
 +
*DataSet
 +
*DataTable
 +
*Bindable Controls
 +
 +
[http://iam.colum.edu/DD/classsource/class1/HelloDataOld.aspx HelloDataOld.aspx] [http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/HelloDataOld.aspx Source]
 +
 +
==In class==
 +
 +
Make HelloData.aspx and HelloDataOld.aspx
  
 
==Homework==
 
==Homework==
Line 54: 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)
  
−
*Read Intro and Chapter 1 'Introduction to ASP.NET 2.0 with ADO.NET' in Beginning ASP.NET 2.0 Databases (BAD)
+
*Install Visual Studio Pro 2010
 +
 
 +
Connect to your dd folder and post a hello aspx page.
 +
 
 +
z:\pub\dd or pub\dd via ftp
 +
 
 +
<!--
 +
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
 +
<cd-drive letter>:\servers\setup.exe SKUUPGRADE=1
 +
 
 +
http://msdn.microsoft.com/en-us/library/ms403393(SQL.90).aspx
  
−
*Install Visual Studio Pro 2005
+
*Create hello root website in DD folders using Visual Studio ftp see [[Visual Studio Website FTP]]
−
**PC Requirements Windows XP sp2 or Vista
+
-->
−
**OS X requirements
 
−
***Microsoft Virtual PC (in the msdnaa library)
 
−
***Windows XP sp2 (in the msdnaa library)
 

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


Retrieved from "https://imamp.colum.edu/mediawiki/index.php?title=DD_Class1&oldid=19825"