Hi Bernard;

   Note that the new .Net Core features like the C# Web API only support Oracle 12C and 18C.

  What version of Oracle are you using?

FYI: https://www.appeon.com/support/documents/appeon_online_help/powerbuilder/features_list

Regards ... Chris

Hi Chris,

We are currently using Oracle 11g and planning to migrate in Oracle 12C before the end of the year.

Is that means we cannot test our application in C# Web API environment before that date?

I really appreciate your contribution.

Thanks,

Bernard

Hi Bernard,

This can be a problem with the Property attribute [Identity] that is applied to your model directly.

Look for this attribute directly in your model and remove it since this applies to SQL Server. See the following example of a model with the [Identity] property attribute:

using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SnapObjects.Data;

namespace MMDemo.Models
{
    [FromTable("Customer", Schema = "dbo")]
    [SqlOrderBy("Id ASC")]
    public class Customer
    {
        [Key]
        [Identity] // Remove this line of code!
        public int Id { get; set; }

        [MaxLength(15)]
        [Required]
        public string Fname { get; set; }

        [MaxLength(20)]
        [Required]
        public string Lname { get; set; }

        [MaxLength(35)]
        [Required]
        public string Address { get; set; }

        [MaxLength(20)]
        [Required]
        public string City { get; set; }

        [MaxLength(2)]
        [Required]
        public string State { get; set; }

        [MaxLength(10)]
        [Required]
        public string Zip { get; set; }

        [MaxLength(12)]
        [Required]
        public string Phone { get; set; }

        [MaxLength(35)]
        public string Company_name { get; set; }
    }
}

Regards,

Hi Govinda,

I have no Property attribute [Identity] applied in my model. I'm using .Net DataStore to access objects and C# Data Model Generator must convert DataWindows to .Net DataStore.

Here is an example of DataWindows (D_toolbars) without any SQL statement migrate from original PowerBuilder application to the web (C# code):

using System;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SnapObjects.Data;

namespace NetDataStore.DataWindows
{
    public class D_Toolbars
    {
        [PropertySave(SaveStrategy.Ignore)]
        public String Toolbarvisible { get; set; }

        [PropertySave(SaveStrategy.Ignore)]
        public String Toolbarname { get; set; }

    }
} 

Regards,

Bernard

Yes,

I can confirm I had exactly the same problem.

Tried to install an Oracle 12c Client, but no luck. It's the Database Server which has to be minimum 12c and now it works well.

What I will try is:

- generate the DataModel, using a 12c database

- see if after that I can run on an 11g database.

A shame really because lots of our customers are still on 11g.

regards,

I'm wondering if it would work with an Oracle 11 ODBC connection. Something I'll try and get back on.

Hi All,

I'm back again with my Oracle 11g issue while waiting  Database Oracle 12C been installed.

While waiting I have 3 folders created in SnapDevelop : Controllers, DataWindows and Services.

Datawindows in my app without SQL statement (around 10 dw) are migrated from PowerBuilder to DataWindows folder.

Into Controllers folder I've only the file SampleController.cs and only files SampleService.cs and ISampleService.cs.

Based on MVC model, I was expecting to see all controllers and Services files of my application generated at the same time than the datawindows.

Does someone having the same concerns?

Thank you for your assistance.