MBL324使用SQLServerEverywhere开发WindowsMobile最佳…….pptVIP

* * ? 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION. 4 Minutes SQL Ev Runtime MSI is previously installed Create new project Choose SQL Mobile database Choose Northwind.sdf Choose all tables Change Orders to details Change customers, employees, ship via to a combo box, Order_Id to a label Drag Orders to the form F5 Works as we already have SQL Ev centrally installed Show Solution Explorer basic editing experience Create New Database Password, encryption Create table Column Types Show Data – Query Builder 8 Mins Shutdown VS Uninstall SQL Ev via Add remove programs to demonstrate end user experience Relaunch VS with the previous designer demo ClickOnce / Admin scenario Publish the app w/o making any changes Note runtime exception as it can’t find the SQL Ev engine Go back to VS and add the SQL Ev Pre-Req Republish the app – not clean / fast installation Note failure due to data directory resolution Go to settings and change the .\ to |DataDirectory|\ Publish again –voila Non Admin Scenario Remove Click Once Pre-Req Open folder for SQL Ev runtime C:\Program Files\Microsoft SQL Server Everywhere\v3.1 Explain installation model Copy the dlls, gac the ado provider, that’s it No services running Runs side by side so Orcas SQL Ev will not change SQL Ev 3.1 Imagine side by side with SQL Express Copy the engine dll’s to the proje