This documentation is archived and is not being maintained.

How to: Turn Pluralization On and Off (O/R Designer)

By default, when you drag database objects that have names ending in s or ies from Server Explorer/Database Explorer onto the Object Relational Designer (O/R Designer), the names of the generated entity classes are changed from plural to singular. This is done to more accurately represent the fact that the instantiated entity class maps to a single record of data. For example, adding a Customers table to the O/R Designer results in an entity class named Customer because the class will hold data for only a single customer.

noteNote:
Pluralization is on by default only in the English-language version of Visual Studio.

To turn pluralization on and off

  1. On the Tools menu, click Options.

  2. In the Options dialog box, expand Database Tools.

noteNote:
Select Show all settings if the Database Tools node is not visible.

  1. Click O/R Designer.

  2. Set Pluralization of names to Enabled = False to set the O/R Designer so that it does not change class names.

  3. Set Pluralization of names to Enabled = True to apply pluralization rules to the class names of objects added to the O/R Designer.

See Also




Build Date:

2012-08-02
Show: