static void Main(string[] args)
{
TrainingEntities ctx = new TrainingEntities();
ctx.Database.Log = Console.WriteLine;
/***** Insertion - Add course to COURSES table using INSERT command ****/
//Course c = new Course { Title = "Java SE", Fee = 4000, Duration = 36 };
//ctx.Courses.Add(c);
//ctx.SaveChanges();
/***** List courses - SELECT *****/
//foreach (Course c in ctx.Courses)
// Console.WriteLine(c.Title);
/***** Update FEE of a course ****/
//var course = ctx.Courses.Find(1004);
//if (course == null)
// Console.WriteLine("Sorry! Course not found!");
//else
//{
// Console.WriteLine(course.Title);
// course.Fee = course.Fee + 500;
// ctx.SaveChanges();
//}
/***** Delete object from COURSES table *****/
//var course = ctx.Courses.Find(1004);
//if (course == null)
// Console.WriteLine("Sorry! Course not found!");
//else
//{
// ctx.Courses.Remove(course);
// ctx.SaveChanges();
//}
/**** Query ***/
var courses = from c in ctx.Courses
where c.Fee > 5000
orderby c.Fee
select new { Title = c.Title, Fee = c.Fee * 0.9 };
foreach (var c in courses)
{
Console.WriteLine(c.Title);
}
}
static void Main(string[] args)
{
TrainingEntities ctx = new TrainingEntities();
ctx.Database.Log = Console.WriteLine;
/** life cycle of addition **/
//Course c = new Course { Title = "Java EE", Duration = 40, Fee = 6000 };
//Console.WriteLine(ctx.Entry(c).State);
//ctx.Courses.Add(c);
//Console.WriteLine(ctx.Entry(c).State);
//ctx.SaveChanges();
//Console.WriteLine(ctx.Entry(c).State);
/** Life cylce of updation **/
var c = ctx.Courses.Find(1002);
Console.WriteLine(ctx.Entry(c).State); // Unchanged
c.Fee = 5000;
Console.WriteLine(ctx.Entry(c).State); // Modified
Console.WriteLine(c.GetType().FullName);
Console.WriteLine(ObjectContext.GetObjectType(c.GetType()));
}