Returning List<int> from Database

c# sql-server list executescalar
Simon Kiely picture Simon Kiely · Jun 19, 2012 · Viewed 7.7k times · Source

I have a simple problem that I have not been able to find an answer to despite much Googling. Perhaps posting this question up will help the next poor soul who looks for the same answer.

I have a query that returns a collection of distinct ID's.

I am creating an SQLCommand with this query and using ExecuteScalar( ) to run it.

ExecuteScalar( ) appears to return an object and will not allow me to cast it to List.

What is the best practice to fix this and how can I fix this problem?

Answer

Jason Meckley picture Jason Meckley · Jun 19, 2012

execute scalar returns a single piece of data. think one row, one column. if you want to return a collection you need to call ExecuteReader(). this will return an IDataReader. you can then iterate over the records and return you list.

Related questions

How to execute a stored procedure within C# program

I want to execute this stored procedure from a C# program. I have written the following stored procedure in a SqlServer query window and saved it as stored1: use master go create procedure dbo.test as DECLARE @command as varchar(1000), @…

Read More
How can I set an SQL Server connection string?

I'm developing a simple C# application, and I'd like to know this: When I connect my application to SQL Server on my PC, I know the connection string (server name, password, etc.), but when I connect it to another PC, …

Read More
Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call a created stored procedure from my database. This a button insert I make work well. private void btnAdd_Click(object …

Read More