Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string ID = "XXID";
- string Sql = @"SELECT * FROM @Table WHERE " + ID + " LIKE '@SearchTerm'";
- ObjectParameter[] Parameters = new ObjectParameter[2];
- Parameters[0] = new ObjectParameter("Table", Table);
- Parameters[1] = new ObjectParameter("SearchTerm", SearchTerm);
- using (var Context = new XXEntities())
- {
- Context.Database.Connection.Open();
- IEnumerable<string> Query = Context.Database.SqlQuery<string>(Sql, Parameters);
- string[] Results = Query.ToArray();
- Context.Database.Connection.Close();
- return Results;
- }
- IEnumerable<string> Query = Context.Database.SqlQuery<string>(Sql,
- new SqlParameter("Table", Table),
- new SqlParameter("SearchTerm", SearchTerm));
- IEnumerable<string> Query = Context.Database.SqlQuery<string>("SELECT * FROM "+Table+" WHERE " + ID + " LIKE '"+SearchTerm+"'");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement