WhiteWhisker
Posts 1
|
Hello, I have updated my dbml file today with a new stored procedure and now my project will not compile. This is on sql server 2008, this is what the stored procedure looks like:
CREATE PROCEDURE [dbo].[sp_GetRankingByDate]
@Date DateTime
AS
BEGIN
...
END
and this is the function it generates in the dbml:
[Function(Name="dbo.sp_GetRankingByDate")]
public ISingleResult<spGetRankingByDateResult> spGetRankingByDate([Parameter(Name="[Date]", DbType="datetime")] System.Nullable<System.DateTime> @[Date])
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), @[Date]);
return ((ISingleResult<spGetRankingByDateResult> (result.ReturnValue));
}
It throws compiler errors around the parameter: @[Date]
if I change it to:
[Function(Name="dbo.sp_GetRankingByDate")]
public ISingleResult<spGetRankingByDateResult> spGetRankingByDate([Parameter(Name="date", DbType="datetime")] System.Nullable<System.DateTime> date)
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), date);
return ((ISingleResult<spGetRankingByDateResult>(result.ReturnValue));
}
everything works correctly, but then I am modifying the designer.cs file, am I doing something wrong? Not sure how to get rid of the smileys in the post...
Thanks
edited by WhiteWhisker on 4/17/2010
edited by WhiteWhisker on 4/17/2010
|