C# (CSharp) TSQLGenerator.BuildCreate Examples

Example #1

        public void BuildCreate_WithSchemaAndMultipleKeys()
        {
            var tableMD = GetTestMetadata();

            tableMD.Properties.Add(new PropertyMetadata()
            {
                IsPK         = true,
                ColumnName   = "a2",
                PropertyName = "aa22"
            });
            tableMD.Schema = "testschema";

            var sql = TSQLGenerator.BuildCreate(tableMD, true);

            Assert.AreEqual(@"IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[testschema].[testtable]') AND type in (N'U'))
BEGIN
CREATE TABLE [testschema].[testtable](
   [a]  NOT NULL,
   [a2]  NOT NULL,
   [b]  NOT NULL,
   [c]  NOT NULL,
CONSTRAINT [PK_testtable] PRIMARY KEY CLUSTERED ( [a] ASC,[a2] ASC )
);
END
", sql);
        }

Example #2

        public static void CreateTable <T>(this IDbConnection connection, bool onlyIfNotExists, IDbTransaction transaction = null, int?commandTimeout = null) where T : class
        {
            var type = typeof(T);

            var values   = new Dictionary <string, object>();
            var metadata = MetadataFor(type);

            var sql = TSQLGenerator.BuildCreate(metadata, onlyIfNotExists: onlyIfNotExists);

            connection.Execute(sql, transaction: transaction, commandTimeout: commandTimeout);
        }

Example #3

        public void BuildCreate_NoSchema()
        {
            var tableMD = GetTestMetadata();

            Assert.IsNull(tableMD.Schema);

            var sql = TSQLGenerator.BuildCreate(tableMD);

            Assert.AreEqual(@"CREATE TABLE [dbo].[testtable](
   [a]  NOT NULL,
   [b]  NOT NULL,
   [c]  NOT NULL,
CONSTRAINT [PK_testtable] PRIMARY KEY CLUSTERED ( [a] ASC )
);
", sql);
        }

Example #4

File: PKMetadataAndSqlBuilderTest.cs Project: jbinder/dragon

        public void BuildCreate_OneIntKey()
        {
            var md = new TableMetadata();

            MetadataHelper.MetadataForClass(typeof(TableWithOneIntKey), ref md);

            var sql = TSQLGenerator.BuildCreate(md, true);

            Assert.AreEqual(@"IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableWithOneIntKey]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TableWithOneIntKey](
   [Key1] [int] IDENTITY(1,1) NOT NULL,
   [Other] [NVARCHAR](50) NULL,
CONSTRAINT [PK_TableWithOneIntKey] PRIMARY KEY CLUSTERED ( [Key1] ASC )
);
END
", sql);
        }

Example #5

        public void BuildCreate_WithSchema()
        {
            var tableMD = GetTestMetadata();

            tableMD.Schema = "testschema";

            var sql = TSQLGenerator.BuildCreate(tableMD, true);

            Assert.AreEqual(@"IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[testschema].[testtable]') AND type in (N'U'))
BEGIN
CREATE TABLE [testschema].[testtable](
   [a]  NOT NULL,
   [b]  NOT NULL,
   [c]  NOT NULL,
CONSTRAINT [PK_testtable] PRIMARY KEY CLUSTERED ( [a] ASC )
);
END
", sql);
        }

Example #6

        public void BuildCreate_WithSchemaAndNoKeys()
        {
            var tableMD = GetTestMetadata();

            tableMD.Properties.Where(x => x.IsPK).ToList().ForEach(x => x.IsPK = false);
            tableMD.Schema = "testschema";

            var sql = TSQLGenerator.BuildCreate(tableMD, true);

            Assert.AreEqual(@"IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[testschema].[testtable]') AND type in (N'U'))
BEGIN
CREATE TABLE [testschema].[testtable](
   [a]  NOT NULL,
   [b]  NOT NULL,
   [c]  NOT NULL,

);
END
", sql);
        }