Entity Framework 6 - Knowledge Base (KB)

ADO.NET Entity Framework: Update Wizard will not add tables

I ...added a new ADO.Net Entity Data Model... into my project and used the ...Update Wizard... to add tables into the model. Five of the selected tables were added to the design surface. Two other tables will not add. I select them in the wizard and cl...

Entity Framework and SQL Server View

For several reasons that I don't have the liberty to talk about, we are defining a view on our Sql Server 2005 database like so:...CREATE VIEW [dbo].[MeterProvingStatisticsPoint] AS SELECT CAST(0 AS BIGINT) AS 'RowNumber', CAST(0 AS BIGINT) AS 'Pr...

Entity framework primary keys in Views

I have to use a View with the EF but, when I import it, the primary key of the view is displayed incorrectly and for some reason I can't change it.

Composite DB keys with Entity Framework 4.0

The re-design for a large database at our company makes extensive use of composite primary keys on the database....Forgetting performance impacts, will this cause any difficulties when working with this db in Entity Framework 4.0? The database structure i...

Adding Item with Many-to-Many Relationship In Entity Framework

I am getting a primary key violation error when I attempt to add an item with a many-to-many relationship:...I have two classes - Articles and Tags which have a many-to-many relationship : ...public class Article { public int ID { get; set; } publ...

Unable to update the EntitySet - because it has a DefiningQuery and no <UpdateFunction> element exist

I am using Entity Framework 1 with .net 3.5....I am doing something simple like this:...var roomDetails = context.Rooms.ToList(); foreach (var room in roomDetails) { room.LastUpdated = DateTime.Now; } ...I am getting this error when I try to d...

What are the best practices for using a GUID as a primary key, specifically regarding performance?

I have an application that uses GUID as the Primary Key in almost all tables and I have read that there are issues about performance when using GUID as Primary Key. Honestly, I haven't seen any problem, but I'm about to start a new application and I still...

How To Set a Primary Key On a View Using ROW_NUMBER()?

I use SQL Server 2008 and Entity Framework for an app I work on. ...I've set primary keys on all tables in SQL Server, since EF requires it, but I have a problem with one view. Since it doesn't have primary key, I've used ROW_NUMBER() function to get uniq...

Save detached object graph using Entity Framework code first causes Primary Key violation

I'm trying to save an object graph of POCOs I have mapped to EF6 using Code First fluent notations....Upon saving the object graph however, I stumble upon primary key violation exceptions....The object graph is quite simple:...One ...Issue... can contain ...

How to manually set entity primary key in Entity Framework code first database?

Well, I have the following model structure: I have one class - ...DatabaseEntity... which is basically ...public class DatabaseEntity { public int Id { get; set; } } ...so each entity like product, category etc will inherit ...DatabaseEntity... and ha...

Attaching an entity of type failed because another entity of the same type already has the same primary key value.

Let me quickly describe my problem....I have ...5 databases... for 5 customers and ...each has the same table called SubnetSettings.... ...I already created a dropdownlist to select a customer and will shows up the SubnetSetting table which belong to sele...

Should I use an int or a long for the primary key in an entity framework model

I am writing an MVC5 Internet application and I have a question about the id field for a model....Should I use an int or a long for the id in a model? I am talking about the field that is used for the primary key? Is an int enough if the database has 100,...