Topic
No replies
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic SQL0206N EntityCommandExecutionException

‏2012-10-16T15:35:11Z |
I am having trouble with IBM DB2 express c 10.1 and .net Entity Framework 4 to work. I am currently trying to get data from DB2 database using Entity Framework 4.


using (DBEntities ent = 

new DBEntities()) 
{ foreach (Company comp in ent.COMPANIES) 
{ listBox1.Items.Add(comp.Address); 
} 
}


I encountered this exception: ERROR 42703 IBMDB2/NT SQL0206N "EXTENT1.COMPANY_ID" is not valid in the context where it is used. I am pretty sure that there is no "EXTENT1.COMPANY_ID" anywhere in my database but there is a "CMS.COMPANY_ID". Please help