How to get data on datatable by calling stored procedure?

Question

I have a stored-procedure like this :

ALTER PROCEDURE [dbo].[SelectUserInfo] 

AS
BEGIN
select * from User_Info
END

and I am using LINQ to call this procedure and want store the data in a datatable or dataset here what I am doing :

DataClassesDataContext dc = new DataClassesDataContext();
DataTable dt = null;
dt = (DataTable)dc.SelectUserInfo();

but its not working its giving error.

the error is this :

Unable to cast object of type 'SingleResult`1[SelectUserInfoResult]' to type 'System.Data.DataTable'.

Please help me to do this ...

I don't think you can directly cast the results to the DataTable. The results is of type SelectUserInfoResults which you must have defined it in some function import. — Nilesh
– Nilesh, Commented Aug 24, 2013 at 12:23
One of the points of LINQ is to avoid using datasets. The idea is that instead you have a collection of entities. — podiluska
– podiluska, Commented Aug 24, 2013 at 12:36
the thing is i have a method inside a class which i want to return datatable or dataset so i can call that method in my application and have a datatable — Arindam Das
– Arindam Das, Commented Aug 24, 2013 at 12:38

Hugo Nava Kopp · Accepted Answer · 2016-02-15 18:47:18Z

1

Make sure you really do need a DataTable/DataSet.

The DBML file creates a return class for your Stored Procedure, in your case there is a class SelectUserInfoResults that got created when you added the stored procedure SelectUserInfo to your dbml file.

So if you are not being forced to use DataTables/DataSet you could simply create a List<SelectUserInfoResults> as your return type.

DataTables/DataSets and Linq To Entities classes are of very different nature, I would recommend to avoid mixing them whenever possible.

edited Feb 15, 2016 at 18:47

answered Aug 5, 2014 at 11:50

Hugo Nava Kopp

3,1242 gold badges26 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get data on datatable by calling stored procedure?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related