public void InsertWithData(int categorieId) { using (BissInventaireEntities conn = new BissInventaireEntities()) { /* * this steps follow to both entities * * 1 - create instance of entity with relative primary key * * 2 - add instance to context * * 3 - attach instance to context */ // 1 Categorie p = new Categorie { Id_categorie = categorieId }; // 2 conn.Categorie.Add(p); // 3 conn.Categorie.Attach(p); // 1 // call SaveChanges conn.SaveChanges(); } }
public void DeleteRelationship(int idCategorie, int idSousCategorie) { using (BissInventaireEntities conn = new BissInventaireEntities()) { // return one instance each entity by primary key var soucat = conn.Sous_categorie.FirstOrDefault(s => s.id_sous_categorie == idSousCategorie); var cat = conn.Categorie.FirstOrDefault(p => p.Id_categorie == idCategorie); // call Remove method from navigation property for any instance // supplier.Product.Remove(product); // also works //product.Sous_categorie.Remove(supplier); cat.Sous_categorie.Remove(soucat); //soucat.Id_categorie.Remove(cat); // call SaveChanges from context conn.SaveChanges(); } }