Entity Framework(code first)数据库初始化
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Entity Framework(code first)数据库初始化,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含5948字,纯文字阅读大概需要9分钟。
内容图文
![Entity Framework(code first)数据库初始化](/upload/InfoBanner/zyjiaocheng/465/cc261e1f224b45c3b20e19223ac0a0d2.jpg)
//1.修改模型,重设数据库 using System.Data.Entity; Database.SetInitializer<LisknoveDataContext>(newDropCreateDatabaseIfModelChanges<LisknoveDataContext>()); //2.修改模型,重设数据库,并初始化数据 using System.Data.Entity; public class LisknoveInitializer:DropCreateDatabaseIfModelChanges<LisknoveDataContext> { protected override void Seed(LisknoveDataContext context) { //base.Seed(context); var genre = new List<Genre> { new Genre{ genreName="Marry" }, new Genre{ genreName="Weair" } }; var material = new List<Material> { new Material{ materialName="Stone" }, new Material{ materialName="Water" }, new Material{ materialName="Flooen" } }; var ring = new List<Ring> { new Ring{ ringName="MakeRing", price=17.21M, ringImage="ke.jpg", Genre=genre.Single(g=>g.genreName=="Marry"), Material=material.Single(m=>m.materialName=="Water") }, new Ring{ ringName="ForverRing", price=15.01M, ringImage="for.jpg", Genre=genre.Single(g=>g.genreName=="Marry"), Material=material.Single(m=>m.materialName=="Flooen") } }; //genre.ForEach(g => context.Genres.Add(g)); ring.ForEach(r => context.Rings.Add(r));//this way enough add data to database without genre and material to add to database. } } Database.SetInitializer<LisknoveDataContext>(new LisknoveInitializer());
- using System.Collections.Generic;
- public class UserInfo
- {
- public int UserInfoID { get; set; }
- public string userName { get; set; }
- public int age { get; set; }
- public virtual ICollection<Lesson> lessones { get; set; }
- }
using System.Collections.Generic; public class UserInfo { public int UserInfoID { get; set; } public string userName { get; set; } public int age { get; set; } public virtual ICollection<Lesson> lessones { get; set; } }
[csharp] view plain copy print?
- using System.Collections;
- using System.Collections.Generic;
- public class Lesson {
- public int lessonID { get; set; }
- public string lessonName { get; set; }
- public string teacherName { get; set; }
- public virtual UserInfo UserInfo{get;set;}
- }
using System.Collections; using System.Collections.Generic; public class Lesson { public int lessonID { get; set; } public string lessonName { get; set; } public string teacherName { get; set; } public virtual UserInfo UserInfo{get;set;} }
[csharp] view plain copy print?
- using System.Data.Entity;
- public class TestUsersDB : DbContext
- {
- public DbSet<UserInfo> UserInfoes { get; set; }
- public DbSet<Lesson> Lessons{get;set;}
- }
using System.Data.Entity; public class TestUsersDB : DbContext { public DbSet<UserInfo> UserInfoes { get; set; } public DbSet<Lesson> Lessons{get;set;} }
[csharp] view plain copy print?
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.Mvc;
- using System.Data.Entity;
- namespace MvcApplication1.Controllers
- {
- public class HomeController : Controller
- {
- public string Index()
- {
- ViewBag.Message = "欢迎使用 ASP.NET MVC!";
- Database.SetInitializer<TestUsersDB>(new DropCreateDatabaseIfModelChanges<TestUsersDB>());
- var getName = 0;
- using(TestUsersDB context = new TestUsersDB()){
- var users = new UserInfo() { userName="xcl",age=23};
- context.UserInfoes.Add(users);
- context.SaveChanges();
- getName = (from c in context.UserInfoes where c.age > 0 select c.age).First();
- }
- return getName.ToString();
- //return View(getName);
- }
- public ActionResult About()
- {
- return View();
- }
- }
- }
Entity Framework(code first)数据库初始化
标签:
本文系统来源:http://www.cnblogs.com/lvdongjie/p/5561984.html
内容总结
以上是互联网集市为您收集整理的Entity Framework(code first)数据库初始化全部内容,希望文章能够帮你解决Entity Framework(code first)数据库初始化所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。