Hi,

I have some stored procedures in my database, but I can't see or use them in C#.

I have been refreshing the catalog in LLBLGen Pro. Of course I set the checkmark for retrieving strored procedures. But, I still can not see them in the "Stored Procedure Calls" section.

Same in my C#-Code. I tried to access them like ActionProcedures.xxx or RetrievalProcedures.xxx, but they are not listed by IntelliSense.

Any idea what I could have missed?

Thanks Ingmar

Hi,

What version of llblgen do you use? if you try to get the store proc on an other database like nothwind for sqlserver for example, did you have the same problem?

I'm using LLBL 2.0.0.0 (19.03.2007) and MS SQL Express 9.0.2047. Also, I'm using the SelfServicing (not the DataAccessAdapter).

Unfortunately I have no Northwind or any other database installed, so I can't proofe anything.

I created all stored procedures with CLR.NET (via MS Visual Studio 2005). The procedures are all visible in my MS SQL Server Management Studio Express. Here they are listed in the section "Programmability->Stored Procedures".

Hope you or someone else has any idea...

Ok, I found the problem: I'm having two different users on the database.

While retrieving new or modified schema information with LLBLGen I used an account that is legitimated as db_DataReader and db_DataWriter only.

I now tried the other user (dbo) and surpise, surprise: the stored procedures are found by LBLGen.

Does anybody know which rights are neccessary for LLBLGen to "see" the stored procedures?

Thanks!

Is there any error reported in the application output window (which is docked at the bottom of the llblgen pro designer) after you've created the project/refreshed the catalog?