Get foreign key table with a single query using LINQ

LINQ query or GetObjectKey to get single Entity Framework entities?

In my solution, I use generic programming. In the base Repository class I have code like this:...private string GetEnittySetName(string entityTypeName) { var container = context.MetadataWorkspace.GetEntityContainer(context.DefaultContainerName, DataSpace.CSpace); string entitySetName = (from meta in container.BaseEntitySets ...

From a foreign key in a table, EF does not construct a foreign key association.

I have a table tblEvent and another table tblContact. There is a field ContactID in tblEvent that is linked by a foreign key to ContactID in tblContact. I've triple checked; the foreign key is in the database....The Entity Framework model DOES NOT generate a navigation property and foreign key association for it as it does for the other foreign k...

Using Entity Framework and a single LINQ query, delete numerous records

Install Entity Framework Extended Library (PM> Install-Package EntityFramework.Extended)...Import EntityFramework.Extensions in your code...Delete records specified by inner query...context.Orders.Where(o=>o.User_ID == 1).Delete(); ...Deletes all records inside Orders with userID = 1

New records inserted in foreign key table when inserting in parent table

I am new to Asp.net MVC and working on a simple blog application (Asp.Net MVC5, EF6) for learning. ...I am using repository pattern for the solution architecture with EF Code first migration, Ninject for DI. On the client side, I am using jQuery Grid for Admin to manage Posts, Categories and Tags. ...- Blog.Model: Post.cs, Category.cs, Tags.cs...pu...

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

I'm having a hard time finding the exact answer to this question, so my apologies if this is redundant....So I have 3 tables defined such that:...Person :PersonId, FirstName, LastName...Company: CompanyId, CompanyName...Order: OrderId, PersonId, CompanyId...On the Order table, there is a foreign key defined on the PersonId and CompanyId columns, th...

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

Delete the foreign key data when the data in the foreign table is deleted

It can be possible when .Net or EF generated the code for your context that the ....WillCascadeOnDelete() ...was set to false, so just change it to true and try if it works.

Searching for multiple strings using single database query with entity framework and LINQ

Assuming I have a database table (aTable) with two columns ...id : int...name: string ...Requirements: I want to retrieve entries where aTable.name is like a list of strings (stringsToSearchFor)....What I am doing: Currently I am using the following approach ...var result=new List<aTable>; foreach (var aString in stringsToSearchFor) { ...

Getting error while inserting department foreign key in Employee table

I am beginner to Entity Framework. I want to insert employees along with department as foreign key, but I am getting the following error while adding records:...The INSERT statement conflicted with the FOREIGN KEY constraint \"FK_dbo.Employees_dbo.Departments_DepartmentId\". The conflict occurred in database \"EmpDB\", table \"dbo.Departments\", co...