Home > Importers, SQL Server > Importer Now Supports Extended Properties

Importer Now Supports Extended Properties


Starting with the build 50613.596 and upper, the Importer now supports SQL Server Extended Properties.

For instance, say I have the following database:

schema

Lets add an extended property on the Customer_Id  column such as:

USE Test;
GO
EXEC sys.sp_addextendedproperty
@name = N’MS_DescriptionExample’,
@value = N’Identifier of a Customer.’,
@level0type = N’SCHEMA’, @level0name = [dbo],
@level1type = N’TABLE’,  @level1name = Customer,
@level2type = N’COLUMN’, @level2name = Customer_Id;
GO

Using the Importer, I can now import extended properties into CodeFluent Entities message:

ImportPropertiesAsMessages

Note: this isn’t done by default, so if you do want to import your properties as messages, you need to set this feature to true in the advanced properties tab in the importer wizard.

Running the wizard will import my database into a CodeFluent Entities model, and SQL Server extended properties will become CodeFluent Entities messages:

Result

More information on the Messages concept available here: Messages.

Get more information on SQL Server extended properties here: Using Extended Properties on Database Objects.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s