Hi, my problem is that i get an exception when try to fetch all records from a table in PostgreSQL . The table exist and the error seems that the table name must use quotes. What i can do?.

Thanks.

Hi,

can you post some more information as specified in that thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7717

Thx

oh sorry, please excuse me this is what i have LLBLLGen Pro 2.0.0.0 FINAL DEMO Released Febrary 14th, 2007

->this is the code<-

PersonaCollection personas = new PersonaCollection(); Exception thrown -> personas.GetMulti(null);<- foreach (PersonaEntity persona in personas) { Console.Out.WriteLine(String.Format("Codigo {0} - Persona {1}", persona.CodigoP.ToString(), persona.Nombre.Trim())); } personas.Dispose();

->end code<- this is the exception message:

An exception was caught during the execution of a retrieval query: ERROR: 42P01: relation "public.Persona" does not exist. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

i have VS 2005 professional i m testing the orm

the database is a PostgreSQL v8.1 that runs on a FreeBSD 6

All names are packed in quotes, so this is odd.

Could you enable tracing please? Please check the section 'troubleshooting and debugging' in the manual which describes how to enable tracing and how to get the traced output back into for example vs.net's output window. Then please paste the generated SQL query here so we can have a look

Also please check you're connecting to the right DB and you've setup the connection string in your application's app.config file. If you've setup schema name overwriting, also please specify that.