Transcript Hailstorm Press Event template

®
Visual Studio .NET
Data with XML
Carlotta Eaton (www.nr.vccs.edu/eaton)
Associate Professor of IST
New River Community College
Slides by Microsoft
Modified by Carlotta Eaton
Agenda



ADO.NET
Visual Studio .NET Tools
XML Designer
Session Prerequisites


XML Knowledge
Development Knowledge
(Web or Client Server)
Level 200
Agenda



ADO.NET
Visual Studio .NET Tools
XML Designer
ADO.NET
Key Concepts


Native Support For XML
Focuses on Most Frequent

Streaming data



Client side static data



Large result sets
Maximum throughput and performance
In-memory relational view
Separation of data, view, and database implementation
specifics
Minimize Possibility For Mistakes


Server-side static cursors
Forget to MoveNext
ADO.NET
Versus ADO





Explicit Model for Updates
XML: built-in serialization and
relational mapping
Relational object model
ForEach rather than MoveNext
Extend schema at runtime
ADO.NET
Background
Evolve ADO to multi-tier architecture
 Interoperability

 Based

on standards like XML, XSD
Scalability
 Targets
distributed, disconnected web
scenarios

Productivity
 Common
programming model over
heterogeneous data
ADO.NET
ADO.NET Architecture
Presentation Tier
Windows Forms
MyApp.exe
Data Set
Data Tier
Web Forms
IE
Data Set
Internet
Intranet
XML
Business Tier
Data Object (Class)
Data Set
SqlDataAdapter
SqlDataAdapter
Business to
Business
(BizTalk, for
example)
d
d
ADO.NET
DataSet





DataSet
Tables
Table
In memory store for client,
Columns
middle-tier data
Column
Relational view of data
Constraints
XML to the core
Constraint
Rows
 Loads/saves data as XML
Row
 Loads/saves relational
Relations
schema as XSD
Relation
Disconnected, remotable object
No knowledge of data source
ADO.NET
Typed DataSet





Class generated by the designer
Inherits from DataSet
Schema coded into the class
Concise, readable code
Compile time type checking
ds.Tables(“Customers”).Rows(0).Columns(“Name”) = _
“Steve Ballmer”
ds.Customers(0).Name = “Steve Ballmer”
ADO.NET
DataAdapter




DataSetCommand
Manages exchange
between DataSet and
data source
ADO-like connections and
commands
Interacts with DataSet to
provide disconnected
functionality
Managed Provider SDK
Connection
SelectCommand
UpdateCommand
InsertCommand
DeleteCommand
TableMappings
Agenda



ADO.NET
Visual Studio .NET Tools
XML Designer
Visual Studio .NET Tools




Component Designer
XML Designer
Schema Designer
Web Services/Web References
Visual Studio .NET Tools
Component Designer

DataAdapter Wizard
 Auto-generate
Update/Delete/Insert
statements
 Auto-config parameters collection for SQL
statements and stored procedures


Generate Typed Datasets
Table Mappings Dialog
 Map
database tables/columns to new or
existing Typed DataSets
Visual Studio .NET Tools
Web Services / Web References

Web Services
 Stream
DataSets over the wire as XML
 Publish schemas to client applications

Web References
 Discover
and consume methods, schemas
 Program against Web Services as objects
Agenda



ADO.NET
Visual Studio .NET Tools
XML Designer
XML Designer
XML Documents and Schemas


XML Documents/Data
XSD Schemas
 W3C
recommended XML schema language
 Replaces DTDs
 Describes shape/structure of XML data
 Validation of XML data
 Contracts for data exchange
 Map to relational schemas
XML Designer
XML Documents and Schemas





Visually design XML Data and
XSD Schemas
Rich XML source editing
Drag/drop creation of schemas from
database
Infer schemas from XML data
Generate typed DataSets
Summary



Data = XML = Data
ADO.NET = distributed, disconnected,
scalable, XML-based data architecture
Visual Studio .NET = RAD for multi-tier
data apps
For More Information…

MSDN Web site at


msdn.microsoft.com
Microsoft® Official Curricula (MOC)

MOC 2063


MOC 2145


Building ASP .NET Applications
Programming the Microsoft .NET Framework
with Visual Basic® .NET
MOC 2349

Programming the Microsoft .NET Framework
with C#
MSDN
Essential Resources for Developers
Subscription
Services
Library, Professional, Universal
Delivered via CD-ROM, DVD, Web
Online
Information
MSDN Online, MSDN Flash
Training &
Events
MSDN Training, Tech-Ed, PDC,
Developer Days, MSDN/Onsite Events
Print
Publications
MSDN Magazine
MSDN News
Membership
Programs
MSDN User Groups
Windows® Forms with
Web Services
Demonstration #2
Questions And Answers