using System;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration;
using System.Data.Entity.ModelConfiguration.Configuration;
using System.Linq.Expressions;
using System.Runtime.CompilerServices;

namespace Filter.Database.Character
{
	public class CharacterDB : DbContext
	{
		public virtual DbSet<tCharacter> tCharacters
		{
			get;
			set;
		}

		public virtual DbSet<tCharacterShape> tCharacterShapes
		{
			get;
			set;
		}

		public virtual DbSet<tGuildAcademyMember> tGuildAcademyMembers
		{
			get;
			set;
		}

		public virtual DbSet<tGuildMember> tGuildMembers
		{
			get;
			set;
		}

		public virtual DbSet<tGuild> tGuilds
		{
			get;
			set;
		}

		public virtual DbSet<tItemOption> tItemOptions
		{
			get;
			set;
		}

		public virtual DbSet<tItem> tItems
		{
			get;
			set;
		}

		public virtual DbSet<tMarriage> tMarriages
		{
			get;
			set;
		}

		public virtual DbSet<tUserMoney> tUserMoneys
		{
			get;
			set;
		}

		public CharacterDB() : base("name=CharacterDB")
		{
		}

		protected override void OnModelCreating(DbModelBuilder modelBuilder)
		{
			((StructuralTypeConfiguration<tCharacter>)modelBuilder.Entity<tCharacter>()).Property((tCharacter e) => e.sLoginZone).IsUnicode(new bool?(false));
			((StructuralTypeConfiguration<tCharacter>)modelBuilder.Entity<tCharacter>()).Property((tCharacter e) => e.sKQMap).IsUnicode(new bool?(false));
			modelBuilder.Entity<tCharacter>().HasMany<tGuildAcademyMember>((tCharacter e) => e.tGuildAcademyMembers).WithRequired((tGuildAcademyMember e) => e.tCharacter).HasForeignKey<int>((tGuildAcademyMember e) => e.nCharNo).WillCascadeOnDelete(false);
			modelBuilder.Entity<tCharacter>().HasMany<tGuildAcademyMember>((tCharacter e) => e.tGuildAcademyMembers1).WithRequired((tGuildAcademyMember e) => e.tCharacter1).HasForeignKey<int>((tGuildAcademyMember e) => e.nCharNo).WillCascadeOnDelete(false);
		}
	}
}