protected override void LoadMetaData()
{
EntityMetadata meta;
meta = new EntityMetadata()
{
EntityType = typeof(Actor), Container = Actors
};
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Actor)e).User));
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Actor)e).Room));
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Actor)e).ClassTemplate));
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Actor)e).RaceTemplate));
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => Actor.GenerateInsertCommand(c, (Actor)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => Actor.GenerateUpdateCommand(c, (Actor)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => Actor.GenerateDeleteCommand(c, (Actor)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(ClassTemplate), Container = ClassTemplates
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => ClassTemplate.GenerateInsertCommand(c, (ClassTemplate)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => ClassTemplate.GenerateUpdateCommand(c, (ClassTemplate)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => ClassTemplate.GenerateDeleteCommand(c, (ClassTemplate)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(Currency), Container = Currencies
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => Currency.GenerateInsertCommand(c, (Currency)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => Currency.GenerateUpdateCommand(c, (Currency)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => Currency.GenerateDeleteCommand(c, (Currency)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(Item), Container = Items
};
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Item)e).ItemTemplate));
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Item)e).Actor));
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Item)e).Room));
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => Item.GenerateInsertCommand(c, (Item)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => Item.GenerateUpdateCommand(c, (Item)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => Item.GenerateDeleteCommand(c, (Item)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(ItemTemplate), Container = ItemTemplates
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => ItemTemplate.GenerateInsertCommand(c, (ItemTemplate)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => ItemTemplate.GenerateUpdateCommand(c, (ItemTemplate)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => ItemTemplate.GenerateDeleteCommand(c, (ItemTemplate)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(RaceTemplate), Container = RaceTemplates
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => RaceTemplate.GenerateInsertCommand(c, (RaceTemplate)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => RaceTemplate.GenerateUpdateCommand(c, (RaceTemplate)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => RaceTemplate.GenerateDeleteCommand(c, (RaceTemplate)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(Region), Container = Regions
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => Region.GenerateInsertCommand(c, (Region)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => Region.GenerateUpdateCommand(c, (Region)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => Region.GenerateDeleteCommand(c, (Region)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(Room), Container = Rooms
};
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Room)e).Region));
meta.Relationships.Add(new EntityRelationship((IEntity e) => ((Room)e).TextBlock));
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => Room.GenerateInsertCommand(c, (Room)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => Room.GenerateUpdateCommand(c, (Room)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => Room.GenerateDeleteCommand(c, (Room)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(Setting), Container = Settings
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => Setting.GenerateInsertCommand(c, (Setting)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => Setting.GenerateUpdateCommand(c, (Setting)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => Setting.GenerateDeleteCommand(c, (Setting)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(TextBlock), Container = TextBlocks
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => TextBlock.GenerateInsertCommand(c, (TextBlock)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => TextBlock.GenerateUpdateCommand(c, (TextBlock)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => TextBlock.GenerateDeleteCommand(c, (TextBlock)e);
EntityTypes.Add(meta);
meta = new EntityMetadata()
{
EntityType = typeof(User), Container = Users
};
meta.GenerateInsertCommand = (SqlCommand c, IEntity e) => User.GenerateInsertCommand(c, (User)e);
meta.GenerateUpdateCommand = (SqlCommand c, IEntity e) => User.GenerateUpdateCommand(c, (User)e);
meta.GenerateDeleteCommand = (SqlCommand c, IEntity e) => User.GenerateDeleteCommand(c, (User)e);
EntityTypes.Add(meta);
this.LinkTypes.Add(RaceClassRestrictions);
}
public static void GenerateDeleteCommand(SqlCommand c, ClassTemplate e)
{
c.CommandText = @"DELETE FROM[ClassTemplate] WHERE[Id] = @Id";
c.Parameters.Clear();
c.Parameters.AddWithValue("@Id", e.Id);
}
public static void GenerateInsertCommand(SqlCommand c, ClassTemplate e)
{
c.CommandText = @"INSERT INTO [ClassTemplate]([Id], [Name], [Description], [Stats])
VALUES (@Id, @Name, @Description, @Stats)";
AddSqlParameters(c, e);
}
public static void GenerateUpdateCommand(SqlCommand c, ClassTemplate e)
{
c.CommandText = @"UPDATE [ClassTemplate] SET [Id] = @Id, [Name] = @Name, [Description] = @Description, [Stats] = @Stats WHERE [Id] = @Id";
AddSqlParameters(c, e);
}
partial void OnClassTemplateChanging(ClassTemplate oldValue, ClassTemplate newValue);