Entity Framework 6 - Knowledge Base (KB)
55 results in tag: performance
Linq To Sql vs Entity Framework Performance
I have been searching for recent performance benchmarks that compare L2S and EF and couldnt find any that tested calling stored procedures using the released version of EF. So, I ran some of my own tests and found some interesting results....Do these resu...
asked by Vyrotek
How to optimize Entity Framework Queries
I am using Linq-To-Entities to do a query which is returning only 947 rows but taking 18 seconds to run. I have done a "ToTraceString" to get the underlying sql out and ran the same thing directly on the database and get the same timing. ...I have used th...
asked by Calanus
How to write an entity comparator in C# (with example code of first attempt)
Possible Duplicate:...What is the best way to compare two entity framework entities?...I want to know the most efficient way of comparing two entities of the same type....One entity is created from an xml file by hand ( ie new instance and manually set pr...
asked by James
When should I call SaveChanges() when creating 1000's of Entity Framework objects? (like during an import)
I am running an import that will have 1000's of records on each run. Just looking for some confirmation on my assumptions:...Which of these makes the most sense:...Run ...SaveChanges()... every ...AddToClassName()... call....Run ...SaveChanges()... every...
asked by John Bubriski
Entity Framework 4 : Bad performance with SQL Server 2008
I'am developing a software based on Entity Framework to handle data in a MS SQL Server 2008 database....[Trouble 1]...I've just tried to insert some small data (...about 2 Mb...) from my progam to the database : the performance are very bad ! It takes ...
asked by Patrice Pezillier
Entity Framework - First query slow
As the title suggest I'm having a problem with the first query against a SQL Server database using Entity Framework....I have tried looking for an answer on different sites but no one seems to actually have a solution to this....I'm loading quite a lot of...
asked by Kenneth Lauritsen
How do I speed up DbSet.Add()?
I have to import about 30k rows from a CSV file to my SQL database, this sadly takes 20 minutes....Troubleshooting with a profiler shows me that ...DbSet.Add is taking the most time, but why?...I have these Entity Framework Code-First classes:...public cl...
asked by Tamara Wijsman
Optimizing LINQ Any() call in Entity Framework
After profiling my Entity Framework 4.0 based database layer I have found the major performance sinner to be a simple LINQ Any() I use to check if an entity is already existing in the database. The Any() check performs orders of magnitude slower than savi...
asked by Holstebroe
ASP.NET MVC and EF Code First Memory Usage
I have an application built in ASP.NET MVC 3 that uses SQL CE for storage and EF CTP 5 for data access....I've deployed this site to a shared host only to find that it is constantly being recycled as it's hitting the 100mb limit they set on their (dedicat...
asked by Ben Foster
How many Include I can use on ObjectSet in EntityFramework to retain performance?
I am using the following LINQ query for my profile page:...var userData = from u in db.Users .Include("UserSkills.Skill") .Include("UserIdeas.IdeaThings") .Include("UserInterests.Inte...
asked by teenup
Entity framework uses a lot of memory
Here is a image from the ANTS memory profiler. It seens that there are a lot of objects hold in memory. How can I find what I am doing wrong?...**UPDATE** ...Here is my repository classes:...public class Repository<T> : IRepository<T> where T : class, IDa...
asked by Naor
Debugging Entity Framework SQL statements
I am having a weird pattern of response time when using the Entity Framework for SQL communication....This is from my web host:...This is from my local server: ...It's the increase in response time I am worried about. I have narrowed the problem down to o...
asked by Anders
Entity Framework is Too Slow. What are my options?
I have followed the "Don't Optimize Prematurely" mantra and coded up my WCF Service using Entity Framework....However, I profiled the performance and Entity Framework is too slow. (My app processes 2 messages in about 1.2 seconds, where the (legacy) app ...
asked by Vaccano
Multi-tenant SQL Server databases and parameter sniffing
I have a multi-tenant database in SQL Server 2012 where each tenant's rows are identified by a ...tenant_id... column (aka the ...Shared Database, Shared Schema... approach). Some tenants, particularly the newer ones, have very few rows, while others have...
asked by Mike
What's the best architecture for a medium-sized, high traffic web site?
I'm starting a new project (non-corporative) and I want to know how would be a great architecture nowadays....What I'm planning for now is to use: ...ASP.NET MVC 4.0...SQL Server 2008 or 2012...EF 5.0 under .NET 4.5, with Dapper...Implementation of Reposi...
asked by eduardobr
Seemingly simple query being very slow on Entity Framework
So I have a very basic Data Model in my project (targeting .NET 4.0, using EF 5 installed by NuGet, database first), with 2 tables, Item and ItemGroup....Item-table has various fields, both string and numerical, and a foreign key pointing to an ItemGroup....
asked by bobblez
LINQ to Entities -- OrderBy().ToLisT() vs. ToList().OrderBy()
I'm looking for confirmation/clarification with these LINQ expressions:...var context = new SomeCustomDbContext() // LINQ to Entities? var items = context.CustomItems.OrderBy(i => i.Property).ToList(); // LINQ to Objects? var items2 = context.CustomIte...
asked by one.beat.consumer
Performance analyze ADO.NET and Entity Framework
Which one gives better performance? ADO.NET or Entity Framework....These are the two method I want to analyze....ADO.NET Test Method...public void ADOTest() { Stopwatch stopwatch = Stopwatch.StartNew(); using (SqlConnection con = new SqlConnection...
asked by Niventh
Performance of Linq on entity framework vs SQL stored procedure
We are using the Entity Framework to fetch some data. The LINQ query is using multiple joins, as shown in the code below. I have been asked to change this to a SQL Stored Procedure because its faster. How can i optimize this LINQ code and why is it slow?....
asked by V.K.
Entity Framework performance after SqlBulkCopy
I need some performance for doing some of my things. I'm trying to import excel data to my SQL Server database here is my code for doing that work but it really takes too much time for that. Could you give me some advice for that... [WebMethod] publ...
asked by cooolstaff
Page 1 of 3
