SQL Server Compact Edition at Tech Ed EMEA

SQL Server Compact Edition is a compact database for rapidly developing applications that extend enterprise data management capabilities to the desktop and mobile clients. Ideal for distributed and embedded applications, it delivers essential relational database functionality in a small footprint while providing the same programming model and management interfaces of SQL Server. This session explores how you can leverage SQL Server Compact Edition as a local data store for client and mobile applications. We will cover designer support within Visual Studio, deployment options including ClickOnce, and the ADO.NET programming model including updatable cursors using the SqlCeResultSet. Come and learn more about how to empower your users with Windows Client Applications that work anywhere your users are.

SQL Server 2005 Compact Edition ships with two synchronization technologies, allowing you to synchronize data from the local data store back to a server. Such synchronization is a key enabler for allowing users to access their data offline, and synchronize changes with a central server when the user is back on the network. This session will cover the architectures and sync options available today, including Merge Replication and Remote Data Access. Come and learn more about how to empower your users with applications that work anywhere your users are.

Trying to build an offline enabled application? Is Merge Replication more then you need, but realized that DataSet isn’t enough and SQL Cache Dependency wasn’t designed for offline client applications? In this session we’ll demonstrate a first look at a new developer focused, componentized ADO.NET sync framework. This new sync framework will enable caching read-only data with incremental updates as well as synchronizing local changes to the central server. We’ll demonstrate synchronization over services and how you can leverage SQL Server Compact Edition as a local store.

If you're feeling confused between SQL Server Compact Edition and Express Edition, or wondering about where they fit in with Jet (database engine for Microsoft Access), this is the chalk and talk for you. Come and learn more about which scenarios each product was designed for and get guidance on where we think they should be used. Bring your questions!

Today's workforce is increasingly mobile and having the right data, in the right form, at the right place, in the right time is crucial to effectiveness. The offline capabilities user experience of an application like Microsoft Outlook allows users to be more productive. Come and see how Microsoft is providing a new generation of application architecture that helps developers more easily build offline experiences for users. Also see how Microsoft will continue to invest with future product releases of SQL Server and Visual Studio.

In this session we’ll look at the best uses of Windows Forms and WPF. We’ll look deeply at how you can integrate WPF and Windows Forms content together in the same application. We’ll also take a first look at some of the new platform features coming for client applications in the next version of the .NET Framework.