Entity Framework 6 - Knowledge Base (KB)
6940 results
"The EntityContainer name must be unique," says an Entity Framework error.
We have a solution which consists of two projects - a console application project and a web application project. Each of these has an identical in schema, but differently named .edmx file used to access the same database....The console application runs as...
asked by ENX
LINQ to Entities and String have a problem. StartsWith
I'm trying to build a search page using LINQ to Entities, but the following code is giving me a runtime error about l.t.e. not recognising 'Boolean StartsWith(). The code compiles just fine. How can I work around this better than shipping the StartsWith...
asked by ProfK
SaveChanges() in ADO.NET Entity Framework does not function.
I want to add new admin into my database. But it doesn't work it. Please look at the button1_Click event handler, I need to add value in this event. ...public partial class Form1 : Form { protected NetTanitimTestEntities adminNameContext; ...
asked by Penguen
In ADO.NET Entity Framework, how can I start a stored procedure?
How to use stored procedure in ADO.NET Entity Framework?...My Table : MyCustomer...Columns: CustomerID PK int Name nvarchar(50) SurName nvarchar(50) ...My stored procedure...ALTER procedure [dbo].[proc_MyCustomerAdd] (@Name ...
asked by Penguen
When invoking SaveChanges in the.NET Entity Framework, an InvalidOperationException occurs.
I'm trying to learn how to use the Entity framework but I've hit an issue I can't solve. What I'm doing is that I'm walking through a list of Movies that I have and inserts each one into a simple database....This is the code I'm using...private void AddMo...
asked by Paxxi
How can I use a subset of the main key to establish a referrential constraint in Entity Framework?
My data model contains two tables with composite primary keys and an associative table. Part of the composite primary key is common between the tables....SitePrivilege ------------- SiteId PrivilegeId UserSite -------- SiteId UserId UserSitePrivilege --...
asked by Michael L Perry
Error EF Distinct (IEqualityComparer)
Good Morning!...Given:...public class FooClass { public void FooMethod() { using (var myEntity = new MyEntity) { var result = myEntity.MyDomainEntity.Where(myDomainEntity => myDomainEntity.MySpecialID > default(int)).Di...
asked by Andreas Niedermair
Problem with Entity Framework EntityKey / Foreign Key
As the result of a form post, I'm trying to save a new Brand record. In my view, Gender is a dropdown, returning an Integer, which is populated from ViewData("gender")...I've setup my link as follows:...gID = CInt(Request.Form("Gender")) Brand.GenderRefer...
asked by Squiggs.
View of Entity Framework and SQL Server
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...
asked by Sergio Romero
"Problem with mapping fragments" error in Entity Framework. Please assist me in comprehending the causes of this mistake.
Error 3007: Problem in Mapping Fragments starting at lines 186, 205: Non-Primary-Key column(s) [WheelID] are being mapped in both fragments to different conceptual side properties - data inconsistency is possible because the corresponding conceptual side ...
asked by Kjensen
Primary keys in Entity Framework 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.
asked by Diego
In ADO.NET Entity Framework, how to utilize a stored procedure
I have 3 tables; I write a stored procedure in ADO.NET Entity Framework. ...ALTER PROCEDURE [dbo].[sp_GetDepartmanData] (@departman nvarchar(50)) BEGIN SELECT d.ID, d.Name as DepartmanName, sb.Salary, sb.email, sp.Name, sp.SurName, sp.Ph...
asked by Penguen
Entity Framework references aren't automatically loaded.
In the ADO.Net Entity Framework, I have an object which has 4 references to other objects. For some reason, when I query those references, two of them load automatically (as expected), and two of them always return null....Bizarrely enough, when I ...manu...
asked by gerrod
Like Entity Framework's Operator?
We're trying to implement the "LIKE" operator in Entity Framework for our entities with string fields, but it doesn't appear to be supported. Has anyone else tried to do something like this?...This ...blog post... summarizes the issue we're having. We c...
asked by brien
How do I fill the entity's navigation attributes using a stored procedure in Entity Framework?
Entity framework is cripplingly slow so I tried using a stored procedure but I ran into this problem....Entity Framework allows you to define a stored procedure that produces an entity. However my entity has 'navigation properties' which are not being pop...
asked by user48545
Json.Net is used to serialize Entity Framework objects.
How do I serialize entity framework object into JavaScript Object (JSON)? I tried using ...JSON.NET... but I am getting the following exception when I try to serialize it. ...Exception: Newtonsoft.Json.JsonSerializationException, Message="Self referencing...
asked by Hitesh
Entity Framework Paging
In Entity Framework, using LINQ to Entities, database paging is usually done in following manner:...int totalRecords = EntityContext.Context.UserSet.Count; var list = EntityContext.Context.UserSet .Skip(startingRecordNumber) ...
asked by dev
LINQ query or GetObjectKey to get single Entity Framework entities?
It looks like GetObjectKey has the benefit of searching for existing, instantiated objects, and THEN the data store. However, it also seems like you lose some of the strong typing, and need to cast your resulting object:...GetObjectKey...int customerID =...
asked by John Bubriski
Entity Framework code with custom property characteristics
Is there any way to add custom attributes to properties in EF generated code? The only thing I can see as a plausible solution would be to come up with a custom T4 template. However, because of the nature of the attribute it would be impossible to deter...
asked by AKoran
How do I utilize Entity Framework transactions?
When you have code like this:...Something something = new Something(); BlahEntities b = new BlahEntities() b.AddToSomethingSet(something); b.SaveChanges(); ...how do run that addition inside a transaction?
asked by pupeno
