Stored Proc in RIA Services

sql linq ria
sorin picture sorin · Aug 12, 2009 · Viewed 7.5k times · Source

I want to load some data with a SP.

I've put a SP in a Linq to SQL Class and I don't know how to use it for loading it's data in a datagrid. In LinqToSqlDomainService I can't figure out how to call a SP. What steps should I use.

Any samples of this ? All samples use a table.

Thank's

Answer

Nikhil Kothari picture Nikhil Kothari · Aug 25, 2009

This post should hopefully be of help: http://blogs.msdn.com/brada/archive/2009/08/24/business-apps-example-for-silverlight-3-rtm-and-net-ria-services-july-update-part-24-stored-procedures.aspx

Related questions

Entity Framework. Delete all rows in table

How I can quickly remove all rows in table using Entity Framework? I am currently using: var rows = from o in dataDb.Table select o; foreach (var row in rows) { dataDb.Table.Remove(row); } dataDb.SaveChanges(); However, it takes a …

Read More
LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression

I'm migrating some stuff from one mysql server to a sql server but i can't figure out how to make this code work: using (var context = new Context()) { ... foreach (var item in collection) { IQueryable<entity> pages = from p …

Read More
SQL to LINQ Tool

Is there a tool out there which can convert SQL syntax to LINQ syntax? I just want to rewrite basic queries with join, etc., to LINQ. It would save me a lot of time.

Read More