Is it possible to send a collection of ID’s as a ADO.NET SQL parameter?

by

Generally the way that you do this is to pass in a comma-separated list of values, and within your stored procedure, parse the list out and insert it into a temp table, which you can then use for joins. As of Sql Server 2005, this is standard practice for dealing with parameters that need to hold arrays.

Here’s a good article on various ways to deal with this problem:

Passing a list/array to an SQL Server stored procedure

But for Sql Server 2008, we finally get to pass table variables into procedures, by first defining the table as a custom type.

There is a good description of this (and more 2008 features) in this article:

Introduction to New T-SQL Programmability Features in SQL Server 2008

More Related Contents:

  1. Entity Framework and Connection Pooling
  2. How can I query for null values in entity framework?
  3. store image in database or in a system file? [closed]
  4. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  5. Is it necessary to manually close and dispose of SqlDataReader?
  6. A connection was successfully established with the server, but then an error occurred during the pre-login handshake
  7. What’s the best method to pass parameters to SQLCommand?
  8. Bulk Insert to Oracle using .NET
  9. Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime
  10. Parameterized Queries with LIKE and IN conditions
  11. Is it necessary to add a @ in front of an SqlParameter name?
  12. Using “GO” within a transaction
  13. Does End Using close an open SQL Connection
  14. Does this code prevent SQL injection?
  15. Sanitize table/column name in Dynamic SQL in .NET? (Prevent SQL injection attacks)
  16. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  17. How can you name the Dataset’s Tables you return in a stored proc?
  18. How can I create database tables from XSD files?
  19. How can I avoid SQL injection attacks in my ASP.NET application?
  20. How to I serialize a large graph of .NET object into a SQL Server BLOB without creating a large buffer?
  21. Why is some sql query much slower when used with SqlCommand?
  22. Check if a SQL table exists
  23. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  24. How do I convert a string into safe SQL String?
  25. Do you think it’s advantageous to switch to Entity Framework? [closed]
  26. Regular expression to find all table names in a query
  27. How to return a page of results from SQL?
  28. Using a variable for table name in ‘From’ clause in SQL Server 2008
  29. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?
  30. Do we have transactions in MS-Access?

Leave a Comment