stored procedure support

jbmeeh · Post by **jbmeeh** » Fri 21 Nov 2008 18:51

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

AndreyR · Post by **AndreyR** » Mon 24 Nov 2008 09:30

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

Anchor · Post by **Anchor** » Mon 08 Dec 2008 21:07

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

AndreyR · Post by **AndreyR** » Tue 09 Dec 2008 12:07

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

Anchor · Post by **Anchor** » Tue 09 Dec 2008 18:08

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

AndreyR · Post by **AndreyR** » Wed 10 Dec 2008 11:57

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