Restrictions on Table Names

subsonic

Are there any restrictions on the names of tables, or issues with certain names when working with SubSonic?
I have table called 'Activity' and SubSonic doesn't seem to recognise it. When it was called 'Activities' it worked fine.

Basically I am wanting to go with singular table names as a convention (and the other conventions as detailed in the SubSonic Conventions blog post) and added fixPluralClassNames="false" to the web.config (because I have a table called 'Focus', which SubSonic kept naming 'Focu')

Best Answer

Generally, reserved words in C# are not allowed as table names. I'm not sure why Activity would be a problem though. The first thing to check when a table is not generated is that the table has a primary key.

Related Solutions

Populating field from enum table

If you use SubSonic 3.0 you can do this with projection:

var result = from e in db.Entities
where e.ID=1
select new Entity{
   ID=e.ID,
   name=e.Name, 
   CategoryName=(CategoryName)e.CategoryID
}

With SubSonic 2.x, I'd say to make it easy on yourself and extend the partial class with a readonly enum:

public partial class Entity{
   public CategoryName{
     return (CategoryName)this.CategoryID;
   }
}

Mysql – SubSonic, SQL Server and MySQL problems table names [ ClienteEndereco Clienteendereco ]

As Pawel pointed out MySQL on Windows and OS X uses only lowercase names for tables by default. There is a configuration option that you can use to change this behaviour. The following blog posting gives a brief overview:

MySQL Case-sensitivity issues

Best Answer

Related Solutions

Populating field from enum table

Mysql – SubSonic, SQL Server and MySQL problems table names [ ClienteEndereco Clienteendereco ]

Related Topic