I couldn't reproduce it, following is what I did.
1- I used an existing project and an existing database.
2- I ran the DDL script you gave against my database (I removed the FK references because no such tables exist in my schema).
3- I opened the lgp project and went to Project->Properties menu item.
4- I set both UpdateCustomPropertiesAfterRefresh and RetrieveDBCustomProperties to true.
5- Clicked on the Catalog and selected Refresh.
6- Now I see the Custom Properties checkbox checked, in the Catalog Refresh Dialog.
7- After doing refresh I added the new Activity entity to my mapped Entities tree.
8- Going to it's properties I can see fields descriptions as custom properties.
9- I went and generated the code.
10- And the following is some code snippets of what has been generated in the ActivityEntity class:
private static void SetupCustomPropertyHashtables()
{
_customProperties = new Dictionary<string, string>();
_fieldsCustomProperties = new Dictionary<string, Dictionary<string, string>>();
_customProperties.Add("MS_Description", @"Indicates that all or some of the monetary value of the Activity is for a specific Purpose and ActivityType.");
Dictionary<string, string> fieldHashtable = null;
fieldHashtable = new Dictionary<string, string>();
fieldHashtable.Add("MS_Description", @"Link to Activity table");
_fieldsCustomProperties.Add("ActivityId", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
fieldHashtable.Add("MS_Description", @"The fractional amount of the parent Activity that is for support.");
_fieldsCustomProperties.Add("Value", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
_fieldsCustomProperties.Add("PurposeCodeId", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
_fieldsCustomProperties.Add("Noted", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
_fieldsCustomProperties.Add("Description", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
fieldHashtable.Add("MS_Description", @"Date Activity took place");
_fieldsCustomProperties.Add("Date", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
_fieldsCustomProperties.Add("ContactId", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
_fieldsCustomProperties.Add("ClientAccountId", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
_fieldsCustomProperties.Add("TransId", fieldHashtable);
fieldHashtable = new Dictionary<string, string>();
_fieldsCustomProperties.Add("ParentId", fieldHashtable);
}
/// <summary> The ActivityId property of the Entity Activity<br/><br/>
///
/// MS_Description: Link to Activity table<br/></summary>
/// <remarks>Mapped on table field: "Activity"."ActivityID"<br/>
/// Table field type characteristics (type, precision, scale, length): Int, 10, 0, 0<br/>
/// Table field behavior characteristics (is nullable, is PK, is identity): false, true, true</remarks>
public virtual System.Int32 ActivityId
{
get { return (System.Int32)GetValue((int)ActivityFieldIndex.ActivityId, true); }
set { SetValue((int)ActivityFieldIndex.ActivityId, value); }
}
