esql

Entity SQL Using Imported Function

Hi I am trying to use a stored procedure as an imported function in an entity sql statement See my statement below, but this does not seem to work and I'm having a hard time finding out how imported functions are used in Entity SQL SELECT Cp.Calendar_Reference FROM Model.Calendar("CY", DATETIME'1999-01-01 00:0:00', DATETIME'2009-01-0...

Dynamically sorting and filtering projected Entity SQL results

I have the following query which I want to sort or filter using projected class names: List<CompanyInfo> list = new List<CompanyInfo>(); using (var db = new DbContext()) { list.AddRange( db.Companies.Include("Projects") .Select(row => new CompanyInfo() { Pr...