Practical .NET

Defining Columns, Primary, and Composite Keys in Entity Framework

There are two attributes you can put on your entity class properties: one is a convenience, the other is essential, and both are required when the primary key for a table consists of two columns.

When creating an entity Class to work with one of your tables in your Entity Framework model, you might find the Column attribute useful. For one purpose, it's a convenience: If you have a column called txtFirstName (because it follows some naming convention used by the database design team) and you'd prefer to have your property just called FirstName (because that's your coding convention), then the Column attribute will let you have the property name you want. Just decorate the property in your entity Class with the Column attribute to tie your FirstName property to your txtFirstName column, like this:

Public Class Customer
    <Column(Name := "txtFirstName")>
   Public Property FirstName() As String

And that's nice to have.

While used like this, the Column attribute is a convenience, the Key attribute is required -- you have to use it to tell Entity Framework which of your columns corresponds to your table's primary key. This example tells Entity Framework that the Id property is the primary key column for the table:

Public Class Customer
   Public Property Id() As Boolean
   <Column(Name := "txtFirstName")>
   Public Property FirstName() As String

But what if the primary key for your table has two (or more) columns? It's not enough just to flag the columns using Key -- you also have to specify the order of the columns in the key. You'll need to use both the Key and the Column attributes to do that. This example:

Public Class Customer
   <Column(Order := 1)>
   Public Property FirstName As String
   <Column(Order := 2)>
   Public Property LastName As String

specifies that the Customer table has a composite key of FirstName and LastName with FirstName coming first.

About the Author

Peter Vogel is a system architect and principal in PH&V Information Services. PH&V provides full-stack consulting from UX design through object modeling to database design. Peter tweets about his VSM columns with the hashtag #vogelarticles. His blog posts on user experience design can be found at

comments powered by Disqus


  • Microsoft's Tools to Fight Solorigate Attack Are Now Open Source

    Microsoft open sourced homegrown tools it used to check its systems for code related to the recent massive breach of supply chains that the company has named Solorigate.

  • Microsoft's Lander on Blazor Desktop: 'I Don't See a Grand Unified App Model in the Future'

    For all of the talk of unifying the disparate ecosystem of Microsoft-centric developer tooling -- using one framework for apps of all types on all platforms -- Blazor Desktop is not the answer. There isn't one.

  • Firm Automates Legacy Web Forms-to-ASP.NET Core Conversions

    Migration technology uses the Angular web framework and Progress Kendo UI user interface elements to convert ASP.NET Web Forms client code to HTML and CSS, with application business logic converted automatically to ASP.NET Core.

  • New TypeScript 4.2 Tweaks Include Project Explainer

    Microsoft shipped TypeScript 4.2 -- the regular quarterly update to the open source programming language that improves JavaScript with static types -- with a host of tweaks including a way to explain why files are included in a project.

Upcoming Events