LINQ to entities - left join with condition -


I have a table table game in which FK (by allowing noses) is included in the game table when I do this :

  Gamewarson [] q = (Select gb from dv.GameVersion.Include ("Game") gv). ToArray ();  

This works fine, while playing Game Variable Objects, I can see blank references to the game in some records (just like on the databse), so it's like joining the left Works.

However, when I modify a little query and add a search by the name of the game

gamewarson [] q = (db.GameVersion.Include in GV ("Game ") In which select gv.Game.DisplayName. (" A ") gv). ToArray ();

It behaves like being in a sudden (now does not select zero references) I do not quite understand this behavior. Why is this happening and how can I do a query? I want to apply a game betting game with game game == Null Plus to one of the game columns.

Well if there is no game, then there can not be a display name, so " A "can not be if you want to select the versions of the game also , where there is no game, then you have to do this clearly. Try it:

  GameWarson [] q = (db.GameVersion.Include from GV ("Game") where gv.Game == faucet || gv.Game.DisplayName.Contains ( "A") Select GV) .Oir ();  

Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -