TechEd '04: Data Panel
Talking are Andrew Conrad, Luca Bologenese, Pablo Castro, Mark Fussell and Arpan Desai
- By majority vote, the US will win the World Cup
- ADO.NET about Relational Database and is the performance-driven stack. Makes data binding very easy.
- The XML hype is over and that's a good thing. "XML is a defacto developer skills." XML will be around for the next 50 years.
- XQuery is the "death star" of the data space. It will be a fundamental skill. Has lots of momentum. Next step in XML evolution. Highly likely we will see XQuery in office and BizTalk in future releases.
- SQLXML is more client side. New version with Yukon. Annotated Query refinements
- O/R - Best when the data schema is big. This space is crowd for Microsoft. ObjectSpaces is merging with WinFS. Decided that the unified presentation is the way to go. Do More With Less.
- More desired change for ADO.NET: Mixing of meta-data and data is too common. I can see this when Pablo talked about it, but it hadn't really bothered me that much.
- With SQLCLR, I can use ADO.NET. ADO.NET is a procedural API, so its better on the client. It would be very bad to do table scans with procedural code. SQLClient is available, so you can use to go off server
- XML desired change: Kill the DOM API at the beginning. Data Model fits the query language. Stonger XML URL Resolver. Performance of XmlDataDocument is ugly. Effectively a dead-end path. Use SQLXML or XPath to generate XML from relational data instead of a DataSet class.
- Bill Vaughn asked: "What is % of people will actually use O/R data access methods?" He wants strongly type stored procedures over the CRUD range. There will be a StronglyTypeAdapter in Whidbey. Billed asked for more funding for the O/R efforts. I kind of disagree with Bill's assertion that XML is just a cute meta access metaphor.
- Question about Remoting Object spaces: Yes,
- Remoting DataSets (over binary) will be supported. Kick ass. RemotingFormat property on both DataSet and DataTable.
- Talk about nullable types to work around for impedience mismatch. Generics have helped a lot.
- XML 1.1. The cost of supporting this for Microsoft exceed the cost of implement. XML 1.1 in has some backward breaking features.
- XQuery looks just like XSLT: XQuery is somewhat a middle ground between procedural languages and
- What's missing from XPath: Sort, XML generation.