C# (CSharp) MSSql2005Creater.GenerateCreateTableSql示例

示例#1

文件： MSSqlCreaterTest.cs 项目： NoobSkie/taobao-shop-helper

        public void TestGenerateCreateTableSql_有一个字段()
        {
            MSSql2005Creater creater = new MSSql2005Creater();
            string sql = creater.GenerateCreateTableSql(typeof(SingleFieldDbEnityClass));

            Assert.IsTrue(sql.Contains("CREATE TABLE [SingleFieldDbEnityClass]"), "创建表");
            Assert.IsTrue(sql.Contains("[Id] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_SingleFieldDbEnityClass_Id] DEFAULT(NEWID()),"), "主键");
            Assert.IsTrue(sql.Contains("[Name] [NVARCHAR] (100) NULL ,"), "姓名");
        }

示例#2

        public void TestGenerateCreateTableSql_有一个字段()
        {
            MSSql2005Creater creater = new MSSql2005Creater();
            string           sql     = creater.GenerateCreateTableSql(typeof(SingleFieldDbEnityClass));

            Assert.IsTrue(sql.Contains("CREATE TABLE [SingleFieldDbEnityClass]"), "创建表");
            Assert.IsTrue(sql.Contains("[Id] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_SingleFieldDbEnityClass_Id] DEFAULT(NEWID()),"), "主键");
            Assert.IsTrue(sql.Contains("[Name] [NVARCHAR] (100) NULL ,"), "姓名");
        }

示例#3

文件： MSSqlCreaterTest.cs 项目： NoobSkie/taobao-shop-helper

        public void TestGenerateCreateTableSql_有多个字段()
        {
            MSSql2005Creater creater = new MSSql2005Creater();
            string sql = creater.GenerateCreateTableSql(typeof(MultiFieldDbEnityClass));

            Assert.IsTrue(sql.Contains("CREATE TABLE [MultiFieldDbEnityClass]"), "创建表");
            Assert.IsTrue(sql.Contains("[Id] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_MultiFieldDbEnityClass_Id] DEFAULT(NEWID()),"), "主键");
            Assert.IsTrue(sql.Contains("[Name] [NVARCHAR] (100) NULL ,"), "姓名");
            Assert.IsTrue(sql.Contains("[Description] [NVARCHAR] (MAX) NULL ,"), "描述");
            Assert.IsTrue(sql.Contains("[IsSystem] [BIT] NULL ,"), "是否系统");
            Assert.IsTrue(sql.Contains("[IsNew] [BIT] NOT NULL DEFAULT(0) ,"), "是否新增");
            Assert.IsTrue(sql.Contains("[Age] [INT] NULL ,"), "年龄");
            Assert.IsTrue(sql.Contains("[ItsOrg] [UNIQUEIDENTIFIER] NULL ,"), "所属机构");
        }

示例#4

        public void TestGenerateCreateTableSql_有多个字段()
        {
            MSSql2005Creater creater = new MSSql2005Creater();
            string           sql     = creater.GenerateCreateTableSql(typeof(MultiFieldDbEnityClass));

            Assert.IsTrue(sql.Contains("CREATE TABLE [MultiFieldDbEnityClass]"), "创建表");
            Assert.IsTrue(sql.Contains("[Id] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_MultiFieldDbEnityClass_Id] DEFAULT(NEWID()),"), "主键");
            Assert.IsTrue(sql.Contains("[Name] [NVARCHAR] (100) NULL ,"), "姓名");
            Assert.IsTrue(sql.Contains("[Description] [NVARCHAR] (MAX) NULL ,"), "描述");
            Assert.IsTrue(sql.Contains("[IsSystem] [BIT] NULL ,"), "是否系统");
            Assert.IsTrue(sql.Contains("[IsNew] [BIT] NOT NULL DEFAULT(0) ,"), "是否新增");
            Assert.IsTrue(sql.Contains("[Age] [INT] NULL ,"), "年龄");
            Assert.IsTrue(sql.Contains("[ItsOrg] [UNIQUEIDENTIFIER] NULL ,"), "所属机构");
        }

示例#5

文件： MSSqlCreaterTest.cs 项目： NoobSkie/taobao-shop-helper

        public void TestGenerateCreateTableSql_没有其他字段()
        {
            MSSql2005Creater creater = new MSSql2005Creater();
            string sql = creater.GenerateCreateTableSql(typeof(NoneFieldDbEnityClass));
            StringBuilder sqlCreate = new StringBuilder();
            sqlCreate.AppendLine("SET ANSI_NULLS ON");
            sqlCreate.AppendLine("GO");
            sqlCreate.AppendLine("SET QUOTED_IDENTIFIER ON");
            sqlCreate.AppendLine("GO");
            sqlCreate.AppendLine("CREATE TABLE [NoneFieldDbEnityClass]");
            sqlCreate.AppendLine("(");
            sqlCreate.AppendLine("[Id] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_NoneFieldDbEnityClass_Id] DEFAULT(NEWID()),");
            sqlCreate.AppendLine("CONSTRAINT [PK_NoneFieldDbEnityClass] PRIMARY KEY CLUSTERED");
            sqlCreate.AppendLine("(");
            sqlCreate.AppendLine("[Id] ASC");
            sqlCreate.AppendLine(")");
            sqlCreate.AppendLine(")");
            sqlCreate.AppendLine("GO");

            Assert.AreEqual(sqlCreate.ToString(), sql);
        }

示例#6

        public void TestGenerateCreateTableSql_没有其他字段()
        {
            MSSql2005Creater creater   = new MSSql2005Creater();
            string           sql       = creater.GenerateCreateTableSql(typeof(NoneFieldDbEnityClass));
            StringBuilder    sqlCreate = new StringBuilder();

            sqlCreate.AppendLine("SET ANSI_NULLS ON");
            sqlCreate.AppendLine("GO");
            sqlCreate.AppendLine("SET QUOTED_IDENTIFIER ON");
            sqlCreate.AppendLine("GO");
            sqlCreate.AppendLine("CREATE TABLE [NoneFieldDbEnityClass]");
            sqlCreate.AppendLine("(");
            sqlCreate.AppendLine("[Id] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL CONSTRAINT [DF_NoneFieldDbEnityClass_Id] DEFAULT(NEWID()),");
            sqlCreate.AppendLine("CONSTRAINT [PK_NoneFieldDbEnityClass] PRIMARY KEY CLUSTERED");
            sqlCreate.AppendLine("(");
            sqlCreate.AppendLine("[Id] ASC");
            sqlCreate.AppendLine(")");
            sqlCreate.AppendLine(")");
            sqlCreate.AppendLine("GO");

            Assert.AreEqual(sqlCreate.ToString(), sql);
        }

示例#7

文件： MSSqlCreaterTest.cs 项目： NoobSkie/taobao-shop-helper

 public void TestGenerateCreateTableSql_不是DbEntity类型()
 {
     MSSql2005Creater creater = new MSSql2005Creater();
     string sql = creater.GenerateCreateTableSql(typeof(NotDbEnityClass));
 }

示例#8

 public void TestGenerateCreateTableSql_不是DbEntity类型()
 {
     MSSql2005Creater creater = new MSSql2005Creater();
     string           sql     = creater.GenerateCreateTableSql(typeof(NotDbEnityClass));
 }