Export (0) Print
Expand All

Choose Your Database Objects Dialog Box (Entity Data Model Wizard)

The Choose Your Database Objects dialog box is part of the Entity Data Model Wizard and appears after you have selected the server and database to use. This dialog box displays the tables, views, and stored procedures that are available to include in the .edmx file. For more information, see .edmx File Overview (Entity Framework).

Select the objects to include in the .edmx file. By default, no objects in the database are selected.

NoteNote

If you choose to include stored procedures, the wizard modifies the storage model accordingly. However, you must use the Model Browser to create the corresponding conceptual model entries. For more information, see How to: Import a Stored Procedure (Entity Data Model Tools) or How to: Map Modification Functions to Stored Procedures (Entity Data Model Tools).

If you do not want the wizard to apply English-language rules for singulars and plurals to Entity, EntitySet, and NavigationProperty names, clear the Pluralize or singularize generated object names checkbox. If you proceed with the checkbox checked, the wizard will do the following:

  • Make all EntityType names singular.

  • Make all EntitySet names plural.

  • For each NavigationProperty that returns at most one entity, make the name singular.

  • For each NavigationProperty that returns more than one entity, make the name plural.

    NoteNote

    The Entity Data Model Wizard applies English language rules for singulars and plurals by creating a PluralizationService and passing it to an EntityModelSchemaGenerator.

If you do not want the wizard to generate properties on entity types that correspond to foreign key columns in the database, clear the Include foreign key columns in the model checkbox. For information about working with foreign keys in a conceptual model, see Defining and Managing Relationships (Entity Framework) and ReferentialConstraint Element (CSDL).

NoteNote

If a database table contains only foreign keys (sometimes called a pure join table), the wizard will not generate a corresponding entity type nor will it generate properties on related entity types that correspond to the foreign keys. Instead, a many-to-many association will be generated between the two entity types that the pure join table links.

Provide a namespace name in the Model Namespace box. The namespace name is used in the conceptual model, storage model, and generated source code file. The namespace must be unique for the project. The wizard checks if the project has a conceptual model with the same namespace and makes the namespace unique by adding a "0", "1", and so on, to the namespace name.

Any errors, warnings, or messages that are generated by the wizard will be visible in the Error List after the wizard closes.

NoteNote

If no objects are selected, or if there are no objects in the selected database, a message appears that asks you if you want to create an empty model. If you click yes, the wizard creates an empty model, adds a connection string to the App.Config or Web.Config file, and creates a default model namespace.

See Also

Show:
© 2014 Microsoft