- GIT to SVN Quick Start May 23, 2013
- Entity Framework 4 (EF4) with Visual Studio 2010 and Pluralisation January 30, 2011
- Error: IIS SSL certificate re-issue and the issuer of the certificate not being trusted with the error : “The issuer of this certificate could not be found” October 10, 2010
- Code-First Development with Entity Framework 4 July 18, 2010
- Protected: Bikes and Video April 25, 2010
- Visual Studio 2010 and .NET 4 officially released today April 13, 2010
- Protected: Visual Studio 2010 Pending Release April 7, 2010
- .NET web.config WCF Settings February 19, 2010
- OziExplorer Tracklog File Format February 16, 2010
- Baited Remote Underwater Video Stations February 6, 2010
- Ten things to do with your new friend PALRO February 5, 2010
- Specifying/changing the database when using Web Parts in an ASP.NET application February 3, 2010
- God mode on Windows 7 January 11, 2010
- Protected: Windows Registry interaction with 64 and 32 bit applications January 7, 2010
- Retrieving COM class factory failed due to the following error: 80040154 January 7, 2010
- Integrated security with IIS and .NET January 7, 2010
- IIS Hosted WCF Service Fails January 5, 2010
- Getting IIS Debugging and WCF working under Vista and Windows 7 with VS2008 January 5, 2010
- WinForms applications – No Touch Deployment (NTD) and gotchas January 5, 2010
- First post January 5, 2010
Category Archives: Code
With the recent release of Microsoft’s EF4 with Visual Studio there is some debate around the use of pluralisation of table names.
Standard database theory is taught to use singular entity names, i.e. Genre and the table names should match this singular naming convention, i.e. Genre not Genres.
With EF4, whether using the Code First (CF) features or not, the table names are expected to be pluralised. This is an issue if you prefer to stick with the singularised table names or don’t have a choice on pre-existing databases. It is difficult to change an existing database, especially if that database is being used by other programs or reports within an organisation. This also causes some conflicts when an entity such as Person is used – the EF pluralises this as Persons but perhaps People would be a better option.
This post shows how to get around the EF pluralisation for whatever reason you need. Continue reading
The EF Code-First Library is a very cool feature of the Visual Studio 2010 tools that will allow developers to get their applications running quickly – a full persistent data entity model can be created without having to configure a database, run any tools, configure any XML files, or define any base data entity classes. One of the coolest things is the way the database model can be changed automatically when changes to the entity model are made and the automatic creation of the primary keys and relationships between the tables. This should be a real time saver to developers.