Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. string ID = "XXID";
  2. string Sql = @"SELECT * FROM @Table WHERE " + ID + " LIKE '@SearchTerm'";
  3. ObjectParameter[] Parameters = new ObjectParameter[2];
  4. Parameters[0] = new ObjectParameter("Table", Table);
  5. Parameters[1] = new ObjectParameter("SearchTerm", SearchTerm);
  6.  
  7. using (var Context = new XXEntities())
  8. {
  9. Context.Database.Connection.Open();
  10. IEnumerable<string> Query = Context.Database.SqlQuery<string>(Sql, Parameters);
  11.  
  12. string[] Results = Query.ToArray();
  13. Context.Database.Connection.Close();
  14. return Results;
  15. }
  16.  
  17. IEnumerable<string> Query = Context.Database.SqlQuery<string>(Sql,
  18. new SqlParameter("Table", Table),
  19. new SqlParameter("SearchTerm", SearchTerm));
  20.  
  21. IEnumerable<string> Query = Context.Database.SqlQuery<string>("SELECT * FROM "+Table+" WHERE " + ID + " LIKE '"+SearchTerm+"'");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement