Entity Framework 6 - Knowledge Base (KB)
55 results in tag: performance
Performance of Linq To SQL versus Entity Framework
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 Make Entity Framework Queries Faster
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
In C#, how do you construct an entity comparator? (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 generating 1000s of Entity Framework instances, when should I use SaveChanges()? (For example, 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
SQL Server 2008 Performance Issues with Entity Framework 4
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 - Slow first query
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 can I make DbSet.Add() faster?
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
LINQ Optimization Entity Framework's Any() method
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
Code First Memory Usage in ASP.NET MVC and EF
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 much Include in EntityFramework can I use on an ObjectSet to maintain 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 consumes a significant amount 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 SQL statements in Entity Framework
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 inefficient. What are my alternatives?
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
Which architecture is better for a medium-sized, high-traffic website?
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
