No edit summary |
No edit summary |
||
Line 2: | Line 2: | ||
The problem can be shown with this model: | The problem can be shown with this model: | ||
[[File:Linq.png|none|thumb|366x366px]] | |||
If you want to find SomeSubClass that has a Class2 with a specific name :<html> | |||
If you want to find SomeSubClass that has a Class2 with a specific name : | |||
<html> | |||
<pre class="code"><span style="background: white; color: blue;">var </span><span style="background: white; color: black;">foo2 = (</span><span style="background: white; color: blue;">from </span><span style="background: white; color: black;">v </span><span style="background: white; color: blue;">in </span><span style="background: white; color: #2b91af;">EcoLinqExtender</span><span style="background: white; color: black;">.PSQuery<</span><span style="background: white; color: #2b91af;">Class2</span><span style="background: white; color: black;">>(EcoSpace) | <pre class="code"><span style="background: white; color: blue;">var </span><span style="background: white; color: black;">foo2 = (</span><span style="background: white; color: blue;">from </span><span style="background: white; color: black;">v </span><span style="background: white; color: blue;">in </span><span style="background: white; color: #2b91af;">EcoLinqExtender</span><span style="background: white; color: black;">.PSQuery<</span><span style="background: white; color: #2b91af;">Class2</span><span style="background: white; color: black;">>(EcoSpace) | ||
</span><span style="background: white; color: blue;">where </span><span style="background: white; color: black;">(v.Class1.Attribute1 == </span><span style="background: white; color: #a31515;">"5" </span><span style="background: white; color: black;">&& v.Name == </span><span style="background: white; color: #a31515;">"5A"</span><span style="background: white; color: black;">) | </span><span style="background: white; color: blue;">where </span><span style="background: white; color: black;">(v.Class1.Attribute1 == </span><span style="background: white; color: #a31515;">"5" </span><span style="background: white; color: black;">&& v.Name == </span><span style="background: white; color: #a31515;">"5A"</span><span style="background: white; color: black;">) |
Revision as of 16:28, 2 December 2018
Up until now there has been a problem to filter on type in Linq
The problem can be shown with this model:
If you want to find SomeSubClass that has a Class2 with a specific name :
var foo2 = (from v in EcoLinqExtender.PSQuery<Class2>(EcoSpace) where (v.Class1.Attribute1 == "5" && v.Name == "5A") select v.Class1)
But now you also get Class1’s that are not of SomeSubClass. And that is a problem in certain situations.
In Ocl2Ps we would have done:
Class2.allInstances->select(a|((a.Class1.Attribute1 = '5') and (a.Name = '5A'))).Class1->FilterOnType(SomeSubClass)
Until now MDriven Linq2Sql logic did not understand the Linq counterpart of FilterOnType – which is OfType<class>().
But now it does:
var foo2 = (from v in EcoLinqExtender.PSQuery<Class2>(EcoSpace) where (v.Class1.Attribute1 == "5" && v.Name == "5A") select v.Class1).OfType<SomeSubClass>()
With this is place the database takes care of all the filtering for us and returns the SomeSubClasses that has any Class2 with the correct criteria.