Difference between revisions of "DD Class1"
(→Read Syllabus) |
(→Homework) |
||
(36 intermediate revisions by the same user not shown) | |||
Line 7: | Line 7: | ||
==C# Review== | ==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 | ||
+ | |||
+ | [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 13: | 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== | ||
+ | |||
+ | [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/en-us/library/ms722784(VS.85).aspx OLEDB] | ||
+ | :Data access in c++. More abstract. Fast | ||
+ | |||
+ | [http://support.microsoft.com/kb/110093 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. | ||
+ | |||
+ | [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== | ||
− | Read Intro and Chapter 1 in Beginning Database Design (BDD) | + | *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 | ||
+ | |||
+ | <!-- | ||
+ | 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 | ||
+ | |||
+ | *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
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
Web Application Structure Application Layers
Presentation
- XHTML(1.1)(2) *HTML(4.01)(5)
- WebForms .NET MVC Razor
- AJAX (ajax.net)
- Flash/Flex Air
- SilverLight
- Google API
- Mobile Platforms
- Android
- iOS
- Win Mo7
Buisness/Object Layer
- .NET DataProviders
- WCF Windows Communcation Foundation
- Web services
- Framework design
Data/ Persisitance
What about MVC, Scafolding and ORM?
Microsoft API's
MDAC Microsoft Data Access Components
http://msdn.microsoft.com/data/learning/MDAC/
- Data access in c++. More abstract. Fast
- 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.
The Old way.
The old model usually involved
- Connection
- DataAdapter or DataReader
- Command
- DataSet
- DataTable
- Bindable Controls
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