Entity Framework composite key delete with one primary key

c# entity-framework-6 repository-pattern

Question

Here's some of my database design on my assignments

Customer
--------
CustomerID (PK)

Cake
-------
CakeID (PK)

Cart
-------
CustomerID (PK, FK)
CakeID (PK, FK)

I'd like to make a function clearUserCart(User user) in my Cart Repository class but I have no idea how to make function to delete all rows with specified user.

EDIT : I have figured out how to do it, just use getCartOfUser(User user) which returns List<Cart>. Then do foreach loop to remove. In SQL, it could be achieved just by one line DELETE FROM Cart WHERE CustomerID = <the cust id>, is there an equivalent one line statement in entity framework?

1
0
4/12/2017 12:48:19 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

If you are using EF 6, you can use the RemoveRange method.

So it could look something like this;

context.Cart.RemoveRange(cartItem => cartItem.CustomerID == CustomerToDelete);
1
4/12/2017 12:57:39 PM

Related Questions

In Entity Framework 4, how do I map a composite main key first?

You could also use...HasKey(u => new { u.SubscriptionID, u.UserName }); ...Edit:...One limitation I have found is that the following do not work:...public ProjectAssignmentConfiguration() { HasKey(u => u.Employee.EmployeeId); HasKey(u => u.Project.ProjectId); } ...or...public ProjectAssignmentConfiguration() { HasKey(u => new { u.Employ...
composite-key entity-framework orm
asked by djskinner

Foreign Key mapping to composite keys in entity framework

You have 2 options here....Use attributes as you have eg:...[ForeignKey("PatientContact"), Column(Order = 0)] public int Person_ID{ get; set; } [ForeignKey("PatientContact"), Column(Order = 1)] public int Patient_ID{ get; set; } public virtual PatientContact PatientContact { get; set; } ...Use the model builder (fluent api)...modelBuilder.Entity<Ev...
c# ef-code-first entity-framework
asked by Not loved

Entity Framework Foreign Key as Primary Key Code First

I thought I'd give this a shot and it worked nicely....public class FooState { [Required] [Key] [ForeignKey("Foo")] public int FooStateId { get; set; } [Required] public int State { get; set; } public Foo Foo { get; set; } }
c# ef-code-first entity-framework
asked by Neil

Code Generation : Add primary key / foreign key to Entity Framework

I ran into the same problem. The template file you are looking for appears in the Solution Explorer (in VS2013) as:...YourDataModelName.tt...You can modify it to add the ...[Key]... attributes to the generated code by following:...Finding a property is Primary Key in POCO Template t4 generator
c# code-generation entity-framework-6
asked by srg39

EntityFramework - Composite Key Table with FK to another Composite Key Table

If between ...City... and ...Company... you want to create a one-to-one relationship I'm afraid that is not possible following your model. When you are configuring a one-to-one relationship, Entity Framework requires that the primary key of the dependent end also be the foreign key, otherwise EF doesn't see it as one-to-one relationship. The depend...
asp.net-mvc-5 composite-primary-key entity-framework entity-framework-6 foreign-key-relationship
asked by octavioccl

Entity Framework 6.1.3 Mapping Foreign key to non primary key

This is now possible in Entity Framework 7 (that is, EF Core 1.0)....From .Net Entity Framework User Voice ...Unique Constraint (i.e. Candidate Key) Support...:...Support for this feature was added in EF Core 1.0 and we don’t have plans to add it in the EF6 codebase.
c# entity-framework-6
asked by ErikE

Entity Framework code-first set foreign key with primary key in same table

This answer for your requirement of 2 foreign keys ...public class WdUser : SysDomainModelBase, IWdUser { //This is your primary key of WDUser public int UserID{get;set;} //This is for your 1st foreign key mapping public virtual WDUser WDUser{get;set;} public virtual ICollection<WDUser> WDUserList{get;set;} public int fk1{get;set;} //This is for y...
asp.net c# entity-framework-6
asked by Nithila Shanmugananthan

How create composite foreign key to table with composite primary key

Composite foreign key requires ...ForeignKey... attribute to be applied on the navigation property specifying the comma separated list of the foreign key property names:...If you add the ...ForeignKey... attribute to a foreign key property, you should specify the name of the associated navigation property. If you add the ...ForeignKey... attribute ...
code-first entity-framework-6 foreign-keys
asked by Ivan Stoev

Mapping composite foreign key to composite primary key where the foreign key is also a primary key

The main difference between your question and the one I suggested as ...duplicate... is that your ...ForeignKey... attributes don't refer -...from a primitive property to a navigation property...from a navigation property to a primitive property...In your case, the reference is from a primitive property to another primitive property, in another typ...
data-annotations entity-framework entity-framework-6
asked by Gert Arnold

Entity Framework foreign key that is not a primary key

I wanted to switch from only IDs to GUIDs for uniqueness and changed the tables. ...You don't really need to switch to GUIDs to ensure uniqueness.Your IDs will be guaranteed to be unique (whichever type they are, say integer) as long as they are set as your primary keys....I have read that GUIDs as primary keys are not recommended for performance r...
c# entity-framework entity-framework-6 guid sql
asked by Jan Paolo Go

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow