Entity Framework 6 Code First Custom Functions

by

You should be able to use a scalar SQL function in your Where criterias with CodeFirstStoreFunctions

Assuming you want to map SQL function [dbo].[LatLongDistanceCalc], and according to the test suite:

public class MyDataContext: DbContext
{
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
       //...

       modelBuilder.Conventions.Add(new FunctionsConvention("dbo", this.GetType()));
    }

    // "CodeFirstDatabaseSchema" is a convention mandatory schema name
    // "LatLongDistanceCalc" is the name of your function

    [DbFunction("CodeFirstDatabaseSchema", "LatLongDistanceCalc")]
    public static int LatLongDistanceCalc(int fromLat, int fromLong,
                                                       int toLat, int toLong)
    {
       // no need to provide an implementation
       throw new NotSupportedException();
    }
}

usage would then be:

context.Locations
       .Where(e => MyDataContext.LatLongDistanceCalc(e.Lat, e.Long, lat, long) >= 10)

More Related Contents:

  1. Log Queries executed by Entity Framework DbContext
  2. How to group by DateTime.Date in EntityFramework
  3. ‘Contains()’ workaround using Linq to Entities?
  4. Entity Framework Provider type could not be loaded?
  5. How to update record using Entity Framework 6?
  6. How to use a string to create a EF order by expression?
  7. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  8. LEFT JOIN in LINQ to entities?
  9. Mapping composite keys using EF code first
  10. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  11. Lazy Loading vs Eager Loading
  12. How to compare only date components from DateTime in EF?
  13. Dynamic MySQL database connection for Entity Framework 6
  14. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  15. Order by dynamic parameter
  16. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  17. Problems using Entity Framework 6 and SQLite
  18. Dynamic table name in linq [duplicate]
  19. Linq Syntax – Selecting multiple columns
  20. Configure multiple database Entity Framework 6
  21. Join and Include in Entity Framework
  22. Entity Framework 6 transaction rollback
  23. Creating dynamic queries with entity framework
  24. Remove item from list based on condition
  25. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  26. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  27. How to include() nested child entity in linq
  28. How to use String property as primary key in Entity Framework
  29. LINQ Query to Convert string to datetime
  30. Entity Framework select one of each group by date

Leave a Comment