stored procedure support
stored procedure support
Are there any plans to add support for stored procedures and packages within the entity developer? If there are, in what timeframe?
I just want to make sure I understand this correctly.
So, I wouldn't be able to edit the DataContext.cs file and add in my own definition for a stored procedure, say something like this:
[StoredProcedure(Name = "GetUserSettings")]
public StoredProcedureResult
GetGetUserSettings([Parameter(Name = "City", DBType = "NVarChar(30)")] string v_userName,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_password,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_company,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_userIP,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_appName)
{
return this.ExecuteStoredProcedure
(((MethodInfo)(MethodInfo.GetCurrentMethod())), city);
}
And have this stored procedure definition be part of the DataContext class. Is this correct? Is there any way to do it?
Thanks,
Joe
So, I wouldn't be able to edit the DataContext.cs file and add in my own definition for a stored procedure, say something like this:
[StoredProcedure(Name = "GetUserSettings")]
public StoredProcedureResult
GetGetUserSettings([Parameter(Name = "City", DBType = "NVarChar(30)")] string v_userName,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_password,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_company,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_userIP,
[Parameter(Name = "City", DBType = "NVarChar(30)")] string v_appName)
{
return this.ExecuteStoredProcedure
(((MethodInfo)(MethodInfo.GetCurrentMethod())), city);
}
And have this stored procedure definition be part of the DataContext class. Is this correct? Is there any way to do it?
Thanks,
Joe