c# - Select "IN" in LINQ to SQL -


I get a list of institutions to update and I have their ID. I want to get the original people from the database , Then I work: 

  String [] id = updatedEvents.Select (ue = & gt; ue.id) .toArray (); Var Basic Aventures TOoUpdate = Db.tbl_ffk_event. Where (E => ID content (e.id)) .Oir ();   
 But what I use to login is to generate this SQL: .. Select  
  [t0] [id], [t0] [fs_mapping_id], [t0] [fs_id_value], [t0] [desc] [dbo] as [tbl_ffk_event] [T0] ou 0 = 1 - context: ... SqlProvider (Sql2008) Model: AttributedMetaModel Build: 4.0.30319.1   
 and that SQL means "get entire table"  
 how do I generate such a "in" can do:. Select  
  [t0]. [ID], [t0]. [Fs_mapping_id], [t0]. [Fs_id_value], [t0]. [Desc] from [dbo] [Tbl_ffk_event] as [t0] where [t0]. In the [id] ('AAA', 'bbb', 'ccc', 'ddd', 'eee',)   
 thanks in advance  
 Edit:.  
 I'm stupid, I did not see the  WHERE 0 = 1  This is because at that point, where there is nothing in the  id  collection, I have now made sure that there are items, and SQL is generated correctly, sorry.   
 
 
 Actually, section  WHERE 0 = 1  due to this SQL, an empty record set Will return (i.e. accurately mapped in the context of schema, but with no row)  
 The code you provided is correct, but some have assured the query provider that there can not be a matching line at any time.  
 Assume that's not correct in it, I want to see column mapping for the property  id . Does this match the database exactly?

Comments

Post a Comment