internal FluentQueryBuilderWithLimiter(IStorageReader <TDataModel> storage,
DataFilter <TDataModel> filter,
DataLimiter <TDataModel> limiter,
DataProjection <TDataModel, TGroup, TSelect> projection)
: base(storage, filter, limiter, projection.GetDataIncludes())
{
_projection = projection;
}
internal FluentQueryBuilderWithProjection(IStorageReader <TDataModel> storage,
DataFilter <TDataModel> filter,
DataLimiter <TDataModel> limiter,
DataIncludes <TDataModel> includes,
Expression <Func <TDataModel, TSelect> > select)
: base(storage, filter, limiter, includes)
{
_projection = new DataProjection <TDataModel, TSelect>(includes._includes, select);
}
public IActionResult Index()
{
var lazyStore = _studentStoreLoader.Value;
var logs = _bulkCreatableStorage.BulkCreate(new[]
{
new Log {
Date = DateTime.Now, Message = "Entrou na home 1"
},
new Log {
Date = DateTime.Now, Message = "Entrou na home 2"
}
});
// Equivalentes para GetAll() com GroupBy()
var projection = new DataProjection <Student, int, object>(
s => s.EnrollmentDate.Year,
g => new
{
Ano = g.Key,
Total = g.Count(),
MaiorData = g.Max(c => c.EnrollmentDate),
MenorData = g.Min(c => c.EnrollmentDate)
});
var result = lazyStore.GetAll(projection);
var resultList = result.ToList();
var result2 = lazyStore.AsFluentQuery()
.Projection()
.GroupAndMap(s => s.EnrollmentDate.Year, g => new
{
Ano = g.Key,
Total = g.Count(),
MaiorData = g.Max(c => c.EnrollmentDate),
MenorData = g.Min(c => c.EnrollmentDate)
})
.Project()
.GetAll();
var resultList2 = result2.ToList();
// Equivalentes para GetAll()
var a1 = lazyStore.GetAll();
var a2 = lazyStore.GetAll(new DataIncludes <Student>());
var a3 = lazyStore.AsFluentQuery().GetAll();
// Equivalentes para GetAll() com Include() e Select()
var a4Projection = new DataProjection <Student, object>(s => new
{
StudentName = s.FirstMidName
});
var a4 = lazyStore.GetAll(a4Projection);
var a5 = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Project()
.GetAll();
var a6 = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Map(m => new
{
StudentName = m.FirstMidName,
TotalEnrollments = m.Enrollments.Count
})
.Project()
.GetAll();
// Equivalentes para Find()
var b1 = lazyStore.Find(2, new DataIncludes <Student>());
var b2 = lazyStore.Find(2, null);
var b3 = lazyStore.Find(2);
var b4 = lazyStore.AsFluentQuery().Find(2);
var bb01 = _findableStorage.Find(2, new DataIncludes <Student>());
var bb02 = _findableStorage.Find(2, null);
var bb03 = _findableStorage.Find(2);
var bb04 = _findableStorage.Find(new object[] { 2 });
var bb05 = _findableStorage.Find(new Student {
ID = 2
});
var bb11 = _findableStorage2.Find(2, new DataIncludes <Student>());
var bb12 = _findableStorage2.Find(2, null);
var bb13 = _findableStorage2.Find(2);
var bb14 = _findableStorage2.Find(new object[] { 2 });
var bb15 = _findableStorage2.Find(new Student {
ID = 2
});
// Equivalentes para Find() com Include() e Select()
var c1 = _enrollmentStore.AsFluentQuery()
.Projection()
.Include(i => i.Student)
.Include(i => i.Course)
.Project()
.Find(2);
var c2 = _enrollmentStore.AsFluentQuery()
.Projection()
.Include(i => i.Student)
.Include(i => i.Course)
.Map(m => new
{
Student = m.Student.FirstMidName,
Course = m.Course.Title
})
.Project()
.Find(2);
// Equivalentes para Find() com Include() e ThenInclude()
var d1 = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Project()
.Find(2);
var d2 = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Map(m => new
{
StudentName = m.FirstMidName,
TotalEnrollments = m.Enrollments.Count,
Enrollments = m.Enrollments.Select(s => new
{
Grade = s.Grade,
Course = s.Course.Title
})
})
.Project()
.Find(2);
// Search
var e0_filter = new DataFilter <Student>();
e0_filter.AddFilter(w => w.FirstMidName.Contains("e"));
var e0_1 = _searchableStorage.Search(e0_filter);
var e0_2 = _searchableStorage2.Search(e0_filter);
// Equivalentes para Search() com Include() e ThenInclude()
var e1 = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Project()
.Filter(w => w.FirstMidName.Contains("e"))
.Search()
.ToList();
var e2 = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Map(m => new
{
StudentName = m.FirstMidName,
TotalEnrollments = m.Enrollments.Count,
Enrollments = m.Enrollments.Select(s => new
{
Grade = s.Grade,
Course = s.Course.Title
})
})
.Project()
.Filter(w => w.FirstMidName.Contains("e"))
.Search()
.ToList();
// Equivalentes para Search() com Include() e ThenInclude()
var f1_a = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Project()
.Sort(s => s.FirstMidName)
.LimitedGet();
var f2_a = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Map(m => new
{
StudentName = m.FirstMidName,
TotalEnrollments = m.Enrollments.Count,
Enrollments = m.Enrollments.Select(s => new
{
Grade = s.Grade,
Course = s.Course.Title
})
})
.Project()
.SortDescending(s => s.FirstMidName)
.LimitedGet();
var f1_b = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Project()
.OffsetBegin(3)
.LimitedGet();
var f2_b = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Map(m => new
{
StudentName = m.FirstMidName,
TotalEnrollments = m.Enrollments.Count,
Enrollments = m.Enrollments.Select(s => new
{
Grade = s.Grade,
Course = s.Course.Title
})
})
.Project()
.OffsetLimit(3)
.LimitedGet();
var f1_c = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Project()
.Paginate(1, 3)
.LimitedGet();
var f2_c = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Map(m => new
{
StudentName = m.FirstMidName,
TotalEnrollments = m.Enrollments.Count,
Enrollments = m.Enrollments.Select(s => new
{
Grade = s.Grade,
Course = s.Course.Title
})
})
.Project()
.Paginate(2, 3)
.LimitedGet();
var g1_a = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Project()
.Sort(s => s.LastName)
.Filter(w => w.ID > 0)
.LimitedSearch();
var g1_b = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Project()
.Filter(w => w.ID > 0)
.Sort(s => s.LastName)
.LimitedSearch();
var g2_a = lazyStore.AsFluentQuery()
.Projection()
.Include(i => i.Enrollments)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Map(m => new
{
StudentName = $"{m.LastName}, {m.FirstMidName}",
TotalEnrollments = m.Enrollments.Count,
Enrollments = m.Enrollments.Select(s => new
{
Grade = s.Grade,
Course = s.Course.Title
})
})
.Project()
.Sort(s => s.LastName)
.Filter(w => w.ID > 0)
.LimitedSearch();
var g2_b = lazyStore.AsFluentQuery()
.Projection()
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Course>(i => i.Course)
.Include <Enrollment>(i => i.Enrollments)
.ThenInclude <Student>(i => i.Student)
.Map(m => new
{
StudentName = $"{m.LastName}, {m.FirstMidName}",
TotalEnrollments = m.Enrollments.Count,
Enrollments = m.Enrollments.Select(s => new
{
Grade = s.Grade,
Course = s.Course.Title,
Student = s.Student == null ? string.Empty : s.Student.FirstMidName
})
})
.Project()
.Filter(w => w.ID > 0)
.Sort(s => s.LastName)
.LimitedSearch();
return(View());
}
