Devart Entity Developer Documentation

 Contents  |   Search

• What's New
• General Information
  • Basic Workflows
    • Design Approaches
      • Database-First Approach
      • Model-First Approach
      • Synchronizing Model and Database Data
      • Mixed Approach
    • Code Refactoring
    • Code Generation
      • Common Code Generation Functionality
      • Advanced Capabilities
      • Attributes
      • Entity Property Validation
    • Working with Queries and Data
      • Creating and Executing Queries
      • How To: View and Edit Data
      • Configuring Entity Developer for Executing Queries
    • Searching Objects in the Model
    • Servers' Options
      • Overview
      • Creating and Editing Type Mapping Rules
    • Model Refactoring Wizard
      • Overview
      • Creating a Complex Type via the Model Refactoring Wizard
      • Creating a TPT Hierarchy via the Model Refactoring Wizard
      • Creating a TPC Hierarchy via the Model Refactoring Wizard
    • How to Change a DBMS for an Existing Model
  • Introduction
  • Key Features
  • Compatibility
  • Editions
  • Visual Studio Add-in Peculiarities
  • Anonymous Usage Statistics
• User Interface Concepts
  • Application Customization
    • Application Environment Customization
    • Diagram Customization
  • Diagram
    • Diagram Overview
    • Context Menu Options
    • Managing Diagrams
    • Selection-Driven Highlighting
    • Diagram Skins and Shape Colors
  • Tool Windows
    • Database Explorer
    • Diagram Overview Window
    • Error List
    • Find
    • Find Results
    • Model Explorer
    • Properties Window
• Console Entity Developer Application
• Template System Concepts
  • Overview
  • Model Template Types
  • Basic Operations With Templates
  • Template Language
  • Code Completion
  • Locating Errors in Code
  • Declaring Extended Properties in Templates
  • Defining Generation Paths in Templates
  • Managing Overwrite Behavior with Templates
