Custom naming convention in Design-time when calling Update Database

I would like to follow the naming convention of

Objects = UpperCamelCaseSingular
Properties = lowerCamelCase
Table Name = lower_underscore_plural
column = lower_underscore

I see INamingStrategy interface, which is apparently used at runtime, however it does not appear to affect the design-time model at all. When I right-click and say "Update Database", it is ignored. (namingStrategyClass is defined in my Web.config).

Is there a way to make design-time use the correct naming convention?

Thanks

Yes what you need to do is to implement a custom designer naming strategy which will give you control over how the designer names the entities based on the database name. You will then want to align your rules with the naming strategy.

This is a somewhat obscure feature in LightSpeed so here is what you need to do:

• Create a Class Library project which references the LightSpeed Mindscape.LightSpeed.Generator.Integration.Dsl.Mapping DLL.
• Add a class which implements Mindscape.LightSpeed.Generator.Extraction.IDesignTimeNamingStrategy.

Here is an example :

public class MyNamingStrategy : Mindscape.LightSpeed.Generator.Extraction.IDesignTimeNamingStrategy
{
  public string GetEntityName(string tableName)
  {
    return tableName.ToUpperInvariant(); // example of custom logic
  }

  public string GetPropertyName(string tableName, string columnName)
  {
    return columnName;
  }

  public string GetSpecialColumnName(string tableName, string defaultColumnName)
  {
    return defaultColumnName;
  }

  public bool UseClrNamingConventions
  {
    get { return false; } // turn this off to avoid Camel cased naming being applied
  }
}

• Build the DLL and copy it into a "Lib" style location so you can reference it from your model
• Open your model in the LightSpeed designer and go to the Model Explorer (View > Other Windows > LightSpeed Model).
• Right click the Model node in the tree and choose Add New Design Time Assembly.
• Enter the full file-path to your strategy DLL.
• Save and close the model.
• Open the .lsmodel file in a text editor.
• Add the following attribute to the element: designTimeNamingStrategyType="MyNamingStrategy.MyNamingStrategy" (where MyNamingStrategy.MyNamingStrategy is the namespace-qualified name of the strategy type). You don't need to assembly-qualify it because LightSpeed automatically looks in assemblies listed in the Design Time Assemblies folder.
• Save and close the .lsmodel file.

The key bit in the strategy in general is turning off UseClrNamingConventions which will prevent LightSpeed from re-casing the entity name. You can adjust the other aspects as required. After this is all in place you should see the change when performing an Update Database where the generated entity name should now be based on your custom code.

Jeremy