"Give your tables singular names, not plural names. An entity is a single unit, like Customer. The definition of an entity is determined from the definition of the table (or view) it's mapped on. If you name your table 'Customers', you will end up with the entity 'Customers', unless you change the name of the entity in the Add Entities form catalog screen, which of course takes time. It's best practise to name your tables after the entity they represent, which is a singular name, like Customer or Order. For views you want to use as entities, the same applies. LLBLGen Pro supports singularization through Designer Event plug-ins, however these are for English only. To avoid any extra work, define your tables with singular names. "

I tried to run the sample for complex databinding where it displays a grid with combo boxes for Northwind Database. I tried to run it many times but it failed to run because of missing tables. I found out the sample uses plural names for tables Orders, Employees, Shippers, etc.. I ended up renaming the tables on Northwind db. ironic ha, its running fine now.

Im refering to this project: Example_ComplexDatabinding_NET20_08222007

Thanks for reporting, we will check it out.

Which Northwind did you use? The default northwind has plural names for the tables. However MS released a new version with more tables with MS Access 2007, I'm not sure if you're referring to that one?

i downloaded it from this link.

http://www.llblgen.com/pages/tutorials.aspx

suddenserenity wrote:

i downloaded it from this link.

http://www.llblgen.com/pages/tutorials.aspx

I meant the northwind database... where did you obtain that? The application is made on the OLD (sqlserver 2000) northwind. I'm not sure if MS now distributes a different one.

i just followed the link from this forum, and i ended in msdn download page. yes, i think its for sql server 2000.

maybe you can create a new starter kit or sample out of new adventure works database .

suddenserenity wrote:

i just followed the link from this forum, and i ended in msdn download page. yes, i think its for sql server 2000.

maybe you can create a new starter kit or sample out of new adventure works database .

Sqlserver 2000 comes with the Plural name db. I think it's a newer one, based on the same northwind as with access2007. Thanks for the feedback