public bool Create(string name, string description)
{
bool bRet = false;
using (var context = GetDbContext())
{
DbSet<Major> majors = context.Set<Major>();
Major major = new Major() { Name = name, Description = description };
majors.Add(major);
context.SaveChanges();
bRet = true;
}
return bRet;
}
public void InsertseDbContextTest()
{
DbContextHelper.Init(typeof(CourseDbContext), GlobalSettings.DATABASE.ConnectionString, 8);
using (var db = DbContextHelper.NewInstance())
{
var majors = db.Set<Major>();
Major major = new Major { Name = "萌系", Description = "专业卖萌20年" };
Major majorEle = new Major { Name = "电子系", Description = "专业修电脑20年" };
majors.Add(major);
majors.Add(majorEle);
var teachers = db.Set<Teacher>();
Teacher teacher = new Teacher { Name = "John", Email = "*****@*****.**", Password = Guard.Encrypt("password") };
teachers.Add(teacher);
var students = db.Set<Student>();
Student student = new Student { Name = "Yuge", Email = "*****@*****.**", Password = Guard.Encrypt("password") };
students.Add(student);
// var teacher = teachers.Where(t => t.Id == 1).FirstOrDefault();
var courses = db.Set<Course>();
Course course = new Course { Name = "反卖萌的研究", Description = "深入了解卖萌心里，卖萌比卖淫更可耻！", Major = major, Teacher = teacher };
Course courseCS = new Course { Name = "C#", Description = "Microsoft .Net 平台开发", Major = majorEle, Teacher = teacher };
courses.Add(course);
courses.Add(courseCS);
var classrooms = db.Set<Classroom>();
Classroom classroom = new Classroom { Location = "Little place" };
classrooms.Add(classroom);
var dispatches = db.Set<Dispatch>();
Dispatch dispatch = new Dispatch
{
Teacher = teacher,
Course = course,
Enable = true,
Current = 0,
Weekday = "1",
At = DateTime.Now,
Limit = 50,
Classroom = classroom
};
Dispatch dispatchCS = new Dispatch
{
Teacher = teacher,
Course = courseCS,
Enable = true,
Current = 0,
Weekday = "2",
At = DateTime.Now,
Limit = 100,
Classroom = classroom
};
dispatches.Add(dispatch);
dispatches.Add(dispatchCS);
db.SaveChanges();
/*var courses = db.Set<Course>();
var teachers = db.Set<Teacher>();
Teacher teacher = teachers.Where(t => t.Id == 1).ToList()[0];
Course course = courses.Where(c => c.Id == 1).ToList()[0];*/
}
}
