Extended Properties as Custom Properties

Posts   
 
    
bjacobs
User
Posts: 73
Joined: 20-Aug-2008
# Posted on: 27-Aug-2010 22:46:11   

I am using adapter. V2.6 latest build. (SD.LLBLGen.Pro.ORMSupportClasses.NET20, Version=2.6.0.0) VS 2010. .Net Framework 4.0. SQL Server DB.

I cannot seem to get my extended properties to come in as custom properties. 1. In SQL 2008, I added an extended property to the column of a table in my database by right clicking on the column, selecting Properties. When the dialog appeared I clicked on ExtendedProperties. Under Properties I added a Name and a Value and clicked OK. 2. In LLBLGen's Project Settings under Catalog Refresher I set "UpdateCustomPropertiesAfterRefresh" = True. 3. In LLBLGen's Project Settings under Misc. I set RetrieveDBCustomProperties = True. 4. I right clicked on my Catalog in Project Explorer in LLBLGen's designer and selected "Refresh this catalog". 5. On the Catalog Refresh dialog, I checked the "Custom properties" checkbox and then clicked "Retrieve shema(s)". 6. I then generated my project.

Unfortunately the custom property placed on my database column is not in the generated code. confused If someone could provide me with the correct instructions on how to do this I would really appreciate it?

Thanks,

Billy Jacobs

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 28-Aug-2010 09:04:53   

On step 5, Did you see the custom properties actually on your entity? And.... What do you really expect after you generate code? What do you expect the custom property become in code?

David Elizondo | LLBLGen Support Team
bjacobs
User
Posts: 73
Joined: 20-Aug-2008
# Posted on: 29-Aug-2010 15:39:36   

Regarding step #5, I did not see it in either the LLBLGen project or the .Net Project.

I expected to see a custom property in the Entity attached to the column in some way. However, I am not sure because the documentation is not extensive on this feature, nor is there much in the forums.

Thanks,

Billy

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 30-Aug-2010 03:36:56   

bjacobs wrote:

Regarding step #5, I did not see it in either the LLBLGen project or the .Net Project.

I think you should remove the entity. Refresh the catalog and then re-add the entity. That way the property is retrieved into the LLBLGen project.

bjacobs wrote:

I expected to see a custom property in the Entity attached to the column in some way. However, I am not sure because the documentation is not extensive on this feature, nor is there much in the forums.

What "some way" means? The thing is that this is no built-in. If you want to use such properties in the generated code, you should modify the templates. What are you really looking for?

David Elizondo | LLBLGen Support Team