Q:

Is it possible to select data with a function call using EF Code First and an Oracle Database?

I'm using EF Code First on an Oracle Database. Given a table like this
public class Entity
{
    public int Id { get; set; }
}

is it possible to construct a where clause that contains a call to a function?
e.g
MyDatabase database = new MyDatabase();

var results = database.Entity.Where(c => c.Id < 1000 
                            && "Schema.Package.Function(" + c.Id + "));

A:

You can use SqlQuery method
var results = database.Entity
  .SqlQuery("select c.* from Entity c where c.Id < 1000 and Schema.Package.Function(c.Id)");

