コード例 #1
0
        public void CheckEntityTables()
        {
            //
            // Entity classes have entries in the EntityClass table and also have the following tables:
            //
            // {Entity}
            // {Entity}Attribute
            // {Entity}AttributeType
            // {Entity}Relation
            // {Entity}RelationType
            //

            using (var db = new DatabaseContext())
            {
                var entityClasses = db.EntityClasses.ToList();

                Assert.NotNull(entityClasses.FirstOrDefault(o => o.Name == "Album"));
                Assert.NotNull(entityClasses.FirstOrDefault(o => o.Name == "Band"));
                Assert.NotNull(entityClasses.FirstOrDefault(o => o.Name == "Person"));

                foreach (var entityClass in entityClasses)
                {
                    var name = entityClass.Name;
                    Assert.True(db.Database.TableExists(name));
                    Assert.True(db.Database.TableExists(name + "Attribute"));
                    Assert.True(db.Database.TableExists(name + "AttributeType"));
                    Assert.True(db.Database.TableExists(name + "Relation"));
                    Assert.True(db.Database.TableExists(name + "RelationType"));
                }
            }
        }
コード例 #2
0
        public void CheckSqlGenerator()
        {
            //
            // The EntitySqlGenerator generates SQL DDL statements for creating the entity tables.
            // Since the built-in Entity Framework SQL generator is leveraged, this should produce
            // SQL DDL statements that are compatible with the current database provider.
            //
            // If the entity tables need to be dropped, they can be dropped in the order below
            // to avoid foreign key dependency errors.  Please note that the helper extension methods
            // DropTable, TableExists, etc. found in DatabaseExtensions.cs are specific to SQL Server.
            //

            using (var db = new DatabaseContext())
            {
                var sql = EntitySqlGenerator.GenerateCreateTables("Foo");

                db.Database.ExecuteSqlCommand(sql);

                Assert.True(db.Database.TableExists("Foo"));
                Assert.True(db.Database.TableExists("FooAttribute"));
                Assert.True(db.Database.TableExists("FooAttributeType"));
                Assert.True(db.Database.TableExists("FooRelation"));
                Assert.True(db.Database.TableExists("FooRelationType"));

                db.Database.DropTable("FooAttribute");
                db.Database.DropTable("FooAttributeType");
                db.Database.DropTable("FooRelation");
                db.Database.DropTable("FooRelationType");
                db.Database.DropTable("Foo");

                Assert.False(db.Database.TableExists("Foo"));
                Assert.False(db.Database.TableExists("FooAttribute"));
                Assert.False(db.Database.TableExists("FooAttributeType"));
                Assert.False(db.Database.TableExists("FooRelation"));
                Assert.False(db.Database.TableExists("FooRelationType"));
            }
        }