static void Main(string[] args)
{
productDBContext context = new productDBContext();
var product = context.Products;
var product1 = product.Add(new product()
{
productId = 1, Name = "badam drink", price = 20.99, quantity = "150ml", categoryId = 1
});
var product2 = product.Add(new product()
{
productId = 2, Name = "coffee drink", price = 49.99, quantity = "250ml", categoryId = 1
});
var product3 = product.Add(new product()
{
productId = 3, Name = "coke drink", price = 50.99, quantity = "200ml", categoryId = 1
});
var categories = context.categories;
var category1 = categories.Add(new category()
{
categoryID = 1, name = "bevereges"
});
context.SaveChanges();
}
public static void linqtoentity()
{
productDBContext context = new productDBContext();
var x = from product in context.Products
where product.price <= 50.00
select product;
foreach (var product in x)
{
Console.WriteLine("product name ={0}", product.Name);
}
}
static void Main(string[] args)
{
productDBContext context = new productDBContext();
//var product = context.Products;
//var product1 = product.Add(new product() { productId = 1, Name = "badam drink", price = 20.99, quantity = "150ml", categoryId = 1 });
//var product2 = product.Add(new product() { productId = 2, Name = "coffee drink", price = 49.99, quantity = "250ml", categoryId = 1 });
//var product3 = product.Add(new product() { productId = 3, Name = "coke drink", price = 50.99, quantity = "200ml", categoryId = 1 });
//var categories = context.categories;
//var category1 = categories.Add(new category() { categoryID = 1, name = "bevereges" });
//var category2 = categories.Add(new category() { categoryID = 4, name = "hot drinks" });
//var student = context.students;
//var student1 = student.Add(new student() { studentID = 1, name = "vimal", department = "it" });
//var student2 = student.Add(new student() { studentID = 2, name = "raj", department = "mec" });
//var teachers = context.teachers;
//var teacher1 = teachers.Add(new teacher() { teacherID = 1, name = "vima", department = "it" });
//var teacher2 = teachers.Add(new teacher() { teacherID = 2, name = "ra", department = "mec" });
context.SaveChanges();
linqtoentity();
}
