Devart Forums

Code: Select all

CREATE DATABASE TestED
GO

USE TestED
GO

CREATE TABLE [dbo].[TableA]
(
[TableAId] [int] NOT NULL PRIMARY KEY IDENTITY(1, 1)
)
GO

CREATE TABLE [dbo].[TableB]
(
[TableBId] [int] NOT NULL PRIMARY KEY IDENTITY(1, 1),
[TableAId] [int] NOT NULL,
[TableAId_Other] [int] NULL
)
GO

ALTER TABLE [dbo].[TableB] ADD CONSTRAINT [FK_TableB_TableA] FOREIGN KEY ([TableAId]) REFERENCES [dbo].[TableA] ([TableAId])
GO
ALTER TABLE [dbo].[TableB] ADD CONSTRAINT [FK_TableB_TableA_Other] FOREIGN KEY ([TableAId_Other]) REFERENCES [dbo].[TableA] ([TableAId])
GO

CREATE TABLE [dbo].[TableC]
(
[TableCId] [int] NOT NULL PRIMARY KEY IDENTITY(1, 1),
)
GO

Code: Select all

CREATE DATABASE TestED
GO

USE TestED
GO

CREATE TABLE [dbo].[TableA]
(
	[TableAId] INT NOT NULL PRIMARY KEY IDENTITY(1, 1),
	[SType] [INT] NOT NULL,
	[Cod] [NVARCHAR] (50) NULL,
	[Name] [NVARCHAR] (200) NOT NULL
)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_TableA_SType_Cod] ON [dbo].[TableA] ([SType], [Cod]) WHERE ([Cod] IS NOT NULL)
GO

CREATE UNIQUE NONCLUSTERED INDEX [IX_TableA_SType_Name] ON [dbo].[TableA] ([SType], [Name]) WHERE ([Cod] IS NULL)
GO

Code: Select all

CREATE DATABASE TestED
GO

USE [TestED]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Animal](
	[AnimalId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Animal] PRIMARY KEY CLUSTERED 
(
	[AnimalId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Cat](
	[AnimalId] [int] NOT NULL,
	[FieldB] [int] NOT NULL,
 CONSTRAINT [PK_Cat] PRIMARY KEY CLUSTERED 
(
	[AnimalId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dog](
	[AnimalId] [INT] NOT NULL,
	[Field1] [NVARCHAR](10) NOT NULL,
 CONSTRAINT [PK_Dog] PRIMARY KEY CLUSTERED 
(
	[AnimalId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TestRef](
	[TestRefId] [INT] IDENTITY(1,1) NOT NULL,
	[TesAB] [NVARCHAR](50) NOT NULL,
	[AnimalId_Dog] [INT] NOT NULL,
 CONSTRAINT [PK_TestRef] PRIMARY KEY CLUSTERED 
(
	[TestRefId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Cat]  WITH CHECK ADD  CONSTRAINT [FK_Cat_Animal] FOREIGN KEY([AnimalId])
REFERENCES [dbo].[Animal] ([AnimalId])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[Cat] CHECK CONSTRAINT [FK_Cat_Animal]
GO

ALTER TABLE [dbo].[Dog]  WITH CHECK ADD  CONSTRAINT [FK_Dog_Animal] FOREIGN KEY([AnimalId])
REFERENCES [dbo].[Animal] ([AnimalId])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[Dog] CHECK CONSTRAINT [FK_Dog_Animal]
GO

ALTER TABLE [dbo].[TestRef]  WITH CHECK ADD  CONSTRAINT [FK_TestRef_Dog] FOREIGN KEY([AnimalId_Dog])
REFERENCES [dbo].[Dog] ([AnimalId])
GO

ALTER TABLE [dbo].[TestRef] CHECK CONSTRAINT [FK_TestRef_Dog]
GO

Code: Select all

CREATE DATABASE Test57216
GO

USE Test57216
GO

CREATE SEQUENCE [dbo].[Forum57216_sequence] AS [int]
GO

CREATE TABLE Forum57216(
Forum57216Id int Primary Key,
Id int DEFAULT NEXT VALUE FOR [dbo].[Forum57216_sequence]
)
GO

Code: Select all

Map(x => x.Test)    
                .Column("Test")
                .CustomType("NhibernateExt.UriType")
                .Access.Property()
                .Generated.Never()
                .CustomSqlType("varchar")
                .Length(100);

public virtual System.Uri Test
        {
            get;
            set;
        }