Entity Framework (code first) database initialization

2. 1. Modify the model and reset the database
4. Using System.Data.Entity;
8. Database.setinitializer<lisknovedatacontext> (Newdropcreatedatabaseifmodelchanges<lisknovedatacontext > ());
12. 2. Modify the model, reset the database, and initialize the data
14. using System.Data.Entity;
18. public class lisknoveinitializer:dropcreatedatabaseifmodelchanges<lisknovedatacontext>
20. {
22. protected override void Seed (Lisknovedatacontext context)
24. {
26. //base.  Seed (context);
28. var genre = New list<genre>
30. {
32. New genre{
34. Genrename="Marry"
36. },
38. New genre{
40. Genrename="Weair"
42. }
44. };
48. var material = New list<material>
50. {
52. New material{
54. Materialname="Stone"
56. },
58. New material{
60. Materialname="Water"
62. },
64. New material{
66. Materialname="Flooen"
68. }
70. };
74. var ring = New List<ring>
76. {
78. New ring{
80. Ringname="Makering",
82. price=17.21m,
84. ringimage="Ke.jpg",
86. Genre=genre. Single (g=>g.genrename=="Marry"),
88. Material=material. Single (m=>m.materialname=="water")
90. },
92. New ring{
94. Ringname="Forverring",
96. price=15.01m,
98. ringimage="For.jpg",
100. Genre=genre. Single (g=>g.genrename=="Marry"),
102. Material=material. Single (m=>m.materialname=="Flooen")
104. }
106. };
110. //genre. ForEach (g = context.  Genres.add (g));
112. Ring. ForEach (r = Context. Rings.add (R)); //this enough add data to database without genre
114. and material to the add to database.
116. }
118. }
122. Database.setinitializer<lisknovedatacontext> (new Lisknoveinitializer ());

123. 1. Modify the model and reset the database using System.data.entity;database. Setinitializer<lisknovedatacontext> (newdropcreatedatabaseifmodelchanges<lisknovedatacontext> ());//    2. Modify the model, reset the database, and initialize the data using System.Data.Entity; public class Lisknoveinitializer:dropcreatedatabaseifmodelchanges<lisknovedatacontext> {protected Overrid e 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"}, NE            W 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-enough ADD data to database without genre        and material to the add to database. }}database.setinitializer<lisknovedatacontext> (New LiSknoveinitializer ()); 

Example [CSharp]View PlainCopyprint?

2. Using System.Collections.Generic;
4. Public class UserInfo
6. {
8. public int userinfoid { get;  set;}
10. public string UserName { get;  set;}
12. public int Age { get;  set;}
14. public Virtual icollection<lesson> lessones { get;  set;}
16. }

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 PlainCopyprint?

2. Using System.Collections;
4. Using System.Collections.Generic;
6. Public class Lesson {
8. public int Lessonid { get;  set;}
10. public string Lessonname { get;  set;}
12. public string TeacherName { get;  set;}
14. public Virtual UserInfo userinfo{get;   Set;}
16. }

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 PlainCopyprint?

1. Using System.Data.Entity;
2. Public class Testusersdb:dbcontext
3. {
4. Public dbset<userinfo> userinfoes { get;  set;}
5. Public dbset<lesson> lessons{get;   Set;}
6. }

Using System.data.entity;public class testusersdb:dbcontext{public    dbset<userinfo> userinfoes {get; set;} Public    dbset<lesson> Lessons{get;set;}}

[CSharp]View PlainCopyprint?

2. Using System;
4. Using System.Collections.Generic;
6. Using System.Linq;
8. Using System.Web;
10. Using SYSTEM.WEB.MVC;
12. Using System.Data.Entity;
16. Namespace Mvcapplication1.controllers
18. {
20. public class Homecontroller:controller
22. {
24. public string Index ()
26. {
28. Viewbag.message = "Welcome to ASP. mvc!";
32. Database.setinitializer<testusersdb> (new dropcreatedatabaseifmodelchanges<testusersdb> ());
34. var getName = 0;
36. using (testusersdb context = new Testusersdb ()) {
38. var users = New UserInfo () {username="Xcl", age=23};
42. Context. Userinfoes.add (users);
44. Context. SaveChanges ();
48. GetName = (from the C in context.) Userinfoes where c.age > 0 select c.age).  First ();
50. }
52. return getname.tostring ();
54. //return View (getName);
56. }
60. Public ActionResult About ()
62. {
64. return View ();
66. }
68. }
70. }

Entity Framework (code first) database initialization