Entity Framework 6 - Knowledge Base (KB)
6940 results
Entity Framework,.NET, and Domain Driven Design
I'm new to domain driven design but want to learn it and use it for a new application. I will be using Entity Framework for data access....The basic layout so far is:...ASP.NET MVC and other clients (mobile devices etc.)... |... Webservices... |..
asked by Christian V
The number of members in the conceptual type does not correspond to the number of members in the object type.
I'm using .net framework 3.5 SP1....After adding a column to one table in Sql Server (as well as changing an existing column from allowing nulls to not nullable), I can no longer run my project without getting this error:...The number of members in the ...
asked by TG.
Setting the update timestamp in Entity Framework
All of our database tables have UpdateUserID and UpdateTS. I'd like to have this set if my entity has changes. Is there a way I can have this update on the spot conditionally? ...If I manually set UpdateTS in code, then it will say that my entity has c...
asked by RailRhoad
In Entity Framework, how do you get rid of a circular reference?
The circular reference between my Customer and Order entities caused a exception during serialization. Is there any way to force EF to generate one-direction reference between these two entities? Thanks in advance!
asked by Roy
Because there are other threads active in the session, a new transaction is not authorized. SqlException from Entity Framework
I am currently getting this error:...System.Data.SqlClient.SqlException: New transaction is not allowed because there are other threads running in the session....while running this code:...public class ProductManager : IProductManager { #region Declar...
asked by Keith Barrows
In entity framework, how to make a string the main key!
I have a legacy table containing employee name and employee id. Now the employee id is in char because it can hold values starting with an alphabet. Employee id is the only unique field available in the table....Now I am using a view to capture the data f...
asked by Arup Chaudhury
EF select: Return Tuple
How can I retrieve Tuples at Select using EF4?... var productCount = (from product in context.products select new Tuple<Product, int>(product, products.Orders.Count)); ...Or... var productCount = (from product in context....
asked by Felipe Fujiy Pessoto
Using the NOLOCK Hint feature in EF4?
We're evaluating EF4 and my DBA says we must use the NOLOCK hint in all our SELECT statements. So I'm looking into how to make this happen when using EF4....I've read the different ideas on how to make this happen in EF4, but all seem like a work around ...
asked by John
Entity Framework - Checking for single records before utilizing them the right manner
To get a LIST of records I normally do something along the lines of:...var efCompany = from a in _dbRiv.Company where a.CompanyId == companyFeedInfo.CompanyId select a; ...To get a single record, when I know I am using the PK to retrieve it, I use somethi...
asked by Keith Barrows
The underlying provider failed on ConnectionString in Entity Framework.
While using the Entity Framework I have split it out to it's own project:...RivWorks.Model - Contains Entity Model...RivWorks.Controller - Uses the Entity Model and contains the biz rules...RivWorks.View.Web - The web site...RivWorks.View.Services - WCF p...
asked by Keith Barrows
Handling entity changes with Entity Framework and AutoMapper
I just started using the Entity Framework 1.0 recently and believe I am beginning to feel the pains everyone is talking about. I'm trying to use best practices so I have a set of DTO that get mapped to and from my Entities via AutoMapper....The real catch...
asked by jason
The exception is the foreign key.
Here is the inner exception: ...InnerException: System.Data.UpdateException Message=Entities in 'OrganizerDBEntities.Assignments' participate in the 'CourseId' relationship. 0 related 'Course' were found. 1 'Course' is expected.` ...I have three tabl...
asked by Mohit Deshpande
In the Entity Framework, how do you construct a connection between a table and a view?
I have an Entity Framework model that was generated by the Visual Studio 2008 wizard based on a Sql Server 2008 database. ...The model has a view that logically is joined in a many-to-many relationship with another table through a join table (enforced in...
asked by Sako73
Entity Framework data cloning
I am creating software where user can create new product based on older product....Now I need to make copying / cloning operations with Entity Framework. First I started writing like this:...foreach(sourcedata1 in table1) { ... create new table ... ...
asked by Tx3
Update Model From Database... in Entity Framework - no update!
I have a table in my DB called ...CompanyDetails.... It has a column called ...CharacterID varchar(255).... I just changed it from a ...NOT NULL... column to a ...NULL... column. I ran the 'Update Model From Database...' command in the model browser as...
asked by Keith Barrows
When re-adding tables to entity-model, they don't appear (edmx)
I have a db with 5 tables. At the beginning, I've added those tables in, but then decided to remove some due to some relationship compile error....Now, when i want to add them back, i'm opening the edmx file -> update model from database... I don't see th...
asked by Or A
ObjectContext.ExecuteStoreQuery in Entity Framework creates disconnected objects.
I need to run some custom SQL to return a list of objects from a table. I'm using ExecuteStoreQuery for that....var q = context.ExecuteStoreQuery<ProductionUnit>(MySelectString, new SqlParameter("@ProductionUnitId", value)); ...This does result in q conta...
asked by neaorin
After deployment, the Entity Framework connection to the SQLite database is not functioning.
I changed a dataset based approach to my sqlite database to one using the Entity Framework. I created the entities using Visual studio 2008's wizard and had the connection string stored in the app.config. A client program then communicates through WCF wit...
asked by Dabblernl
Is EntityFramework compatible with an Access 2007 database (.accdb)?
I'm trying to create an MVC application that uses an Access 2007 DB (.accdb). I can create the Model using DataSet. But if I try to create a Model using EntityFramework, I can't get past VS2008 wanting to make the connection string be a SQL server. Am ...
asked by Dale
With an SSAS Cube and Entity Framework
Is it possible to use Entity Framework (any version, including, and preferably 4.0) to query an SSAS cube (preferably SSAS 2008)?
asked by CodeMonkey1313
Page 16 of 347
