1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
namespace iWareExcel.ORM
{
    using System;
    using System.Data.Entity;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Linq;
 
    public partial class DbModelExcel : DbContext
    {
        public DbModelExcel()
            : base("name=DbModelExcel")
        {
        }
 
        public virtual DbSet<EXCELWorkBook> EXCELWorkBooks { get; set; }
        public virtual DbSet<EXCELWorkCell> EXCELWorkCells { get; set; }
        public virtual DbSet<EXCELWorkSheet> EXCELWorkSheets { get; set; }
 
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<EXCELWorkBook>()
                .HasMany(e => e.EXCELWorkSheets)
                .WithRequired(e => e.EXCELWorkBook)
                .HasForeignKey(e => e.workbookid)
                .WillCascadeOnDelete(false);
 
            modelBuilder.Entity<EXCELWorkSheet>()
                .HasMany(e => e.EXCELWorkCells)
                .WithRequired(e => e.EXCELWorkSheet)
                .HasForeignKey(e => e.worksheetid)
                .WillCascadeOnDelete(false);
        }
    }
}