Hi,

I have a table that I wish to create a self join on the entity in the designer (according to the documentation I can). The PK is DataID and there is a field called ParentID which is a reference as to what owns it, going many child levels deep. In designer I can add the relationship and generate the code, but when I build my project it complains that DataID already exists. When I remove the relationship, everything works.

Any ideas?

Please can you post the code of the class that fails to build?

Matt

I think this is related to a fix we have released recently for the templates. Please update your templates (for v2.6 that is) with the latest templates archive from the customer area and try again.

Thanks! I will try it today.

this fix: Fix Templates 2.6 03112009 11-Mar-2009 .NET 2.0+: 1:1 relations with self caused entities to refer to the wrong relations for referrals to the PK side.

I downloaded v2.6 and tried the self join in designer. Everything still generates fine, but the code will not compile. The error is that it states there is already a reference of <objectname>. I remove the relation and everything works.

I also tried adding only one side of the relation but that returns a different error when you try and compile the code

Invalid expression term ',' C:\Projects\Momentum.DCAA\Momentum.DCAA.DataLayer\Momentum.DCAA.DataLayer.LivelinkExtended\EntityClasses\DtreeEntity.cs 681 30  Momentum.DCAA.DataLayer.LivelinkExtended
    ) expected  C:\Projects\Momentum.DCAA\Momentum.DCAA.DataLayer\Momentum.DCAA.DataLayer.LivelinkExtended\EntityClasses\DtreeEntity.cs 681 32  Momentum.DCAA.DataLayer.LivelinkExtended
    ; expected  C:\Projects\Momentum.DCAA\Momentum.DCAA.DataLayer\Momentum.DCAA.DataLayer.LivelinkExtended\EntityClasses\DtreeEntity.cs 681 38  Momentum.DCAA.DataLayer.LivelinkExtended
    Invalid expression term ')' C:\Projects\Momentum.DCAA\Momentum.DCAA.DataLayer\Momentum.DCAA.DataLayer.LivelinkExtended\EntityClasses\DtreeEntity.cs 681 38  Momentum.DCAA.DataLayer.LivelinkExtended

Any ideas?

• Please generate code to an empty folder
• Make sure you reference the correct assemblies, in case you have several LLBLGen versions.

Hi,

I am doing all of that. As I stated the application works perfectly fine when I do not include the self join. If I add the self join, generate the code and then compile in my application I get the errors I stated. Everything is referencing 2.6 assemblies. To be on the safe side I wipe out all of the files in the output directory each time. As long as the self join is not there, everything works...I get the same error if I perform the join in 2.5.

Would you please attach the lgp project or a repro one.

Thanks.

Please note that the fix is in the templates, so be sure you use the updated templates

Where do I get the updated templates? I downloaded v2.6 from the download page, shouldn't the new templates be included in the build or is there an update I need to get?

btrippindacap wrote:

Where do I get the updated templates? I downloaded v2.6 from the download page, shouldn't the new templates be included in the build or is there an update I need to get?

Yes, if you re-installed the full installer, then you have the templates. I was mentioning for the case if you have a custom template for relations for example.

Please attach a repro .lgp file.