public async Task <IEnumerable <Person> > TestScalarFunction(int id)
{
try
{
using (var db = new AdventureWorks2016CTP3Context())
{
//select
// p.BusinessEntityID,
// p.FirstName,
// p.LastName,
// p.ModifiedDate as PersonModifiedDate,
// a.AddressLine1,
// [dbo].[fn_AddDayPeriod](a.ModifiedDate, 100, 'DayPeriod_day') as ThresholdDate
//from[Person].[Person] p
//join[Person].[BusinessEntityAddress] bea on p.BusinessEntityID = bea.BusinessEntityID
//join[Person].[Address] a on bea.AddressID = a.AddressID
//where p.ModifiedDate > [dbo].[fn_AddDayPeriod] (a.ModifiedDate, 100, 'DayPeriod_day')
var persons = await
(from p in db.Person.AsNoTracking()
join bea in db.BusinessEntityAddress on p.BusinessEntityId equals bea.BusinessEntityId
join a in db.Address on bea.AddressId equals a.AddressId
where p.ModifiedDate > AdventureWorks2016CTP3ContextFunctions.AddDayPeriod(a.ModifiedDate, 100, "DayPeriod_day")
select p).ToListAsync();
//var persons = await db.Person.AsNoTracking().Where(x => x.BusinessEntityId < 10).ToListAsync();
return(persons);
}
}
catch (Exception ex)
{
throw new Exception("Ошибка: " + ex.Message, ex);
}
}
public SalesOrdersController(Context.AdventureWorks2016CTP3Context context)
{
_context = context;
}