I have just generated the code for a project I have and don't understand why the property names in the code don't match the case of the field names from the database.

Meaning that if a database table field name was ProductID, then the generated code for the property was ProductId. Why the lower case d in ID? How can I make the generated code property names match my database table field names?

CorrectNameCasing is switched on by default. This to correct the names in a lot of databases which are just caps with '_'.

If you switch it off (in the preferences so next project will inherit that setting) and in the project settings (so it will be effective for this project) and you add a new entity, the names are not corrected.

The names are corrected according to the MS library guidelines. I know these change as much as the wind changes direction, but it's a start . In the next designer upgrade, more name settings are planned, as well as a corrector for current elements in a project.

Otis wrote:

CorrectNameCasing is switched on by default. This to correct the names in a lot of databases which are just caps with '_'.

If you switch it off (in the preferences so next project will inherit that setting) and in the project settings (so it will be effective for this project) and you add a new entity, the names are not corrected.

The names are corrected according to the MS library guidelines. I know these change as much as the wind changes direction, but it's a start . In the next designer upgrade, more name settings are planned, as well as a corrector for current elements in a project.

Thanks Otis.