// Since EF knows to look for a connection string with the same name as the context, // we can specify the connection string in our application config file (app.config) public int AddStudent(string studentName) { // Instead of opening a connection, we just initialize the context using (var context = new SchoolContext()) { // Lets create a new Student entity to add Student student = new Student() { Name = studentName }; // Adding a new Student object to the SchoolContext.Students collection creates a new record context.Students.Add(student); // Our new record isn't actually saved to the database until SchoolContext.SaveChanges is called return context.SaveChanges(); } }
static void Main(string[] args) { Console.WriteLine("hello world. This is Entity framework."); using (var ctx = new SchoolContext()) { // ctx.Database.Initialize(false); Student s = new Student(); Console.Write("Enter Student Details"); Console.Write("Name: "); s.Name = Console.ReadLine().ToString(); Console.Write("Phone: "); s.Phone = Console.ReadLine().ToString(); Console.Write("Address: "); s.Address = Console.ReadLine().ToString(); Console.Write("Course: "); s.Course = Console.ReadLine().ToString(); Console.Write("Description: "); s.Description = Console.ReadLine().ToString(); s.DateOfBirth= new DateTime(1990,12,01); ctx.Students.Add(s); ctx.SaveChanges(); var query = from st in ctx.Students orderby st.Name select st; Console.WriteLine("Students in Student context"); foreach (var item in query) { Console.WriteLine(item.Name); } Console.ReadLine(); } }