CODEWITHSUNDEEP
linq-to-sql
Andrew Siemer
Andrew Siemer

Reputation: 10278

How do you pass an array of integers to a stored procedure or function using linq to sql

I was just asked how to go about passing an array of integers into a stored procedure or function using LINQ to SQL. As I have never done this and don't see anything on Google I figured I would ask here. Thanks!

Upvotes: 1

Views: 768

Answers (1)

Marc Gravell
Marc Gravell

Reputation: 1063318

If it is a table-valued parameter, then AFAIK there is no direct support at the moment. ADO.NET does though. Another option is to build a delimited string, and split it (perhaps in a udf) at the db. Then it is just a [n]varchar(size) at the db, and string in your code - simply to handle.

Upvotes: 3

Related Questions