Hello

We are using a adapter.fetchedtypedview to return the results of a stored proc.

When executed it returns

SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException : An exception was caught during the execution of a retrieval query: Invalid object name 'Resultset1'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ----> System.Data.SqlClient.SqlException : Invalid object name 'Resultset1'.

the stored proc is

CREATE PROCEDURE [dbo].[spMyAccountSelect](@loginname VARCHAR(10)) AS BEGIN SELECT * FROM Account where LoginName like '%'+@loginname+'%'; END

GO

using llblgen 3

runtime build nr, designer build date please. Make sure you use the latest designer so you have the latest templates.

I have downloaded the latest version on your sight

ADO.NET:Execute Reader "SELECT [AxxessRad].[dbo].[Resultset1].[FileAs], [AxxessRad].[dbo].[Resultset1].[FirstName] FROM [AxxessRad].[dbo].[Resultset1] " The command text "SELECT [AxxessRad].[dbo].[Resultset1].[FileAs], [AxxessRad].[dbo].[Resultset1].[FirstName] FROM [AxxessRad].[dbo].[Resultset1] "

This is the sqlstatement it produces

The stored proc is named GetAccount.

fileversion: 3.1.11.518

Could you please attach a repro llbgen project file?

here it is

Jed wrote:

here it is

Removed. This isn't sufficient, sorry. The problem is about a stored proc, and we want to be able to reproduce it, so we need a stored proc, a simple project which maps the proc and a piece of code which calls the proc as you do in your code so when we generate code from the project we can run your code snippet and reproduce the error.

Thanks for the response.

I have just used a normal datatable and its working fine.