Devart Forums

Are there any plans to add support for stored procedures and packages within the entity developer? If there are, in what timeframe?

We plan to support Stored Procedures, but no timeframe can be provided.

I too would be interested in this.

So, can you add in suuport for stored procedures by modifying the generated data context code?

Thanks,
Joe

No, such a support is unlikely to be provided. But we are working on an alternative solution.

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

Unfortunately, you are right. There is no way to use stored procedures with LINQ to PostgreSQL now.