public static void LinqToEntity()
{
studentDBContext context = new studentDBContext();
var Econstudents = from student in context.students
where student.marks < 90
select student;
foreach (var student in Econstudents)
{
Console.WriteLine("studentID: {0}, Name: {1},marks: {2}", student.studentID, student.Name, student.marks);
}
}
static void Main(string[] args)
{
studentDBContext context = new studentDBContext();
//var student = context.students;
//var student1 = student.Add(new student() { studentID = 1, Name = "sam", marks = 100.00, Quality = "best", CategoryID = 1 });
//var student2 = student.Add(new student() { studentID = 2, Name = "sammyyy", marks = 60.89, Quality = "pass", CategoryID = 1 });
////var studentt3 = student.Add(new student() { studentID = 3, Name = "carol", marks = 70.89, Quality = "average ", CategoryID = 1 });
//var categories = context.Categories;
//var category1 = categories.Add(new Category() { CategoryID = 1, Name = "details" });
//context.SaveChanges();
LinqToEntity();
}
