public static void Delete(int id)
{
DemodataEntities db = new DemodataEntities();
Product p1 = db.Products.Find(id);
db.Products.Remove(p1);
db.SaveChanges();
Console.WriteLine("\nProduct Table after Delete");
var result = db.Products.ToList <Product>();
foreach (var r in result)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}", r.Id, r.Name, r.Price, r.Qty);
}
}
public static void Update(int id, string name)
{
DemodataEntities db = new DemodataEntities();
Product product = db.Products.Find(id);
product.Name = name;
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
Console.WriteLine("\nProduct Table after Update");
var result = db.Products.ToList <Product>();
foreach (var r in result)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}", r.Id, r.Name, r.Price, r.Qty);
}
}
public static void Insert()
{
DemodataEntities db = new DemodataEntities();
Product product = new Product
{
Name = "Processor",
Price = 27000,
Qty = 5
};
db.Products.Add(product);
db.SaveChanges();
Console.WriteLine("\nProduct Table after Insert");
var result = db.Products.ToList <Product>();
foreach (var r in result)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}", r.Id, r.Name, r.Price, r.Qty);
}
}
//Q1.Using entity frame work complete schema first approach and perform insert, delete, update
static void Main(string[] args)
{
DemodataEntities db = new DemodataEntities();
var result = db.Products.ToList <Product>();
//Console.WriteLine(db.Products); //for printing the Querry
foreach (var r in result)
{
Console.WriteLine("{0}\t{1}\t{2}\t{3}", r.Id, r.Name, r.Price, r.Qty);
}
//counting the instances
var resultcount = db.Products.Count <Product>();
Console.WriteLine(" Total no of entries : " + resultcount);
Insert();
Delete(3002);
Update(1008, "LED");
}