How can I remove a record using its primary key in Entity Framework?

Getting the primary key ID for an added entry in Entity Framework 4

After you have inserted the entity it should have been updated so that the property that maps to the primary key in the database has the new PK value.

Entity Framework Foreign Key as Primary Key Code First

I have two code first models, Foo and FooState where Foo has an optional FooState....public class Foo { [Key] public int FooId { get; set; } public FooState FooState { get; set; } } public class FooState { [Key] public int FooStateId { get; set; } [Required] public int State { get; set; } [Required] public Fo...

In Entity Framework, how to delete record with foreign key constraint?

I have a method to delete a "project" record in the database, and all the "option items" associated with it....public bool DeleteProjectById(int id) { using (DbContext db = new DbContext(ConfigHelper.Instance().ConnectionString)) { try { foreach (var entity in db.ProjectOptionItems.Where(o => o.ProjectId == id)) ...

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

I'm using EF with database first approach....I would like to add attribute to the generated code to mark property as primary key / foreign key when it's the case....For example, if I have a table ...User... in my database...CREATE TABLE User ( Id int PRIMARY KEY ); ...I would like my generated code to include an attribute that indicate that ...I...

Entity Framework 6.1.3 Mapping Foreign key to non primary key

The goal is to have an API with all the fields from the GravityZone with the name of the zone coming from the Zone table. I've tried several permutations of the following code without success. It's currently coming up with null for the Zone which I'm hoping to get either the name as a string or part of the object. I'm working with existing tables ...

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

I have this ...WdUser... class inherited from ...SysModelBase...:...[Serializable] public class WdUser : SysDomainModelBase, IWdUser { [Display(Name = "UserName")] [MaxLength(25)] [Required] public string UserName { get; set; } [Required] [Index(IsUnique = true)] [MaxLength(25)] [Display(Name = "LoginName ")] pu...

Entity Framework, Load multiple entities by primary key in a single query while still using caching

I have a list of primary key ids for a table whose entities I want to pull into EF memory, modify, and then save....With a single id you would do something like...var entity = dbContext.Entity.Find(id); entity.SomeColumn = "something"; dbContext.SaveChanges() ...Currently I'm doing something like this to pull all the entities to be modified in on...

Entity Framework: how to delete related entity upon update or delete of 'generic' parent

I think you can configure the ...Picture... as ...ComplexType... that will make the properties of ...Picture... class columns in the parent table....This means:...Whenever the parent is deleted, the corresponding ...Picture... is deleted....Whenever the parent is updated with new ...Picture... data (updated picture data or no data), corresponding c...

Entity Framework composite key delete with one primary key

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 ha...

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...