• ORM Support
  • Entity Framework
    • Introduction
    • Third-Party Providers Support
    • Creating Models
      • Creating Model Using Database-First Approach
      • Creating Model Using Model-First Approach
    • Synchronizing Model and Database Data
      • Updating Model from Database
      • Updating Database from Model
    • Concepts
      • Working with Classes
        • Creating and Editing Classes
        • Entity Mapping
        • Table Splitting
        • Stored Procedure Mapping
        • Entity Splitting
      • Working with Properties
        • Creating and Editing Properties
      • Working with Associations
        • Overview
        • One-to-One Association
        • One-to-Many Association
        • Many-to-Many Association
      • Working with Inheritances
        • Overview
        • Table Per Hierarchy
        • Table Per Type
        • Table Per Concrete Type
      • Working with Complex Types
      • Working with Methods
        • Creating and Editing Methods
        • Command Text
          • Command Text Without Result
          • Command Text With Scalar Result
          • Command Text With Resultset
          • Command Text With Multiple Resultsets
        • Stored Procedures
          • Stored Procedure Without Result
          • Stored Function With Scalar Result
          • Stored Procedure and Stored Function With Resultset
          • Stored Procedure with Multiple Resultsets
          • Stored Procedure with Output Parameters
          • Stored Procedure with Output Parameters and Resultset
        • Model-Defined Functions
          • Model-Defined Functions Overview
          • Creating Model-Defined Function, Returning Scalar Value
          • Creating Model-Defined Function, Returning Collection of Scalar Values
          • Creating Model-Defined Function, Returning Collection of Entities
          • Calling Model-Defined Functions from LINQ Queries
      • Working with Enums
      • Storage Metadata Schema
        • Overview
        • Creating Tables
        • Creating Stored Procedures
        • Creating Constraints
        • Mapping Synchronization
      • Spatial Data Types
      • Validating a Model
      • Model Generation Templates
        • Data Annotations Metadata Template
        • Data Transfer Objects Template
        • DbContext Template
        • EntityObject Template
        • MVC Controller Template
        • MVC View Advanced Template
        • POCO Entity Template
        • Repository and Unit of Work Template
        • Self-Tracking Entity Template
        • WCF RIA Domain Service Template
        • View Pregeneration Support in Templates
    • Customizing Model Properties
      • Model
        • General
          • Initialization
        • Attributes
        • Extended Properties
      • Synchronization
        • Model Naming
        • Database Naming
          • Advanced
        • Mapping
    • Reference
      • Dialog Windows
        • Association Editor
        • Association Mapping Details
        • Class Editor
        • Command Text
        • Complex Type Editor
        • Defining Query
        • Entity Mapping Details
        • Inheritance Editor
        • Method Editor
        • Model Refactoring
        • Model Settings
        • Property Editor
        • Result Mapping Details
        • Storage Column Editor
        • Storage Constraint Editor
        • Storage Entity Editor
        • Storage Procedure Editor
        • Stored Procedure Mapping
      • Model Properties
      • Object Properties
        • Association Properties
        • Class Properties
        • Complex Type Properties
        • Constraint Properties
        • Enum Type Properties
        • Inheritance Properties
        • Method Properties
        • Property Properties
        • Stored Procedure Properties
        • Table Properties
      • Errors and Warnings
  • Entity Framework Core
    • Creating Models
      • Creating Model Using Database First Approach
      • Creating Model Using Model First Approach
    • Synchronizing Model and Database Data
      • Updating Model from Database
      • Updating Database from Model
    • Concepts
      • Working with Classes
        • Creating and Editing Classes
        • Using Raw SQL Queries
        • Table Splitting
        • Using Query Types/Keyless Entity Types
      • Working with Properties
        • Creating and Editing Properties
        • Database Column Mapping
        • Setting Properties in Constructor
      • Working with Associations
        • Overview
        • One-to-One Association
        • One to Many Association
        • Many-to-Many Association
        • Lazy Loading
      • Working with Inheritances
      • Working with Methods
        • Overview
        • Stored Procedures
          • Stored Procedure without Result
          • Stored Function with Scalar Result
          • Stored Procedure and Stored Function With Resultset
          • Stored Procedure with Multiple Resultsets
          • Table Valued Function
        • Raw SQL Queries
          • Query without Result
          • Query with Scalar Result
          • Query with Entity Result
      • Working with Owned Types (Complex Types)
        • Creating an Owned Type (Complex Type)
        • Complex Type Mapping
        • External Complex Types
      • Working with Enums
      • Validating a Model
    • Generation
      • Code Generation
      • Model Generation Templates
        • Data Annotations Metadata Template
        • Data Transfer Objects Template
        • EF Core Template
        • MVC Controller Template
        • MVC View Advanced Template
        • Repository and Unit of Work Template
    • Customizing Model Properties
      • Model
        • General
          • Initialization
        • Attributes
        • Extended Properties
      • Synchronization
        • Model Naming
        • Database Naming
          • Advanced
  • NHibernate
    • Creating Models
      • Creating Model Using Database-First Approach
      • Creating Model Using Model-First Approach
      • Importing Mapping Files
    • Synchronizing Model and Database Data
      • Updating Model from Database
      • Updating Database from Model
    • Concepts
      • Working with Classes
        • Creating and Editing a Class
        • Mapping an Entity to Several Tables
        • Creating a Subselect
      • Working with Properties
        • Creating and Editing Properties
        • Property Types
        • Primary Key Specifics
        • Database Column Mapping
        • Access Strategies
        • Optional Settings
      • Working with Associations
        • Overview
        • One-to-One Association
        • One-to-Many Association
        • Many-to-Many Association
        • Special Cases
          • Component Collections Support
          • Support of Many-to-One Mapping for Component Navigation Properties
          • Support of Many-to-Many Mapping for Component Navigation Properties
      • Working with Inheritances
        • Overview
        • Table per Hierarchy
        • Table per Type
        • Table per Concrete Type
      • Working with Methods
        • Named SQL Queries
          • Overview
          • Query without Result
          • Query with Scalar Result
          • Query with Entity Result
        • Stored Procedures
          • Overview
          • Stored Procedure without Result
          • Stored Function with Scalar Result
          • Stored Procedure with Entity Result
          • Table-Valued Function
      • Working with Components
        • Creating a Complex Type
        • Component Mapping
        • External Complex Types
      • Working with Enums
      • TypeDefs
      • Filtering Data
      • Validating a Model
    • Generation
      • Entities and Mapping Generation
      • Configuration Generation
      • Model Generation Templates
        • Castle ActiveRecord Template
        • Data Annotations Metadata Template
        • Data Transfer Objects Template
        • Fluent NHibernate Template
        • Loquacious Mapping
        • MVC Controller Template
        • MVC View Advanced Template
        • NHibernate Template
        • Repository and Unit of Work Template
    • Customizing Model Properties
      • Model
        • General
          • Initialization
        • Configuration
        • Attributes
        • Extended Properties
      • Synchronization
        • Model Naming
        • Database Naming
          • Advanced
    • NHibernate Mapping Samples
    • Reference
      • Dialog Windows
        • Association Editor
        • Class Editor
        • Column Editor
        • Default Parameter Values Editor
        • Inheritance Editor
        • Join Tables Editor
        • Method Editor
        • Model Refactoring
        • Property Editor
        • Type Editor
        • TypeDefs Editor
      • Model Properties
      • Object Properties
        • Association Properties
        • Class Properties
        • Complex Type Properties
        • Enum Type Properties
        • Inheritance Properties
        • Property Properties
  • Telerik Data Access
    • Creating Models
      • Creating Model Using Database-First Approach
      • Creating Model Using Model-First Approach 
    • Synchronizing Model and Database Data
      • Updating Model from Database 
      • Updating Database from Model
    • Concepts
      • Working with Classes
        • Creating and Editing a Class
        • Mapping an Entity to Several Tables
      • Working with Properties
        • Creating and Editing Properties
        • Property Types
        • Primary Key Specifics
        • Database Column Mapping
        • Access Strategies
      • Working with Associations
        • Overview
        • One-to-One Association
        • One-to-Many Association
        • Many-to-Many Association
      • Working with Inheritances
        • Overview
        • Table Per Hierarchy
        • Table per Type
        • Table per Concrete Type
      • Working with Methods
        • Overview
        • Stored Procedure without Result
        • Stored Function with Scalar Result
        • Stored Procedure and Stored Function With Resultset
        • Stored Procedure with Multiple Resultsets
        • Table-Valued Function
      • Working with Struct Objects and Complex Types
        • Creating a Struct Object or Complex Type
        • Complex Type Mapping
        • External Struct Objects and Complex Types
      • Working with Enums
      • Validating a Model
    • Generation
      • Entities and Mapping Generation
      • Configuration Generation
      • Model Generation Templates
        • Data Access Template
        • Data Annotations Metadata Template
        • Data Transfer Objects Template
        • MVC Controller Template
        • MVC View Advanced Template
        • Repository and Unit of Work Template
    • Customizing Model Properties
      • Model
        • General
          • Initialization
        • Configuration
        • Attributes
        • Extended Properties
      • Synchronization
        • Model Naming
        • Database Naming
          • Advanced
  • LinqConnect
    • Creating Models
      • Creating Model Using Database-First Approach
      • Creating Model Using Model-First Approach
    • Synchronizing Model and Database Data
      • Updating Model from Database
      • Updating Database from Model
    • Concepts
      • Classes
      • Update Methods
      • Properties
      • Complex Types
      • Associations
      • Inheritances
      • Methods
      • Validating a Model
      • Working with Enums
      • Model Generation Templates
        • Data Annotations Metadata Template
        • Data Transfer Objects Template
        • Fluent Mapping Template
        • LinqConnect Template
        • MVC Controller Template
        • MVC View Advanced Template
        • POCO Entity Template
        • Repository and Unit of Work Template
        • WCF RIA Domain Service Template
    • Customizing Model Properties
      • Model
        • General
          • Initialization
        • Attributes
        • Extended Properties
      • Synchronization
        • Model Naming
        • Database Naming
          • Advanced
        • Mapping
    • Reference
      • Dialog Windows
        • Association Editor
        • Class Editor
        • Class Mapping Details
        • Complex Type Editor
        • Inheritance Editor
        • Method Editor
        • Model Refactoring
        • Model Settings
        • Property Editor
        • Stored Procedure Mapping
      • Model Properties
      • Object Properties
        • Association Properties
        • Class Properties
        • Complex Type Properties
        • Inheritance Properties
        • Method Properties
        • Property Properties
      • Errors and Warnings
  • LINQ to SQL Models
