Hi,
I installed the demo version and try to generate different layers on SQL Server.

When I generated any Class (Business/Data) for a View (which is actually join of two tables both having PKId field as their primar field) View only have one PKid Field but the resultant class generate two properties of PKId field. The generate store procedure also get the script of two parameters of PKId. Hence generating error.

My table look like

Customer:
PkId
CustomerName
CategoryID

Category
PkId
CategoryName

View

Select Customer.Pkid, Customer.CustomerName, Category.CategoryName
From Customer LEFT JOIN Category ON Customer.CategoryID=Category.Pkid


I tested the same on a View having three tables Joined and each Table have Pkid field, where as View only have one Pkid field. Generated code brings 3 PkId properties.

It is a bug?

Thank you
Devoas

Thanks for reporting the issue. The problem has been identified and will be fixed in the release 4.0.

Philip

Thanks for your reply,

Is there any workaround for the time being, as even I unselected duplicate pkID field from Select/Update Tabs, but it generate wrong code and stored procedure, leave the Property name in the code only show Type.

Sorry but i can't think of a workaround. The new version will be out the beginning of next week.

Philip

I have checked version 4 and found that now code is not creating duplicate Pkid fields but if Disable Inser/Update/Delete, still code generator try to Create Stored procedure on View for these functions and also generate BL codes for Save/Edit.

We will have a look at this.

Philip