Musical store MVC Mapping : The Official Microsoft ASP.NET Forums

Reply

Decker Dong ...

All-Star

118619 Points

18779 Posts

Re: Musical store MVC Mapping

Jun 02, 2011 06:54 AM|LINK

Hello：）

I did a demo, and I'm using EF4.1——

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CodeFirstDemo
{
    public class Course
    {
        public int CourseId { get; set; }
        public string Title { get; set; }
        public int Credits { get; set; }
        public int EnrollmentId { get; set; }
        public virtual ICollection<Enrollment> Enrollments { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CodeFirstDemo
{
    public partial class Enrollment
    {
        public int EnrollmentId { get; set; }
        public int CourseId { get; set; }
        public int StudentId { get; set; }
        public double Grade { get; set; }
        public virtual Student student { get; set; }
        public virtual Course course { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Entity;

namespace CodeFirstDemo
{
    public partial class Student
    {
        public int StudentID { get; set; }
        public string Lastname { get; set; }
        public string FirstmidName { get; set; }
        public DateTime Enrollmentdate { get; set; }
        public virtual ICollection<Enrollment> Enrollments { get; set; }

    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Entity;

namespace CodeFirstDemo
{
    public class MyProductContext : DbContext
    {
        public DbSet<Course> Courses { get; set; }
        public DbSet<Student> Students { get; set; }
        public DbSet<Enrollment> Enrollments { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Entity;

namespace CodeFirstDemo
{

    class Program
    {
        static void Main(string[] args)
        {
            using (MyProductContext md = new MyProductContext())
            {
                Student stu = new Student { StudentID = 1, FirstmidName = "Mary", Lastname = "Smith", Enrollmentdate = DateTime.Now };
                Course co = new Course { CourseId = 1, EnrollmentId = 1, Title = "English", Credits = 5 };
                md.Students.Add(stu);
                md.Courses.Add(co);
                md.SaveChanges();
                Console.WriteLine("OK");
            }
         
        }
    }
}