Category Archives: 12253

WAQS Querying: Math methods

7 reasons to use WAQS WAQS documentation   Math calculation with LINQ To Entities As with DateTime calculation, Math methods such as Abs, Ceiling, Floor, Pow, Round and Truncate are not supported by LINQ To Entities. With L2E queries, you … Continue reading

Posted in 12253, 16868, 7671 | Leave a comment

WAQS: ParameterMode

7 reasons to use WAQS WAQS documentation   Imagine the following code. string city = "Paris";var query = _context.Customers.Where(c => c.City == city);//…city = "London";foreach (var c in query){    //…} With this code, the foreach is on customers from London. … Continue reading

Posted in 12253, 16868 | Leave a comment

WAQS Querying: support entities extension methods on LINQ queries

7 reasons to use WAQS WAQS documentation   We saw that LINQ To WAQS (L2WAQS) and LINQ To Entities + WAQS (L2EW) support calculated properties. L2WAQS and L2EW also support specification service / sub entities extension methods. So for example, … Continue reading

Posted in 12253, 16868 | Leave a comment

WAQS: Querying a lot of entities

7 reasons to use WAQS WAQS documentation   The waiting issue When you load 100 000 entities to show them in a ListBox for example, user experience is very bad if application freezes with a Not responding message. How to … Continue reading

Posted in 12253, 16868 | Leave a comment

Using WAQS as a layer on top of Entity Framework

7 reasons to use WAQS WAQS documentation   We saw in previous posts that WAQS adds some improvements on LINQ To WAQS (comparing to LINQ To Entities). Now the point is the fact that it would be a shame if … Continue reading

Posted in 12253, 16868, 7674 | 1 Comment

WAQS Querying: With on sub types (inheritance)

7 reasons to use WAQS WAQS documentation   I already wrote about the With method. However, I wanted to have something equivalent to my inherited include for the With method. So for example, imagine that we have a calculated property … Continue reading

Posted in 12253, 16868 | Leave a comment

WAQS Querying: Include and inheritance

7 reasons to use WAQS WAQS documentation   I already wrote on WAQS Include method. However, there is one more point you can’t do with an easy way with EF. Imagine that you have an entity Person and you have … Continue reading

Posted in 12253, 16868, 7674 | Leave a comment

WAQS Querying: Contains method support

7 reasons to use WAQS WAQS documentation   LINQ To Entities supports Contains method but only on scalar types. LINQ To WAQS also supports it for entity types. So, if you use a contains on an entity type collection, LINQ … Continue reading

Posted in 12253, 16868, 7674 | Leave a comment

WAQS Querying: IncludeFor

7 reasons to use WAQS WAQS documentation   Imagine that you want to calculate a calculated property in memory or you need to execute a service method. As I previously explain, I don’t want to have lazy loading. So it’s … Continue reading

Posted in 12253, 16868 | Leave a comment

WAQS Querying: Avoid useless data loading using partial entity loading

7 reasons to use WAQS WAQS documentation   As I already explain in the previous post, LINQ To Entities does not support constructor in entity types. However, it could be very useful to have this feature. For example, imagine that … Continue reading

Posted in 12253, 16868, 7674 | Leave a comment