Store procedure with linq, conversion problem

Question

0.00/5 (No votes)

See more:

I Am Working 3 tier Architecture with linq and store procedure:

I insert and update And Delete Record Successfully,

But When Secting Record From table Then there is an error releted to type casting:

I have used following code at BLL:

XML

public List<tbl_admin_category> GetCategoryDetails(int id)
   {

       var v = li.SP_Category_Get(id);

       return ((List<tbl_admin_category>)(v));


   }

And At aspx.cs page:

C#

var v1 = obj.GetCategoryDetails(0);
      gd_cat.DataSource = v1;
      gd_cat.DataBind();

And Procedure Is:

SQL

ALTER PROCEDURE [dbo].[SP_Category_Get]
(
             @id int=0

)
As
SET NOCOUNT ON
if(@id=0)
Begin
         Select * From tbl_admin_category


End

else
Begin
 Select * From tbl_admin_category
 where
  id= @id
  End
SET NOCOUNT OFF

ERROR Msg IS:
Unable to cast object of type 'SingleResult`1[SP_Category_GetResult]' to type 'System.Collections.Generic.List`1[tbl_admin_category]'.

And If I not Use Store Procedure:
And Use Simple Method In BLL Then It Work Fine:

Like:

XML

public IEnumerable<tbl_admin_category> GetCategoryDetails(int id)
   {


           var users = from user in li.tbl_admin_categories
                       select user;
           return users.ToList();

   }

Posted 25-Feb-13 23:16pm

Arun kumar Gauttam

Updated 26-Feb-13 2:37am

v5

Add a Solution

Comments

Karthik Harve 26-Feb-13 5:26am

where have you used LINQ here ?

Arun kumar Gauttam 26-Feb-13 5:43am

i used li as linq class connection obeject:
At BLL
LinqConnectionDataContext li = new LinqConnectionDataContext();

i used LinqConnectionDataContext As DAL:

Arun kumar Gauttam 26-Feb-13 5:49am

i use This Article For Linq With 3 tier:
http://www.c-sharpcorner.com/uploadfile/a72401/linq-with-3-layer-architecture-insert-data-into-database/

Matej Hlatky 26-Feb-13 7:39am

What is the SP_Category_Get method originally returning? I think it would be primitive IEnumerable(Of tbl_admin_category) rather than List(Of tbl_admin_category).

Arun kumar Gauttam 26-Feb-13 8:34am

I Try All Type Of Conversion And Try All Type Of Return (Like: List,IEnumerable,ISingleResult) But Error is Always Generate:

And If I not Use Store Procedure And Use This Method At BLL then No error Generated, And Code Work Well:

public IEnumerable<tbl_admin_category> GetCategoryDetails(int id)
{

var users = from user in li.tbl_admin_categories
select user;
return users.ToList();

}

Tejas Vaishnav 26-Feb-13 7:46am

what was the error message?

Arun kumar Gauttam 26-Feb-13 8:29am

Error Msg Is:

Unable to cast object of type 'SingleResult`1[SP_Category_GetResult]' to type 'System.Collections.Generic.List`1[tbl_admin_category]'.

bbirajdar 26-Feb-13 9:33am

You are gettings a single object here
var v = li.SP_Category_Get(id);

And you are trying to cast it to List here
((List<tbl_admin_category>)(v));

Then offcourse you will get the error...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Asim Mahmood · Accepted Answer · 2013-02-26T03:06:00

Solution 1

Use can get you data like this.

C#

var v = li.SP_Category_Get(id);
           return (from c in v
                   select new Class1() {
                      Property1 = c.value1,
                      Property2 =  c.value2
                   }
                  ).ToList();

Posted 26-Feb-13 3:06am

Asim Mahmood

Comments

Arun kumar Gauttam 26-Feb-13 23:53pm

wHAT Is Class1() In your Case

Arun kumar Gauttam 27-Feb-13 0:07am

I use It Like This And it Work Well:
thanks for it
var v = li.SP_Category_Get(id);

return (from c in v
select new tbl_admin_category()
{
id=c.id,
category = c.category,
category_img = c.category_img
}
).ToList();