Overview

Storage metadata schema is a formal description of the database that stores data for an Entity Framework application. It is displayed in the Model Explorer as the second root-level node and its child nodes.

Storage metadata schema contains information about tables, views, stored routines, and foreign key constraints. Tables and stored procedures in the storage metadata schema may be added in two ways: by dragging them from the Database Explorer and by manually creating them in the Model Explorer. Constraints are automatically created when you drag the corresponding tables from Database Explorer and can also be created manually. You can also drag Oracle packages to add their procedures to the model.

note Note

Storage part of the model can be renamed, this may prove useful if you have several models within one namespace and want to substitute mapping files.

You may also use the Defining Query and Command Text dialogs to create a table from a SELECT statement and function from SQL code.

After you added a table or a stored procedure, you may create classes from tables and methods from stored procedures by right-clicking them and selecting Create Class and Create Method respectively from their popup menu.

See the following topics for more information:

Creating Tables
Creating Stored Procedures
Creating Constraints
Mapping Synchronization

ExpandedToggleIcon        See Also


Send feedback on this topic

© 2008 - 2024 Devart. All rights reserved.