SELECT * FROM X WHERE id IN (…) with Dapper ORM

by

Dapper supports this directly. For example…

string sql = "SELECT * FROM SomeTable WHERE id IN @ids"
var results = conn.Query(sql, new { ids = new[] { 1, 2, 3, 4, 5 }});

unless you are using Postgres, in which case see this answer

More Related Contents:

  1. store image in database or in a system file? [closed]
  2. SQL Identity (autonumber) is Incremented Even with a Transaction Rollback
  3. Fastest way to perform nested bulk inserts with scope_identity() usage?
  4. Is there a way to call a stored procedure with Dapper?
  5. Does Dapper support SQL 2008 Table-Valued Parameters?
  6. Bulk Insert to Oracle using .NET
  7. Parameterized Queries with LIKE and IN conditions
  8. Using “GO” within a transaction
  9. Does End Using close an open SQL Connection
  10. Does this code prevent SQL injection?
  11. Sanitize table/column name in Dynamic SQL in .NET? (Prevent SQL injection attacks)
  12. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  13. Why doesn’t Dapper dot net open and close the connection itself?
  14. How can you name the Dataset’s Tables you return in a stored proc?
  15. How can I create database tables from XSD files?
  16. How can I avoid SQL injection attacks in my ASP.NET application?
  17. Closing connection when using Dapper
  18. Why is some sql query much slower when used with SqlCommand?
  19. Is it possible to send a collection of ID’s as a ADO.NET SQL parameter?
  20. Dapper and SQL Injections
  21. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  22. How do I convert a string into safe SQL String?
  23. Regular expression to find all table names in a query
  24. How to return a page of results from SQL?
  25. Using a variable for table name in ‘From’ clause in SQL Server 2008
  26. How do parameterized queries help against SQL injection?
  27. New asp.net charting controls – will they work with MVC (eventually)?
  28. How do you keep user.config settings across different assembly versions in .net?
  29. How to completely uninstall Visual Studio 2010?
  30. When should I dispose my objects in .NET?

Leave a Comment