Difference between revisions of "DD Class1"
esse quam videri
(→History of Databases) |
(→ASP.NET and ADO.NET Exmaples) |
||
| Line 57: | Line 57: | ||
::70% reduction in code | ::70% reduction in code | ||
| − | ==ASP.NET and ADO.NET | + | ==Data Servers== |
| + | |||
| + | Client/Server Model | ||
| + | :Older model with dedicated clients | ||
| + | |||
| + | OLTP | ||
| + | :OnLine Transaction Processing | ||
| + | |||
| + | ==ASP.NET and ADO.NET Examples== | ||
XML File full of cheese | XML File full of cheese | ||
| Line 63: | Line 71: | ||
http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/XMLCheese.xml | 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. | |
| − | The New way. This example uses a flat file as a Data Source | ||
[http://iam.colum.edu/DD/classsource/class1/HelloData.aspx HelloData.aspx] [http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/HelloData.aspx Source] | [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 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] | [http://iam.colum.edu/DD/classsource/class1/HelloDataOld.aspx HelloDataOld.aspx] [http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/HelloDataOld.aspx Source] | ||
Revision as of 04:47, 25 January 2007
Into and Data Design
Contents
Read Syllabus
C# Review
Important c# concepts
- OOP Class2 C# fundamentals
- OOP Class3 Control Structures
- OOP Class4 Classes and Objects
- OOP Class7 Polymorphism fancy arrays
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
- http://en.wikipedia.org/wiki/Relational_database
- http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
Object DataBases
Microsoft API's
MDAC Microsoft Data Access Components
http://msdn.microsoft.com/data/learning/MDAC/
ODBC
- Data access in c. Mature open protocol
OLEDB
- Data access in c++. More abstract. Fast
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
Data Servers
Client/Server Model
- Older model with dedicated clients
OLTP
- OnLine Transaction Processing
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.
The Old way.
The old model usually involved
- Connection
- DataAdapter or DataReader
- Command
- DataSet
- DataTable
- Bindable Controls
Homework
- 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 2005
- PC Requirements Windows XP sp2 or Vista
- OS X requirements
- Microsoft Virtual PC (in the msdnaa library)
- Windows XP sp2 (in the msdnaa library)
