Transcript 1 Migrating VFP forms with the free Silverlight Wizard of the dFPUG

Migrating VFP forms with the free
Silverlight Wizard of the dFPUG
Venelina Jordanova
Uwe Habermann
[email protected]
[email protected]
Agenda Saturday
2:15 - 3:30 Migrating VFP forms with the free
Silverlight Wizard of the dFPUG
3:45 - 5:00 Migration of a VFP application into a
Silverswitch solution for Visual Studio
5:15 - 5:45 Extending a Silverlight application
with a webcam and multi-touch
5:45 - 6:30 Usage of VFP code in the back-end
of Silverswitch applications
Agenda Sunday
8:30 - 9:45
Programming VFP Code in the
front-end of Silverswitch applications
10:00 - 11:15 Conversion of a VFX application into
a Silverswitch solution
11:30 – 12:15 Converting reports to Silverswitch
and running VFP reports in
Silverswitch
12:15 – 12:45 What else do I need to know
Who is talking?
* Venelina Jordanova
* Master Degree in CS
* FoxPro Entwicklerin
seit FPD 2.0
* MCP für SQL Server
und Application
Architecture
* Uwe Habermann
* Diplom-Informatiker
* FoxPro Entwickler
seit FPW 2.5
* MCP für Visual FoxPro
V&U Ltd. – We and You
* Development in Varna, Bulgaria
* Projects with VFP and Silverlight
* Visual Extend, Silverswitch
* High quality for low prices
* www.VandU.eu
* [email protected]
One year since SWFOX 2010
* Visual Studio 2010, Silverlight 4
* Migration of existing VFP applications
with wizards to Silverlight
One year since SWFOX 2010
* dFPUG – Silverlight Wizard
* VFX – Silverlight Wizard
* Silverswitch
The result
* www.VandU.eu/VFPizza.htm
Migrated application
* Internet application
* Desktop application
* Execute VFP Code
* At the client
* At the server
* Supported databases
* DBC
* SQL Server
* MDI user interface
Why Silverlight?
* Internet applications
* Desktop applications
* Platform independent
* Data binding
* Execution of VFP Code
* Use of VFP databases
Why Silverlight?
* Modern user interface
* XAML
* Multi-touch support
* Animations, reflections, shadows…
Why Silverlight?
* Fulfills all wishes of VFP developers
* FREE development tools
* FREE distribution to customers
What is Silverlight?
* Silverlight is a powerful development
platform for creating engaging,
interactive user experiences for Web,
Desktop and mobile applications
when online or offline
Requirements for developers
* Visual FoxPro 9
* dFPUG – Silverlight Wizard
* Sedna – Upsizing Wizard
* Visual Web Developer 2010 Express
* SQL Server 2008 (Express)
* Silverlight 4 Tools
Requirements for customers
* Client
* Silverlight 4 Plug-In (6 MB)
* Server
* Windows Server
* Internet Information Server
* .Net Framework 4.0
Example
* Migration of Tastrade
* VFP sample application
* Uses VFP database
* Coming not complete with last
versions of VFP
* But complete on the memory sticks
Tastrade
* A short view at Tastrade
What does the
dFPUG – Silverlight Wizard do?
* Migration of the layout and the
data binding of forms
* Generation of Silverlight forms into a
Silverlight Business Application
* Generation of links to start forms
What does the
dFPUG – Silverlight Wizard do?
* Works with any VFP application
* Any?
Requirements for the
dFPUG – Silverlight Wizard
* Database
* Primary key in every table
* Dataenvironment
* All tables
* No views or cursoradapters
* No programmatical use of tables supported
Requirements for the
dFPUG – Silverlight Wizard
* All controls in the form
* No programmatical instantiation of
visual controls at runtime
* Migration of base classes of controls
* No migration of code
dFPUG – Silverlight Wizard
How does it work?
* Upsizing to SQL Server
* Create Silverlight Business Application
* ADO.NET Entity Data Model
* Domain Service
* dFPUG – Silverlight Wizard
* Test
* Business logic
SQL Server Upsizing Wizard
* Use Upsizing Wizard of Sedna!
* http://vfpx.codeplex.com/wikipage?title=Sedna
* Upsize VFP database to SQL Server
* Structure
* Data
Create a
Silverlight Business Application
* New project
* Data model (connection, data access)
* Domain service (web service)
New project
* Template project
* Silverlight Business Application
What does it contain?
* Client project (Tastrade)
* Silverlight project
* Forms
* MainPage.xaml
* Home.xaml
* About.xaml
What does it contain?
* Server project (Tastrade.Web)
* Startup project, start page
* Folder for data model
* Folder for domain service
* Tastrade.xap
* First test
Add data model
* ADO.NET Entity Data Model
* Connection to SQL Server database
* Server:
* Database:
.\SQLEXPRESS
Tastrade
* Build project!
Add domain service
* Domain Service Class
* Actually web service
* Select tables
* General rule: set all checkmarks
* Code for data access gets generated
* A short view at the code
* Build solution!
The server project is ready!
Now the client project
and is done by the
dFPUG – Silverlight Wizard 
dFPUG – Silverlight Wizard
* Freeware
* On the memory sticks 
* FREE migration of VFP projects to
Silverlight
* Layout of forms
* Execution of forms
dFPUG – Silverlight Wizard
* 1. What does this wizard do?
* 2. Select VFP project
* 3. Select Silverlight Business Application
* 4. Select forms
* 5. Select properties
* Properties, which should be set by styles,
should not be migrated
dFPUG – Silverlight Wizard
* Finish!
* Forms are opened in the VFP Form Designer
* Controls are read
* Silverlight forms are created
* Test
Where can I run the application?
* Windows
* Internet-Explorer
* Firefox
* Chrome
* Opera
* (Safari
officially not supported)
Where can I run the application?
* Mac OS
* Safari
* Firefox
* Chrome
* Opera
Where can I run the application?
* In the future on Linux
* Firefox
* Chrome
* Right now Silverlight Plug-In Version 3.99
The result
* Migrated layout
* Execution possible
A short view at
the generated files
* <form name>.xaml
* <form name>.xaml.cs
* MainPage.xaml
* MainPage.xaml.cs
What to do now?
Code examples
* Save
employeeDomainDataSource.SubmitChanges();
* Next
employeeDomainDataSource.DataView.
MoveCurrentToNext();
* Previous
employeeDomainDataSource.DataView.
MoveCurrentToPrev();
Advantages
* Quickly and simply generated base for a
Silverlight development
Restriction
* Silverlight application runs with
* SQL Server database
* But not with VFP database
dFPUG – Silverlight Wizard
* Video tutorial (in German) available at
http://www.MSDN-Solve.de
* and on the memory sticks
Any questions?
Thank you very much and
have fun with VFP and Silverlight
Venelina & Uwe