MySql, Entity Framework, Inner Joins with null checks generated -
I had a play with the unit framework and MySQL driver. Sorry it's a stupid question. Table ad vacancies have an FK in PK. Both fields are not marked as tap I am displaying a simple join:
var qry = (in spacing by reference). Join the advertisement on the vacant position. Equivalent ad advert.vacanscies.id on vacancy.id where advert.status == 1 new {id = advert.id});
This generates the following SQL:
Selection 1 as the C1, from the empty positions as Extent2.id as Extent1 INNER Add Ad Extent2 ON (Extent1.id = Extent2.vacancy_id) or ((Extent1.id is the IS faucet) and (Extent2.vacancy_id is the IS tap) where 1 = Extent2.status
Why Creating the position of "IS Null" for EF, when the column is not marked blank?
Thanks,
Bob
- this is the provider, not EF , Which generates SQL.
- The query is incorrect anyway. And by all this, ads are restricted with spacing, which you say is unnecessary anyway.
Comments
Post a Comment