Migration of a VFP application into a Silverswitch - dFPUG

Download Report

Transcript Migration of a VFP application into a Silverswitch - dFPUG

Slide 1

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 2

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 3

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 4

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 5

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 6

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 7

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 8

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 9

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 10

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 11

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 12

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 13

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 14

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 15

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 16

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 17

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 18

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 19

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 20

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 21

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 22

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 23

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 24

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 25

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 26

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 27

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 28

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 29

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 30

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 31

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 32

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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


Slide 33

Migration of a VFP application
into a Silverswitch solution

Venelina Jordanova

Uwe Habermann

[email protected]

[email protected]

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
* MySQL, ADS, DB2, 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
* DataGrid, PickField, 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 FoxPro 9
* VFX 13 and Silverswitch
* Visual Web Developer 2010 Express
* Optional: SQL Server (Express)

* Silverlight 4 Tools
* WCF RIA Services 1 SP1
* 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 for 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 DataGrid
* 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

* CustomerController.cs
* Developer’s code

* CustomerControllerBase.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.CloudApp.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