What is the difference between SqlFunctions and EntityFunctions?

c# entity-framework

Question

What's the difference ? Are both used to perform functions in sql side before get data and store them in memory ?

P.S:
Both used in linq to entites.

1
19
3/26/2013 12:49:16 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

As the documentation states EntityFunctions

Provides common language runtime (CLR) methods that expose conceptual model canonical functions in LINQ to Entities queries. For information about canonical functions, see Canonical Functions (Entity SQL).

where Canonical functions

are supported by all data providers, and can be used by all querying technologies. Canonical functions cannot be extended by a provider. These canonical functions will be translated to the corresponding data source functionality for the provider. This allows for function invocations expressed in a common form across data sources.

Whereas SQLFunctions

Provides common language runtime (CLR) methods that call functions in the database in LINQ to Entities queries.

Therefore although both sets of functions are translated into native SQL, SQLFunctions are SQL Server specific, whereas EntityFunctions aren't.

16
3/26/2013 12:50:10 PM

Popular Answer

As i read about it. The CLR convert EntityFunctions functions to "canonical functions" which are supported by all data providers.

But the SqlFunctions make the SQL Server to do the work and they specified just for SQL Server.

For more information

Wahid Bitar

Related Questions

Am I crazy for using Entity Framework with an OleDB connection?

I'm experimenting with the Entity Framework and I want to connect to an Access 2007 database....The following code is inspired by ...http://msdn.microsoft.com/en-us/library/system.data.entityclient.entityconnection.connectionstring.aspx...I suspect that I've got the wrong end of the stick......OleDbConnectionStringBuilder oledbConn = new OleDbConne...
c# entity-framework ms-access
asked by fran

What am I doing wrong with MySQL and Entity Framework?

I got past this error by adding a reference to MySql.Data.Entity.dll (and MySql.Web.dll)
.net entity-framework mysql nullreferenceexception visual-studio-2010
asked by Rami A.

In System.Data.Entity.dll (Entity Framework), why am I receiving a NullReferenceException?

I have a ...List<State>... of ...State... entity objects, and each ...State... object has collections of other objects, such as ...Licenses..., ...Taxes..., ...Bonds..., etc...There's also a collection for ...ExpiredObjects..., which is a list of any object which is expired and needs to be renewed. For some reason, this property is giving me a ...N...
c# entity-framework wpf
asked by Rachel

Why am I getting this "Invalid object name 'dbo.*'" error with MVC4?

I experienced this problem and found a solution, which requires that the User Schema in SQL is that of the dbo schema thus the tables are created with dbo. at the beginning of them, problem solved. ...I am presuming this is a bug that will need fixed by MS.
asp.net-mvc-4 entity-framework visual-studio-2012
asked by Gareth Bow

LINQ + EntityFunctions in asp.net mvc

I have such code using EntityFramework Alpha3 (from nuget): ...class Member { [Key] public int Key { get; set; } public string Forename { get; set; } public string Surname { get; set; } public string Sitename { get; set; } public DateTime? RegDate { get; set; } } class MembersContext : DbContext { public MembersContext(...
asp.net-mvc-4 c# entity-framework
asked by Michal Dymel

Error on Cout but i am not using Count in my LINQ exrpression,

I am trying to return a set of data in JSON formate from a LINQ select ran against my EF Code First DB and am getting the error...Count must be a DbConstantExpression or a DbParameterReferenceExpression. Parameter name: count ...but I am not sure why I am getting it as I am not using a ...COUNT... parameter in my LINQ query so why am I getting this...
asp.net-mvc-5 c# entity-framework-6 linq-to-entities
asked by Matthew Verstraete

AspNet.Identity Custom User and Custom Role should be simple; what am I missing?

Try this way. I had the same issue, you need to provide the id. ... // // POST: /Account/Register [HttpPost] [AllowAnonymous] [ValidateAntiForgeryToken] public async Task<ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser() { ...
asp.net-identity asp.net-mvc asp.net-mvc-5 entity-framework entity-framework-6
asked by Peter Hurtony

Entity Framework 6 SqlFunctions DateDiff not implemented in nuget package

I was looking in the wrong place. The correct function was in System.Data.Entity.SqlServer.SqlFunctions. The correct query turned out to be ...RepositoryFactory.CreateReadOnly<MyEntity>() .Where(at => at.AccessedDate.HasValue && at.CreatedDate >= startDate && at.CreatedDate <= endDate && SqlFunctions.DateDiff("ss", at.CreatedD...
.net c# entity entity-framework linq
asked by Frank M

I am trying to return XML data from Entity Framework

You can use that:... using (SqlConnection con = new SqlConnection(_dbContext.Database.Connection.ConnectionString)) { #region Connection Open SqlCommand cmd = new SqlCommand("mbl_GetCourseMat", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Par1...
c# entity-framework-6 xml
asked by Ergin Çelik

How can I extract DbFunctions/SqlFunctions call into a resuable extension/method with EntityFramework 6.2?

Remove the parameter from your method and make the expression accept two parameters:...public static Expression<Func<MyModel, DateTime, bool>> IsDateOf = (MyModel p, DateTime d) => p.StartedAt.AddSeconds(p.UtcOffset) == d.Date; ...Note I have made it a static field, not a method. Then in your LINQ expression, you need to invoke it:...MyModel....
asp.net-mvc c# entity-framework entity-framework-6 linq
asked by Amy

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow