retrieval Procedures Not generating

Posts   
 
    
Posts: 72
Joined: 11-Aug-2006
# Posted on: 01-May-2012 07:52:44   

hi there

Using version 3.1 Final, SQL Server 2008. .NET 4 / Adapter

Everything else standard.

Generates classes for Entities fine, but Stored Procedures don't seem to be in the RetrievalProcedures Class and therefore not accessible.

Streod Procedure names : spTransactionBatches & spTransactions - they have some parameters

It seems to add them ok in the designer. Just no code. help :-)

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 01-May-2012 19:27:17   

Not sure what's the problem is as we don't have your project file. Are you sure the Stored Procedures are mapped in the Designer as Retreival Procedures? Or their resultsets are mapped to TypedViews?

Posts: 72
Joined: 11-Aug-2006
# Posted on: 02-May-2012 00:01:37   

OK - I have figured that out ( I hadn't specified the number of resultsets returned - which is 1 )

the problem I have now is the same problem I was having in EF4 ( which is why I am using this instead of EF4 in the first place ) . Data for regular queries: no problem.

Stored Procedures all seem to time out. Even though the SP runs in less than a second in Query Analyzer. What is the issue here?

Posts: 72
Joined: 11-Aug-2006
# Posted on: 02-May-2012 03:15:28   

ok - sorted.. it was just the connection string. I guess with the tables - the database is explicit - so the SP was looking in the master database which was in the connection string. sorted!