Migration of a VFP application into a Silverswitch

Migration of a VFP application into a Silverswitch solution Venelina Jordanova Uwe Habermann Venelina@Vand. U. eu Uwe@Vand. U. eu

Silverswitch

Silverswitch * Rapid Application Development development environment for Silverlight * Silverswitch. sln * Migration of VFP applications * VFX – Silverlight Wizard * Visual Extend for VFP re-developed in C#

Silverswitch * Supported databases * VFP * SQL Server * My. SQL, ADS, DB 2, Oracle, …

Silverswitch * Programming * C# * VFP at the server side with COM server * Powerful method call even from client side * VFP at the client side with GUINEU * Execution also on Mac OS and in the future on other platforms

Silverswitch What does it contain? * Template application Silverswitch. sln * Start page * Wizards * Update Project * Builders * Data. Grid, Pick. Field, Form * VFX – Silverlight Wizard * Included in VFX for VFP

Migration to Silverswitch * VFP projects * VFX projects

Requirements for the VFX – Silverlight Wizard * Database * Primary keys for all tables * Dataenvironment * Tables * Cursoradapters * No views * No programatical used tables

Requirements for the VFX – Silverlight Wizard * All controls in the form * No instantiation of controls at runtime * VFP projects * Base classes of controls are migrated * VFX projects * VFX classes of controls are migrated

Requirements for the development * Visual Fox. Pro 9 * VFX 13 and Silverswitch * Visual Web Developer 2010 Express * Optional: SQL Server (Express) * Silverlight 4 Tools * WCF RIA Services 1 SP 1 * Silverlight 4 Toolkit

Requirements at the customer‘s side * Client * Silverlight 4 Plug-In (6 MB) * Server * Windows Server * Internet Information Server *. Net Framework 4. 0

Creation of a Silverswitch application * Create new project based on template project “Silverswitch” * Don’t execute, don’t build * Run VFX – Silverlight Wizard

VFX – Silverlight Wizard * * What does this wizard do? Explanation VFP COM server is generated Administrator rights required!

VFX – Silverlight Wizard * Select Silverswitch solution

VFX – Silverlight Wizard * * Data access Create ADO. NET Entity Data Model Create Domain Service Create and register VFP COM server

VFX – Silverlight Wizard * Settings of the application object * Add VFX forms to table Vfxfopen

VFX – Silverlight Wizard * Select forms * Forms marked as included into the project get migrated by default * VFX*. scx forms do not get migrated

VFX – Silverlight Wizard * Project names forms * Forms can be summarized to projects * Optimization of project size and download size and time

VFX – Silverlight Wizard * Select form properties * Layout similar to VFP -> select all properties * Hard-coded property values cannot be overwritten by styles

VFX – Silverlight Wizard * Select reports * Reports, marked as included into the project, get migrated by default

VFX – Silverlight Wizard * Finish! * Success message or Log * Test!

Features of the Silverswitch application * * * * Prepared frame for the application Splash screen Optional login dialog Toolbar with XAML icons Data-driven open dialog Internet application Intranet application

Features of the Silverswitch application * * * User login Runtime localization User management User rights User groups MDI user interface

Features of generated forms * * * Autoedit New, edit, delete, save, undo Navigation Sort and incremental search in Data. Grid Resizable, minimize, maximize

Features of generated forms * Treatment of update conflicts * Filter dialog

What does the VFX – Silverlight Wizard do? * Add forms to the solution * Entry in table Vfxfopen * Migration of forms * MVP Model-View-Presenter

What does the VFX – Silverlight Wizard do? * Example * Customer. xaml * Layout * Customer. xaml. cs * Settings * Customer. Controller. cs * Developer’s code * Customer. Controller. Base. cs * Generated code

What does the VFX – Silverlight Wizard do? * Generates VFP COM server * Data access to VFP database using cursoradapters

VFX – Silverlight Wizard * Video tutorial (in German) available at * www. MSDN-Solve. de * and on the memory sticks

VFPizza in the Cloud * * * * Inform! Create account Create SQL Server database Make project settings Publishing with Visual Studio wizard 2 virtual maschines recommended http: //VFPizza. Cloud. App. net

VFPizza in the Cloud * Video tuorial (in German) available at http: //www. MSDN-Solve. de * and on the memory sticks

Any questions?

Break Venelina & Uwe