entity-framework Archives - Page 5 of 7

Using Transactions or SaveChanges(false) and AcceptAllChanges()?

I have been investigating transactions and it appears that they take care of themselves in EF as long as I pass false to ...

May 11, 2022
0 Comments

Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?

I’ve been wrestling with this for a while and can’t quite figure out what’s happening. I have a Card entity which contains Sides ...

May 10, 2022
0 Comments

Entity Framework Timeouts

I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to complete. I tried ...

May 10, 2022
0 Comments

How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?

Is there a way to compare two DateTime variables in Linq2Sql but to disregard the Time part. The app stores items in the ...

May 10, 2022
0 Comments

Error message ‘Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.’

I have developed an application using Entity Framework, SQL Server 2000, Visual Studio 2008 and Enterprise Library. It works absolutely fine locally, but when I ...

May 9, 2022
0 Comments

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

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

May 9, 2022
0 Comments

The entity cannot be constructed in a LINQ to Entities query

There is an entity type called Product that is generated by entity framework. I have written this query public IQueryable<Product> GetProducts(int categoryID) { ...

May 8, 2022
0 Comments

Why use ICollection and not IEnumerable or List on many-many/one-many relationships?

I see this a lot in tutorials, with navigation properties as ICollection<T>. Is this a mandatory requirement for Entity Framework? Can I use ...

May 7, 2022
0 Comments

Conversion of a datetime2 data type to a datetime data type results out-of-range value

I’ve got a datatable with 5 columns, where a row is being filled with data then saved to the database via a transaction. ...

May 7, 2022
0 Comments

One DbContext per web request… why?

I have been reading a lot of articles explaining how to set up Entity Framework’s DbContext so that only one is created and ...

May 6, 2022
0 Comments