Data Management
VT16Building Data Synchronization Clients
Bill Wolff
Tuesday, September 9, 3:15 p.m.
Online applications are very popular today but many solutions benefit from fully disconnected operation. There are new technologies for data synchronization in SQL Server 2008 and Sync Services in .NET 3.5. We will look at examples of building occasionally connected applications with intelligent data synchronization and caching. This includes Windows Forms and Windows Presentation Foundation smart clients, and .NET Compact Framework mobility clients.
VM14Creating a Custom WPF DataProvider Control
Rockford Lhotka
Monday, September 8, 3:15 p.m.
WPF has a powerful data binding mechanism, that you can leverage from XAML or code. But if you want to minimize code and maximize XAML, you’ll need to use a DataProvider control to access your data. While WPF comes with some useful DataProvider controls, there are many cases where you may need a more specialized control, or one with slightly different behaviors. Fortunately you can create your own control, and in this session you’ll learn how it is done.
VM18Building Effective Data Bound Applications with WPF and Silverlight
John Papa
Monday, September 8, 4:45 p.m.
XAML makes it easy to design robust user interfaces and it provides powerful data-binding capabilities. With WPF and Silverlight, you can perform data manipulation using code, XAML, or a combination of both. You can bind to controls, public properties, XML, or objects, making data binding quick, flexible, and easier than ever. This session will demonstrate how to use these data binding features with WPF and Silverlight applications.
VM19Data-Driven ASP.NET Ajax
Jeffrey McManus
Monday, September 8, 4:45 p.m.
Performing asynchronous postbacks using ASP.NET AJAX Update Panels is simple, but how do you go beyond the basics to provide sophisticated data visualization and user experience idioms? In this session, we'll take a look at some common data-driven user experiences and demonstrate how to implement them using ASP.NET AJAX.
VT3ASP.NET Data Binding
John Papa
Tuesday, September 9, 9:45 a.m.
Generics can enhance the implementation of a data access model. You can bind a list of objects directly to a bindable control or you can use the ADO.NET DataSet. The new data binding and data source objects in ASP.NET are a huge step forward in reducing and simplifying UI code. This session will begin by demonstrating how to use the SqlDataSource to retrieve and modify data from an OLE DB compliant database and bind it directly to an ASP.NET web form, without writing any code. The ObjectDataSource is ideal for multi layer applications as it allows data bound web controls to bind to a data source through a middle tier class library or web service. It can also be used to assist in binding either a DataSet or a list of objects using Generics. I will demonstrate these new data source tools and walk through examples of when and where each is ideal.
VW12Leverage Data Binding Against Objects
Rockford Lhotka
Wednesday, September 10, 1:45 p.m.
Visual Studio is a rapid application development (RAD) tool. For WPF, Windows and Web developers RAD means using data binding to connect the user interface to the data or business objects behind the interface. Some objects, like the DataSet, fully support data binding in all scenarios. Other objects, like those from the LINQ to SQL designer, only support a subset of the possible data binding features. In this session you’ll see the complete range of data binding features and the interfaces that enable them. Learn how to leverage data binding in all UI types, and how to implement and enable binding features in your objects.
VM4Architect Applications End-to-End with LINQ to SQL
Benjamin Day
Monday, September 8, 9:45 a.m.
LINQ to SQL is great for getting objects in and out of a relational database but how does it fit in to an n-tier application? Demos are great but how do you really use it? How should my application’s tiers be organized? What are the best practices for business objects? How do I incorporate auditing in my application? Can I use a base class for my entities? What are my options for concurrency management? How do I extend the DataContext? What are the best-practices about unit testing? What do I need to know about lazy-loading? Inheritance? How does LINQ To SQL affect my ASP.NET code?
In this session, Ben will answer these questions and more. He’ll show you what the best practices are for developing an n-tier application with LINQ to SQL and show you how your application should be architected for testability, maintenance, and performance.
VM8The ADO.NET Entity Framework and Entity Data Model
Jackie Goldstein
Monday, September 8, 11:15 a.m.
Come learn about Microsoft's newly released Object Relational Mapping (ORM) offering - the ADO.NET Entity Framework and the Entity Data Model. See how they simplify and raise the level of abstraction available for data programming. The Entity Framework is an evolution of ADO.NET that you already know and love and is built upon the standard ADO.NET Provider model which allows access to third party databases. Designers for Visual Studio are also available to make your development even more productive.
VM12LINQ Under-the-Hood: the Whys and Whens of rolling-your-own LINQ Query Provider
Richard Hale Shaw
Monday, September 8, 1:45 p.m.
Have you ever wondered how LINQ really works? How is a query statement built? How does the compiler know when to generate a SQL statement (if you're using LINQ to SQL), vs. a query of an XML document (if you're using LINQ to XML) vs. a query over objects in memory? And how do you LINQ-enable other data sources that aren't currently covered by LINQ, DLINQ or XLINQ? LINQ isn't magic: it relies on an API of static, extension methods that largely implement the Sequence Method Pattern: methods that take a sequence of objects (IEnumerable<T>), process them and return a result -- often a new IEnumerable<T>. Understanding this API, how it's implemented, how it differs from one query provider (such as DLINQ) to another (such as XLINQ) makes all the difference in how it behaves.
In this session, Richard will show you how the Standard Query Operator API works, how you can extend and intercept it, and how and when you can implement it in the form of a LINQ Query provider of your own. Along the way, we'll look at existing providers from sources outside of Microsoft, and why you may want to consider implementing your own. By the time we're finished, you'll have a clear understanding of how LINQ works.
VM16XML LINQing in the Real World
Paul Sheriff
Monday, September 8, 3:15 p.m.
LINQ technology in .NET 3.5 has some great hooks into XML that make using XML documents a breeze. This seminar will explore how you will put this technology to work in your applications. Besides the obvious advantages of using LINQ to iterate over XML data you can also use it to create and process XML documents. One great way you can use XML is in prototyping. In this session you will see how to use LINQ and XML to create faster prototypes for your customers.
You will learn:
1. Use LINQ to read XML
2. Use LINQ to write XML
3. Creating a LINQ menu system
4. How to prototype applications quickly
VM20Programming the Office 2007 Open XML File Formats using LINQ to XML
Ken Getz
Monday, September 8, 4:45 p.m.
Although the Packaging API makes it possible to manipulate the Office Open XML Formats directly, it doesn’t make it easy. The Open XML SDK provides a consistent and neat wrapper around the API, making it far easier to get to the parts you need. Once you get to the part, however, you’re still simply working with XML content. To make this easier, LINQ to XML provides a superb tool. Both Microsoft Visual C# and Visual Basic provide support for LINQ to XML, and Visual Basic adds specific features that make the process far easier. In this session, see how to use the Open XML SDK and LINQ to XML to manipulate Open XML File Formats. Special attention is paid to the issues involved in handling namespace resolution, a tricky issue in any situation.
VT5Kill Your Database: Working With Amazon SimpleDB
Mike Culver
Tuesday, September 9, 11:15 a.m.
The rise of virtualized Cloud-Based computing is shaking the industry's thinking about what it means to have a data center--in fact, what it means to have a computer.
One of the most recent technologies to pop up is virtual databases, where you literally make a Web Service call to store and access data in a database, without ever needing to set up or administer a database. Better yet, the journey from prototype to high scale requires no action on your part: it just works. But it's not SQL, and and you need to think about how to architect a Web-Scale application.
In this session we will explore the features of Amazon SimpleDB, and of course cut some code that implements SimpleDB in a C# application.
VT9SQL Server Data Services: An Introduction and Overview of Microsoft's Cloud Storage Service
Jim Williams
Tuesday, September 9, 1:45 p.m.
Microsoft’s Cloud Storage (SQL Server Data Services) was announced earlier this year. In this session we will explore the overall model, API, and programmer experience in building a small SSDS application. We’ll look into the interface, methods and data types, and options for creating and manipulating data stored with this on demand and scalable service.
VT4Programming the New T-SQL Enhancements in SQL Server 2008
Leonard Lobel
Tuesday, September 9, 9:45 a.m.
Now that SQL Server 2008 is finally arriving, get a jump start on the most important Transact-SQL (T-SQL) enhancements by attending this demo-packed session. Lenni will guide you through many powerful new T-SQL improvements, starting with Table-Valued Parameters (TVPs). Learn how to use TVPs to marshal entire sets of rows across from client to server, and to pass them between stored procedures. We’ll also dig into MERGE, a powerful new DML statement that combines the capabilities of four (or more) separate operations, and then look INSERT OVER DML, which enhances our ability to capture change data from the OUTPUT clause of any DML statement -- two very useful tools for data warehousing. New date and time features are then explored, including separate date and time data types, time zone awareness, and improvements in date and time range, storage, and precision. Attend this session and get up to speed with the newest T-SQL enhancements in SQL Server 2008!
VT8Programming the New “Beyond Relational” Features in SQL Server 2008
Leonard Lobel
Tuesday, September 9, 11:15 a.m.
This session will get you thinking "outside the box" with respect to the types of data that can be managed by a relational database system-a platform traditionally limited to handling only structured data. Join Lenni as he leads you on a guided demo-packed tour through the newest features in SQL Server 2008 designed specifically to work with semistructured and unstructured data. These new features, which include native file streaming, geospatial capabilities, and hierarchical tables, enrich the database engine by bringing more and more intelligence and programming convenience down to the database level.
You'll learn all about FILESTREAM, which greatly enhances the storage of unstructured BLOB data in the database. With FILESTREAM, database developers can finally enjoy the native ability to store large binary objects in the file system. The process is completely transparent, and even supports transactional BLOB updates. We'll then move on and build several applications that integrate location-awareness by leveraging the new geospatial data types in SQL Server 2008. With these new data types, you can now calculate and query length, area, and distance measurements against geometric shapes and geographical data. We'll also explore the new hierarchyid data type and learn how to cast a hierarchical structure over any relational table against which you can easily perform hierarchical queries and tree manipulations. You'll appreciate gaining a whole new perspective on SQL Server that extends way beyond relational tables, rows, and columns, by attending this highly charged talk.
VT12Using SQL Server 2005 Compact Edition
Jackie Goldstein
Tuesday, September 9, 1:45 p.m.
SQL Server Compact Edition is no longer limited to mobile devices you can use it to develop desktop applications as well ! This session will introduce you to SQL Server Compact Edition and show you how you can build today both standalone and occasionally connected applications with this lightweight database engine. We will discuss the various options and tradeoffs for deploying, developing, and synchronizing with a central database server. We will also show how SQL Server Compact Edition is a cornerstone of Synchronization Services for ADO.NET and will demo the tools in Visual Studio 2008 for configuring this synchronization between SQL Server and SQL Server Compact Edition.
VT16Building Data Synchronization Clients
Bill Wolff
Tuesday, September 9, 3:15 p.m.
Online applications are very popular today but many solutions benefit from fully disconnected operation. There are new technologies for data synchronization in SQL Server 2008 and Sync Services in .NET 3.5. We will look at examples of building occasionally connected applications with intelligent data synchronization and caching. This includes Windows Forms and Windows Presentation Foundation smart clients, and .NET Compact Framework mobility clients.
VT20SQL Server 2008 Reporting and Dashboards
Bill Wolff
Tuesday, September 9, 4:45 p.m.
Learn about advanced techniques for building reports with SQL Server 2008 Reporting Services and the Visual Studio-based Report Designer. Topics include rich formatting with the new Tablix control, new chart options from the Dundas acquisition, rendering as Word or Excel using the SoftArtisan technology, defining expressions, parameterized reports (data driven, multivalued, and hierarchical), handling multiple data sources (including relational, multi-dimensional, and XML), and making reports interactive. You will see how to manage and distribute reports in Report Manager and SharePoint 2007 integration including Performance Point 2007. There will be walkthroughs of sample reports and tips and tricks for using the Report Definition Language (RDL) and the new Report Builder.
VW18Database Change Management Using Team System 2008
Sajee Mathew
Wednesday, September 10, 4:45 p.m.
Ever make a bunch of changes to your database then lose track of what you've changed? Frustrated with trying to come up with consistent, "meaningful" test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you're not part of the team? We'll take a look at how Team System can help ease the pain of database development and change management.
VW20Oracle for SQL Server Developers
Benjamin Day
Wednesday, September 10, 4:45 p.m.
We’re not alone. There’s something out there in the darkness -- OMG! It’s
