SQLException: Invalid object name Toys (in pluralis, why?)

 Hi

I receive the following error for my initial test of Lightspeed using an SQL Server 2005 database. The connection is alright since I am able to query the database and this particular table using a normal ADO.NET query.

Lightspeed query and error:



Configuration in code made before call:

Configuration in web.config



and finally my Domain Model class:

The database table looks like this:

CREATE TABLE [dbo].[Toy](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Name] [varchar](50) NOT NULL
) ON [PRIMARY]

I'ven tried both using SQL Server Express version and SQL Server 2005. 

So what is wrong? Why is Toy spelled with an s at the end at the error message? If I would have had the SQL Server Profiler installed I guess I would have been able to give you more info about the SQL being sent to the database. But I am hpoing this is a simple error for someone to give me info about.

Hi Tobias,

Thanks for evaluating LightSpeed. Your problem is due to the pluralizeTableNames setting which causes LightSpeed to infer pluralized table names. Just set this to false to use singular names.

Additionally, you only need to specify the configuration once: Either in code or in the config file.

Cheers,

Andrew. 

Thanks. Works like a charm now. Funny, I didn't first realiaze what pluralizeTableNames meant, but it turned out to be more simple than what thought. Will this feature render the correct pluralize name for the class Child too?

Most likely I will have more questions upcoming, but I´ll post these in other threads.

No worries. The pluralizer in LightSpeed will handle "child" and even "octopus" :-)

Andrew.