DataSet or Entity Framework 4?

Entity Framework, DataSet, or Custom Classes: Which Should I Use?

I would agree with Marc G. 100% - DataSets suck, especially in a WCF scenario (they add a lot of overhead for handling in-memory data manipulation) - don't use those. They're okay for beginners and two-tier desktop apps on a small scale maybe - but I wouldn't use them in a serious, professional app....Basically, your question boils down to how do y...

Context to populate a DataSet - Entity Framework 4

This method will convert a list of objects to a datatable. It was given as an answer to ...this question..../// <summary> /// Create data table from list. /// https://stackoverflow.com/questions/18746064/using-reflection-to-create-a-datatable-from-a-class /// </summary> public static DataTable CreateDataTable<T>(IEnumerable<T> list) { Type type...

When using Entity Framework and LINQ to query huge databases, how can you prevent memory overflow?

The correct way to work with large datasets in Entity framework is:...Use EFv4 and POCO objects - it will allow sharing objects with upper layer without introducing dependency on Entity framework...Turn off proxy creation / lazy loading to fully detach POCO entity from object context...Expose ...IQueryable<EntityType>... to allow upper layer to spe...

Return ListDataTable> or DataSet from an Entity Framework stored method.

How do I modify the below method to return a List< DataTable> or a DataSet? I want to make it generic so it can return multiple resultsets from the database....public static DataTable ExecuteStoredProcedure(ObjectContext db, string storedProcedureName, IEnumerable<SqlParameter> parameters) { var entityConnection = (EntityConnection) db....

Dataset vs Entity Framework with stored procedures

This is for responding to Jonathan's answer about DataSet. Because a comment allows too short content, therefore I put it as an answer....This is old but till now, with EF6 and EF dotnet core , I see that it's still valid to argue this point....I'm finding opinions about this topic and eventually reached this post. Honestly, I quite disagree with J...

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

I am using Entity Framework 6 and I am using EntityFramework Extended to perform some batch updates and batch deletes. The batch updates and batch deletes work OK however I also need to know the entities that were updated / deleted (i.e. the current and previous values). I thought that using the AuditLogger provided by EntityFramework.Extended wo...

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

Just to complement, i've tried everything but in my case it was solved by setting the "...defaultConnectionFactory...", like this:...<entityFramework> <defaultConnectionFactory type="Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory, Oracle.ManagedDataAccess.EntityFramework"> </defaultConnectionFactory> <providers> <provider invari...

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

PROBLEM: I had a website that was working with my local dev machine (VS2013, EF6.1.3, SQl Server CE 4.0, EF Tools installed). I maintain the website using a git repo locally and in VS OnLine....I am at a different (temporary) location with a new machine. I fetched the website from my git repo down to this new machine. All seemed to work OK (coul...

ADO.NET Entity Framework - Oracle with Entity Framework 6

I'm trying to add an ADO.NET Entity Data Model to my solution which uses an Oracle database (ODP.NET), but I get the following error:..."Your project references the latest version of Entity Framework; however, an Entity Framework database provider compatible with this version could not be found for your data connection. If you have already i...

Entity Framework dataset mapping

All of my DAL functions are using ...dbContext.Database.SqlQuery... to map stored procedure results in business logic objects. ...My application became more complicated and I'm looking for a modern, "up to date" way to handle the following situations. I know that I can achieve this using the low-level ADO.NET component like ...SqlDataReader... and ...