Entity Framework 6 - Knowledge Base (KB)
6940 results
Entity Framework error - "The EntityContainer name must be unique"
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
Problem with LINQ to Entities and String.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
ADO.NET Entity Framework SaveChanges() does not work
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
How do I run a stored procedure in ADO.NET Entity Framework?
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
InvalidOperationException when calling SaveChanges in .NET Entity framework
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
In Entity Framework, how can I create a referrential constraint using a subset of the primary key?
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
EF Distinct (IEqualityComparer) Error
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
Entity Framework EntityKey / Foreign Key problem
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.
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...
asked by Sergio Romero
Entity framework - "Problem in mapping fragments"-error. Help me understand the explanations of this error
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
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.
asked by Diego
How to use a stored procedure in ADO.NET Entity Framework
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 not loading automatically
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 Operator in Entity Framework?
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
Using a stored procedure in entity framework, how do I get the entity to have its navigation properties populated?
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
Serialize Entity Framework Object using Json.Net
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
Paging in Entity Framework
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
Retrieve single Entity Framework entities using a LINQ query or GetObjectKey?
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
Adding custom property attributes in Entity Framework code
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 to use transactions with the Entity Framework?
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
Page 8 of 347
