Linq to Entities vs. Linq to SQL vs. Entity Framework

LINQ to SQL vs. Entity Framework

LINQ to SQL only supports 1 to 1 mapping of database tables, views, sprocs and functions available in Microsoft SQL Server. It's a great API to use for quick data access construction to relatively well designed SQL Server databases. LINQ2SQL was first released with C# 3.0 and .Net Framework 3.5....LINQ to Entities (ADO.Net Entity Framework) is an...

Performance of Linq To SQL versus Entity Framework

This looks to be a pretty measurement of performance between LINQ to SQL and Entity Framework....http://toomanylayers.blogspot.com/2009/01/entity-framework-and-linq-to-sql.html

What's the difference between Entity Framework, LINQ to SQL, and ADO.NET with stored procedures?

First off, if you're starting a new project, go with Entity Framework ("EF") - it now generates much better SQL (more like Linq to SQL does) and is easier to maintain and more powerful than Linq to SQL ("L2S"). As of the release of .NET 4.0, I consider Linq to SQL to be an obsolete technology. MS has been very open about not continuing L2S develo...

Linq To Entities - Any VS First VS Exists

Okay, I wasn't going to weigh in on this, but Diego's answer complicates things enough that I think some additional explanation is in order....In most cases, ....Any()... will be faster.... Here are some examples....Workflows.Where(w => w.Activities.Any()) Workflows.Where(w => w.Activities.Any(a => a.Title == "xyz")) ...In the above two examples, E...

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?...var brands = (from b in entity.tblBrands join m in entity.tblMateri...

Entity Framework - CreateQuery VS ExecuteFunction VS ExecuteStoreQuery VS ExecuteStoreCommand

What are the differences between following-...CreateQuery()  ExecuteFunction(), ExecuteStoreQuery() and ExecuteStoreCommand() ...As per my knowledge CreateQuery is used for Entity SQL & rest of the methods are used for sql function or stored procedure defined in DB....As per ObjectContext class meta data they are as follow:...CreateQuery():Create...

Entity Framework SaveChanges() vs. SaveChangesAsync() and Find() vs. FindAsync()

Any time that you need to do an action on a remote server, your program generates the request, sends it, then waits for a response. I will use ...SaveChanges()... and ...SaveChangesAsync()... as an example but the same applies to ...Find()... and ...FindAsync().......Say you have a list ...myList... of 100+ items that you need to add to your databa...

Entity Framework 6 vs Entity Framework Core Raw Sql

Entity Framework 6 example writing SQL queries for non-entity types:...context.Database.SqlQuery<string>(" ; with tempSet as " + "(select " + ...In Entity Framework 6, I can also write the following query with ...SqlQuery.... How can I run the following query with Entity Framework Core?...; with tempSet as ( ...

Math.Round in linq to entities vs linq to objects

The behavior of the following are different and it's hard to manage, depending on if the query was executed or not:...using (var db = new DbContext()) { db.Entities.Select(x => Math.Round(0.5)).First(); // return 1 db.Entities.ToList().Select(x => Math.Round(0.5)).First(); // returns 0 db.Entities.AsEnumerable().Select(x => Math.Round(...

In SQL Server, Entity Framework 6 vs. Dapper vs. stored procedures vs. requests

I have EF with LINQ with SQL Server in my project a long time....And I was searching for a way to improve a performance of my requests to DB. And I read a lot of about Dapper and Procedures, that it's faster than EF. I added Dapper to project, I added procedure.... but my tests showed strange results. EF and Dapper and stored procedures have almost...