Difference between revisions of "DD Class1"
(→Microsoft API's) |
(→Web Application Structure Application Layers) |
||
Line 38: | Line 38: | ||
===Presentation (mostly we'll use HTML, maybe we'll look at silverlight)=== | ===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 | + | 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], AJAX ([http://www.asp.net/ajax/ ajax.net]), [http://www.adobe.com/products/flex/ Flash/Flex], [http://silverlight.net/ SilverLight], Google API |
=== Buisness/Object Layer=== | === Buisness/Object Layer=== | ||
− | |||
*.NET DataProviders | *.NET DataProviders | ||
− | *WCF Windows Communcation Foundation | + | *WCF [http://msdn.microsoft.com/en-us/netframework/aa663324.aspx Windows Communcation Foundation] |
− | *Web services | + | *[http://msdn2.microsoft.com/en-us/library/a6cd7c08(VS.80).aspx Web services] |
*Framework design | *Framework design | ||
===Data/ Persisitance=== | ===Data/ Persisitance=== | ||
− | *SQL | + | *[http://msdn2.microsoft.com/en-us/library/dz12d98w(VS.80).aspx SQL] |
− | *XML | + | *[http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.xmldatasource(VS.80).aspx XML] |
− | *ADO.NET | + | *[http://msdn2.microsoft.com/en-us/library/h43ks021(VS.80).aspx ADO.NET] |
*JSON | *JSON | ||
What about MVC, Scafolding and ORM? | What about MVC, Scafolding and ORM? | ||
− | *.NET MVC | + | *[http://www.asp.net/mvc/ .NET MVC] |
− | *Dynamic Data | + | *[http://www.asp.net/dynamicdata/ Dynamic Data] |
− | *LINQ | + | *[http://msdn.microsoft.com/en-us/netframework/aa904594.aspx LINQ] |
==Microsoft API's== | ==Microsoft API's== |
Revision as of 13:12, 20 July 2009
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 (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
- .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
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 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
http://msdn.microsoft.com/en-us/library/ms403393(SQL.90).aspx
- Modify the http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/XMLCheese.xml and the HelloData.aspx page to show some of your own data