(Note that the time (1000 ms in this case) starts counting when CancelAfter method is hit. Or (sometimes) converting query to list before getting first element also works (solution 2). Because touching the intended projection and canceling the task is enough to "clean the path" (solution 1). I supposed to see only columns needed for destination projection. I see in result sql select statement all the columns of all the concerning tables. But freeze appears only single first time. Var result = await _db.Packages.AsNoTracking().Where(p => p.PackageGuid = packageGuid).ProjectTo().FirstOrDefaultAsync() ġ) So if I project to LightPackageDto (without Member projections) is all right.Ģ) If I return entity manually from EF with includes and then I make mappings for "in memory" entity is all right tooģ) If I want Automapper makes "Select" query applying ProjectTo I allways get freeze about 2-3 sec. Var entity = await _db.GetPackage(packageGuid) fast (_db.GetPackage make query with all necessary includes) Var lightEntity = await _db.Packages.Where(p => p.PackageGuid = packageGuid).ProjectTo().FirstOrDefaultAsync() ForMember(dest => dest.DocGuid, opt => opt.MapFrom(src => ().DocGuid)) ForMember(dest => dest.Docflow, opt => opt.MapFrom(src => src.Docflow)) ForMember(dest => dest.Receiver, opt => opt.MapFrom(src => src.Receiver)) ForMember(dest => dest.Sender, opt => opt.MapFrom(src => src.Sender)) ForMember(dest => dest.CompanyPrefix, opt => opt.MapFrom(src => )) ForMember(dest => dest.CompanyFullName, opt => opt.MapFrom(src => )) ForMember(dest => dest.CompanyShortName, opt => opt.MapFrom(src => )) ForMember(dest => dest.Director, opt => opt.MapFrom(src => )) ForMember(dest => dest.Prop5, opt => opt.MapFrom(src => 5)) ForMember(dest => dest.Prop4, opt => opt.MapFrom(src => 4)) ![]() ForMember(dest => dest.Prop3, opt => opt.MapFrom(src => 3)) ForMember(dest => dest.Prop2, opt => opt.MapFrom(src => src.Prop2)) ForMember(dest => dest.Prop1, opt => opt.MapFrom(src => 1)) PersonDto has 3 simple type properties and is projected by flattening too Public DocflowTypeOption DocflowTypeId ĭocflowDto has 3 simple type properties and is projected by flattening. I have Dto classes: public class PackageDto
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |