Oracle Forms to C#.NET


Data base and application migration software SQLWays is capable of converting Oracle Forms applications to C#.NET using the Model View ViewModel Concept (MVVM).

Challenges

Oracle Forms include form modules, object libraries and menu modules in binary format. To convert them in C#.NET first you need to extract XML files. This can be done with the help of Oracle Forms2XML tool. Ispirer Systems offers application migration of Oracle Forms in C#.Net using MVVM.

Conversion Features:

Our automated software migration tool SQLWays converts extracted XML Oracle Forms files to WPF, using MVVM design pattern:

MVVM is designed to separate UI and business logic, and to simplify automated testing.

  • Model

The model refers to the data access layer (database).

public class Customer : IDataErrorInfo
    {
 
        public static Customer CreateCustomer(
            double totalSales,
            string firstName,
            string lastName,
            bool isCompany,
            string email)
        {
            return new Customer
            {
                TotalSales = totalSales,
                FirstName = firstName,
                LastName = lastName,
                IsCompany = isCompany,
                Email = email
            };
        }}

 

  • View

View contains all UI elements such as buttons, text boxes, check boxes etc.

For example:

Oracle Forms to C#.NET

 

In Windows Presentation Foundation, the UI layout is described in a XAML file:

<Window x:Class=" WpfApplication1.MainWindow"
  xmlns="http://schemas.microsoft.com/winfx/2006/
        xaml/presentation"
  xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
  Title="Oracle Form" mc:ignorable="d"
  xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
  xmlns:mc="http://schemas.openxmlformats.org/
           markup-compatibility/2006"
  d:DesignHeight="269" d:DesignWidth="526" 
  SizeToContent="WidthAndHeight">
    <Grid Margin="4">
      <Label Content="First _name:"
        HorizontalAlignment="Right" 
        Target="{Binding ElementName=firstNameTxt}" 
        Margin="0,51,385,147" Width="66" />
      <TextBox
        x:Name="firstNameTxt" 
        Text="{Binding Path=FirstName, 
        ValidatesOnDataErrors=True,
        UpdateSourceTrigger=PropertyChanged}" 
        Validation.ErrorTemplate="{x:Null}"
        Margin="131,51,193,147" />
      <Label Content="_Last name:"
        HorizontalAlignment="Right"
        Target="{Binding ElementName=lastNameTxt}"
        Margin="0,91,385,107" />
      <TextBox 
        x:name="lastNameTxt" 
        Text="{Binding Path=LastName, 
        ValidatesOnDataErrors=True,
        UpdateSourceTrigger=PropertyChanged}"
        Validation.ErrorTemplate="{x:Null}" 
        Margin="131,91,193,107" />
    </Grid>
</Window>
 

 

  • View Model

The view model is an abstraction of the view that also serves in mediating between the view and the model which is the target of the view data bindings.

Why SQLWays?

SQLWays automates the entire migration process of your current Oracle Forms application to C#.NET. Moreover, with SQLWays you eliminate most of associated risks and considerably reduce internal efforts. All these benefits are available at very reasonable and competitive costs, which makes database and application migration SQLWays tool even a more attractive instrument for this project type. SQLWays is also a very flexible conversion tool. Any migration direction can be developed further. It can provide conversion in the shortest terms.

Ispirer offers comprehensive engagement process for your application conversion project. For the detailed information please go to Application Migration Engagement Model page.

To order a demo of SQLWays conversion software please go to request a demo. To find out about our pricing policy go to request a quote. You can also reach us via e-mail at sales@ispirer.com or support@ispirer.com and get a professional answer to any question.

 
view a demo
request a demo
request sqlways
request a quote
.NET Versions

Microsoft .NET 4.5 and earlier

Oracle Databases

Oracle 11g, 10g, 9i, 8i, 8.0.x and 7.x

Oracle Exadata v2 and v1

Oracle News