public static void AddMemeber(Member m)
{
var context = new CommereceDBContext();
context.Members.Add(m);
context.SaveChanges();
}
public static void Update(Product p)
{
var context = new CommereceDBContext();
//Tell EF this product has only been modified
//It's already in the database
context.Entry(p).State = EntityState.Modified;
//Send Update query to the DB
context.SaveChanges();
}
//missisng something
public static void DeleteProduct(int id)
{
var context = new CommereceDBContext();
//makes Ef recognize that p came from the DB.
Product p = context.Products.Find(id);
//marks p for deletion
context.Products.Remove(p);
//sends the above query to the DB
context.SaveChanges();
}
// step 1. create a instance of the db
// step 2. Add a pending object
// step 3. execute the add using saveChanges();
/// <summary>
/// adds a product to the database using entity syntax. //////////////////// REFERENCE
/// </summary>
/// <param name="p"></param>
public static void AddProduct(Product p)
{
//1.
//Create instance of DBContext class.
//context is referencingthe DB
CommereceDBContext context = new CommereceDBContext();
//2.
//Prepare insert statement
//tells entity you want to add a product (p) to the database dosnt add it.
context.Products.Add(p);
// 3.
//Execute pending insert //the pending insert is what was done above with context.Products.Add(p)
context.SaveChanges();
}