How to specify SQL Server FileGroup in Entity

By default SQL Server will store all your database objects, system objects, tables, stored procedures, etc… into the primary file group. This basically is putting everything into a single data file (.mdf) and transaction log (.ldf). This should be pretty sufficient in development environment. But in production environment the default setting could causing performance limitation. To achieve higher throughput we can design the database to work with multiple files and filegroups.

To specify FileGroup in entity:

1. Right click on the entity and select Open Specification.
   

   Open entity’s specification dialog

2. Go to DDL Clause property and specify the target filegroup with the “ON” statement.
   

   Specify entity’s filegroup in DDL Clause property

3. After that when generate DDL the filegroup info will being attached to the table.
   

   Generate DDL for the table having filegroup setting

 

Related Know-how

How to customize the name of entity index How to create calculated column in ERD Create relationship between entities using unique index

Related Links

Overview of Database Design & Management with Visual Paradigm Drawing Entity Relationship Diagram (User’s Guide) Generating Object-Relational Mapping Code (User’s Guide)