public List <Measure> Get(MeasureSearchCriteria criteria)
{
var endDate = criteria.EndDate.AddDays(1);
using (var context = new PowerUnitContext())
{
// składnia za pomocą wyrażeń lambda
var measures = context.Measures
.Where(x => x.MeasureDate >= criteria.StartDate)
.Where(measure => measure.MeasureDate < endDate)
.OrderBy(measure => measure.MeasureDate)
.ToList();
// składnia podobna do SQL
//var measures = (
// from measure in context.Measures
// where measure.MeasureDate >= criteria.StartDate
// && measure.MeasureDate < endDate
// orderby measure.MeasureDate
// select measure
// )
// .ToList();
return(measures);
}
}
public void Add(ThreePhaseMeasure measure)
{
using (var context = new PowerUnitContext())
{
context.ThreePhaseMeasures.Add(measure);
context.SaveChanges();
}
}
public void Add(Measure measure)
{
// Utworzenie instancji kontekstu
using (var context = new PowerUnitContext())
{
// Dodanie do kontekstu
context.Measures.Add(measure);
// Zapis do bazy danych
context.SaveChanges();
}
}