Entity Framework Code First -- 延迟加载和预先加载

还是以这两个表为例子

country包含零个或多个city，这个外键关系是我后来加上去，原来没有。然后再用Power Tool逆向，产生如下代码

   1:  using System.ComponentModel.DataAnnotations.Schema;

   2:  using System.Data.Entity.ModelConfiguration;

3:

   4:  namespace EFEntity.Models.Mapping

   5:  {

   6:      public class cityMap : EntityTypeConfiguration<city>

   7:      {

   8:          public cityMap()

   9:          {

  10:              // Primary Key

  11:              this.HasKey(t => t.ID);

12:

  13:              // Properties

  14:              this.Property(t => t.Name)

  15:                  .IsRequired()

  16:                  .HasMaxLength(35);

17:

  18:              this.Property(t => t.CountryCode)

  19:                  .IsRequired()

  20:                  .HasMaxLength(3);

21:

  22:              this.Property(t => t.District)

  23:                  .IsRequired()

  24:                  .HasMaxLength(20);

25:

  26:              // Table & Column Mappings

  27:              this.ToTable("city", "world");

  28:              this.Property(t => t.ID).HasColumnName("ID");

  29:              this.Property(t => t.Name).HasColumnName("Name");

  30:              this.Property(t => t.CountryCode).HasColumnName("CountryCode");

  31:              this.Property(t => t.District).HasColumnName("District");

  32:              this.Property(t => t.Population).HasColumnName("Population");

33:

34: // Relationships //这里加了一个关系 35: this.HasRequired(t => t.country) //这个指向city 模型的 public virtual country country { get; set; } 36: .WithMany(t => t.cities) //这个指向country模型的 public virtual ICollection<city> cities { get; set; } 37: .HasForeignKey(d => d.CountryCode); //这个指向city模型的public string CountryCode { get; set; }

38:

  39:          }

  40:      }

  41:  }

以上是city映射，下面是country映射

using System.ComponentModel.DataAnnotations.Schema;

using System.Data.Entity.ModelConfiguration;

namespace EFEntity.Models.Mapping

    public class countryMap : EntityTypeConfiguration<country>

        public countryMap()

            // Primary Key

            this.HasKey(t => t.Code);

            // Properties

            this.Property(t => t.Code)

                .IsRequired()

                .HasMaxLength(3);

            this.Property(t => t.Name)

                .IsRequired()

                .HasMaxLength(52);

            this.Property(t => t.Continent)

                .IsRequired()

                .HasMaxLength(65532);

            this.Property(t => t.Region)

                .IsRequired()

                .HasMaxLength(26);

            this.Property(t => t.LocalName)

                .IsRequired()

                .HasMaxLength(45);

            this.Property(t => t.GovernmentForm)

                .IsRequired()

                .HasMaxLength(45);

            this.Property(t => t.HeadOfState)

                .HasMaxLength(60);

            this.Property(t => t.Code2)

                .IsRequired()

                .HasMaxLength(2);

            // Table & Column Mappings

            this.ToTable("country", "world");

            this.Property(t => t.Code).HasColumnName("Code");

            this.Property(t => t.Name).HasColumnName("Name");

            this.Property(t => t.Continent).HasColumnName("Continent");

            this.Property(t => t.Region).HasColumnName("Region");

            this.Property(t => t.SurfaceArea).HasColumnName("SurfaceArea");

            this.Property(t => t.IndepYear).HasColumnName("IndepYear");

            this.Property(t => t.Population).HasColumnName("Population");

            this.Property(t => t.LifeExpectancy).HasColumnName("LifeExpectancy");

            this.Property(t => t.GNP).HasColumnName("GNP");

            this.Property(t => t.GNPOld).HasColumnName("GNPOld");

            this.Property(t => t.LocalName).HasColumnName("LocalName");

            this.Property(t => t.GovernmentForm).HasColumnName("GovernmentForm");

            this.Property(t => t.HeadOfState).HasColumnName("HeadOfState");

            this.Property(t => t.Capital).HasColumnName("Capital");

            this.Property(t => t.Code2).HasColumnName("Code2");

测试代码--延迟加载：

 using (var context = new worldContext())

                var country = from d in context.countries

                            where d.Name == "United States"

                            select d;

                var countryUS = country.Single();

                if (countryUS == null) return;

                foreach (var city in countryUS.cities)

                    Console.WriteLine(city.Name);

                Console.Read();

测试代码--预先加载：

            using (var context = new worldContext())

                var allCountries = context.countries.Include(p => p.cities);

                foreach (var country in allCountries)

                    Console.WriteLine(country.Name);

                    foreach (var city in country.cities)

                        Console.WriteLine("__" + city.Name);

                Console.Read();

巴特西

Entity Framework Code First -- 延迟加载和预先加载

测试代码--延迟加载：

测试代码--预先加载：

最新文章

热门文章