也可以使用File-〉Load-〉Load Config载入已存在的config文件。注意,载入config文件时,config文件中的元数据配置信息,会覆盖当前编辑中的实体元数据信息。
使用Database-〉Generate Database Creation Script可以生成创建所有数据表的.sql数据库脚本(本工具目前仅支持Sql Server数据库的数据脚本生成)。
对应于以上实体的生成的数据库创建脚本如下:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AgentUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AgentUser]
GO
CREATE TABLE [dbo].[AgentUser] (
[LoginId] nvarchar(50),
[Id] int NOT NULL,
[Name] nvarchar(50),
[PrivilegeOwnerId] int
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AgentUser] WITH NOCHECK ADD
CONSTRAINT [PK_AgentUser] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
GO
CREATE INDEX [Id] ON [dbo].[AgentUser]([Id]) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GhostUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GhostUser]
GO
CREATE TABLE [dbo].[GhostUser] (
[Id] int NOT NULL,
[Name] nvarchar(50),
[PrivilegeOwnerId] int
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GhostUser] WITH NOCHECK ADD
CONSTRAINT [PK_GhostUser] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
GO
CREATE INDEX [Id] ON [dbo].[GhostUser]([Id]) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[IdFactory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[IdFactory]
GO
CREATE TABLE [dbo].[IdFactory] (
[NextId] int
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LocalUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LocalUser]
GO
CREATE TABLE [dbo].[LocalUser] (
[Password] nvarchar(50),
[LoginId] nvarchar(50),
[Id] int NOT NULL,
[Name] nvarchar(50),
[PrivilegeOwnerId] int
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LocalUser] WITH NOCHECK ADD
CONSTRAINT [PK_LocalUser] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
GO
CREATE INDEX [Id] ON [dbo].[LocalUser]([Id]) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[User]
GO
CREATE TABLE [dbo].[User] (
[Id] int NOT NULL,
[Name] nvarchar(50),
[PrivilegeOwnerId] int
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[User] WITH NOCHECK ADD
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
GO
CREATE INDEX [Id] ON [dbo].[User]([Id]) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserGroup]
GO
CREATE TABLE [dbo].[UserGroup] (
[Comment] nvarchar(50),
[Id] int NOT NULL,
[Name] nvarchar(50),
[PrivilegeOwnerId] int
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserGroup] WITH NOCHECK ADD
CONSTRAINT [PK_UserGroup] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
GO
CREATE INDEX [Id] ON [dbo].[UserGroup]([Id]) ON [PRIMARY]
GO
可以直接在Sql Server查询分析器中执行生成的脚本,创建所有对应的表。
下面是Entity Configurator工具的主界面。更多关于Entity Configurator介绍,请参见用户手册。
使用NBear的实体配置设置实体元数据
0
相关文章