I'm trying to develop a SL4 business app using ria services to run a stored procedure and return the result set for use in a chart.
The problem is, that when I add my SP to the LINQtoSQL Class, or the ADO Entity, the return type can not be found by the designer and it tries to use int as the return type. I tried to create a manual dataclass in my LINQtoSQL class, and manually add the column names that the SP returns, then used the code below.
The <DailyData> in the IQueryable is the dataclass that I manually created, and added the column names that I know the SP returns. I also set a primary key on the dataclass.
When I try to run the app, I get an error that the dbo.GetCarbonData cannot be found.
I'm new to this and sure I've done somethning wrong in the LINQtoSQL creation.
Can anyone help here.
public class LINQtoSQLDomainService : LinqToSqlDomainService<LINQtoSQLClassDataContext>
// Consider constraining the results of your query method. If you need additional input you can
// add parameters to this method or create additional query methods with different names.
public IQueryable<DailyData> GetCarbon(string sDate,string Month,string MeterInstance)