[Table("Patient")]
    class Patient
    {
        public Patient()
        {
            Visits = new List<Visit>();

        }

        public int Id { get; set; }

        public string Name { get; set; }

        public DateTime BirthDate { get; set; }

        public AnimalType AnimalType { get; set; }

        public DateTime FirstVisit { get; set; }

        public List<Visit> Visits { get; set; }

        [NotMapped]
        public string Extend { get; set; }
    }




//----------------------------------

    class VetContext : DbContext
    {
        public VetContext(string nameOrConnection):base(nameOrConnectionString:nameOrConnection)
        {
           // Database.SetInitializer<VetContext>(new DropCreateDatabaseIfModelChanges<VetContext>());
            Database.SetInitializer<VetContext>(new CreateDatabaseIfNotExists<VetContext>());
        }
        public VetContext() { }

        //还需要返回Patient类和Visit类的可查询数据集DbSets，以暴露类中的属性
        public DbSet<Patient> Patients { get; set; }
}
//main-----
        static void Main(string[] args)
        {
            CodeFirst.VetContext context = new CodeFirst.VetContext("Paients");

            //CreateNewPatient();
            Console.WriteLine("Completed!");

           // SqlParameter param = new SqlParameter("@id", 1);
            var name = context.Patients.SqlQuery("EXECUTE GetNameById @p0", "Sampson").ToList();
            //var name = context.Database.SqlQuery<CodeFirst.Patient>("EXEC GetNameById Sampson");
            foreach (var item in name)
            {
                Console.WriteLine(item.Name);
            }
            Console.ReadKey();
        }