• User Interface Reference
  • Toolbars, Windows, and Documents
    • Toolbars and Menus
    • Switching Between Windows
    • Managing Documents
    • Working with Document Tab Groups
    • Document Header Popup Menu
  • Customizing Window Layout
    • Closing and Displaying Tool Windows
    • Auto-hide Mode
    • Layout Saving and Restoring
  • Template Editor
  • Query Document
  • Create Model Wizard
    • Welcome to Entity Developer, Create Model Wizard
    • Setup Data Connection Properties, Create Model Wizard
      • dotConnect for MySQL Connection Parameters
      • dotConnect for Oracle Connection Parameters
      • SQL Client Data Provider Connection Parameters
      • dotConnect for PostgreSQL Connection Parameters
      • dotConnect for SQLite Connection Parameters
      • dotConnect for Salesforce Connection Parameters
    • Import Mappings, Create Model Wizard
    • Choose Model Contents, Create New Model Wizard
    • Select Database Objects, Create Model Wizard
    • Setup Naming Rules, Create Model Wizard
      • Setup Naming Rules under Database-First Approach
      • Setup Naming Rules under Model-First Approach
    • Model Properties, Create Model Wizard
    • Choose Model Diagram Contents, Create Model Wizard
    • Model Synchronization, Create Model Wizard
    • Model Synchronization Settings, Create Model Wizard
    • Import Results, Create Model Wizard
    • Choose Code Generation Template, Create New Model Wizard
    • Wizard Finished Successfully, Create Model Wizard
  • Update From Database Wizard
    • Welcome to Entity Developer, Update From Database Wizard
    • Setup Data Connection Properties, Update From Database Wizard
      • dotConnect for MySQL Connection Parameters
      • dotConnect for Oracle Connection Parameters
      • SQL Client Data Provider Connection Parameters
      • dotConnect for PostgreSQL Connection Parameters
      • dotConnect for SQLite Connection Parameters
    • Choose Schemas, Update From Database Wizard
    • Choose Change Actions, Update From Database Wizard
    • Wizard Finished Successfully, Update From Database Wizard
  • Update To Database Wizard
    • Welcome To Entity Developer Update To Database Wizard
    • Setup Data Connection Parameters, Update To Database Wizard
      • dotConnect for MySQL Connection Parameters
      • dotConnect for Oracle Connection Parameters
      • SQL Client Data Provider Connection Parameters
      • dotConnect for PostgreSQL Connection Parameters
      • dotConnect for SQLite Connection Parameters
    • Setup Naming Rules,  Update To Database Wizard
    • Choose Schemas, Update To Database Wizard
    • Choose Change Actions, Update To Database Wizard
    • Executed Script, Update To Database Wizard
    • Wizard Finished Successfully, Update To Database Wizard
  • Generate Database Script Wizard
    • Welcome to Entity Developer Generate Database Script Wizard, Generate Database Script Wizard
    • Model Synchronization Settings, Generate Database Script Wizard
    • Setup Naming Rules, Generate Database Script Wizard
    • Choose Change Actions, Generate Database Script Wizard
    • Database Script, Generate Database Script Wizard
  • Dialog Windows
    • Add Assembly
    • Add Template Dialog Box
    • Attributes Dialog Box
    • Connection Editor
    • Connection Properties Dialog Box
    • Enum Type Editor
    • New Diagram Dialog Box
    • New Model Dialog Box
    • Save Prompt Dialog Box
    • Type Mapping Rule Editor Dialog Box
    • Windows Dialog Box
  • Application Skins
  • Options Dialog Box
    • General, Environment, Options Dialog Box
    • Keyboard, Environment, Options Dialog Box
    • General, Diagram, Options Dialog Box
    • Notation, Diagram, Options Dialog Box
    • Page, Diagram, Options Dialog Box
    • Print, Diagram, Options Dialog Box
    • Servers' Options (Oracle)
    • Servers' Options (SQL Server, PostgreSQL, Salesforce)
    • Servers' Options (SQLite)
    • Servers' Options (MySQL, Firebird)