calling stored procedure from linq

Question

hey guys, i have a stored procedure known as sp_sitesearch, which returns the result of the site search, now what i want to do is, i want to call this sp to gridview using LINQ, coz one of my friend suggested that linq's performance is faster than DataTable or DataSet. so i want to try that, so i created a dbml, and added my SP inside this, and inside the .cs i wrote below code.
SiteSearchDataContext siteSearch = new SiteSearchDataContext(); gridArticle.DataSource = siteSearch.sp_SiteSearch(1, keyword); gridArticle.DataBind();

here it throws an error saying, it should return IEnumerable or IDataSource, i got a shock when i found that it returns int... but i dont know how, as my sp is not returning anything, it just returns a resultset, so can anyone suggest me how should i use this to bind gridview.

Joel C · Accepted Answer · 2011-05-09 20:29:48Z

1

It sounds like you didn't map your stored procedure to have a return type in your entity data model. If you go back into your data model and edit your Function Import, there should be a section of the window labeled "Returns a Collection Of" that you can use to define what your stored proc is returning. Hopefully what it's returning can be mapped directly to an entity type in your data model, as that will allow you to simply pick an entity from the dropdown. If your results are returned in a way that doesn't map cleanly to an existing entity, refer to How to: Map a Function Import to a Complex Type (Entity Data Model Tools) on MSDN.

answered May 9, 2011 at 20:29

Joel C

5,5871 gold badge23 silver badges32 bronze badges

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

Comments

MarkXA · Accepted Answer · 2011-05-09 19:29:00Z

0

You can't bind an IQueryable to a DataSource. You need

gridArticle.DataSource = siteSearch.sp_SiteSearch(1, keyword).ToList();

answered May 9, 2011 at 19:29

MarkXA

4,40423 silver badges23 bronze badges

3 Comments

Abbas Over a year ago

thanks for your reply, but i cannot find ToList() after sp_SiteSearch(1, keyword).ToList(); i think its returning int by default, so i have ToString() option.

Joel C Over a year ago

Not sure why you would think you can't bind to an IQueryable<T>, it implements both IEnumerable and IEnumerable<T>

MarkXA Over a year ago

@Joel You probably can bind to some IQueryables, but in my experience a LINQ to SQL IQueryable won't work. @Abbas If you're getting an int, then the chances are that the SQL isn't being interpreted correctly. Can you post the actual SP?

Collectives™ on Stack Overflow

calling stored procedure from linq

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related