Tag Archives: database

Duplicate Key Exception

Posted on October 17, 2013 by david

Entity Framework throws exceptions from the DbContext’s SaveChanges method if there is a constraint violation in the database. If you have a property marked as invariant w.r.t. concurrency, that too will raise an exception at this point (a DbUpdateConcurrencyException Exception. … Continue reading →

Posted in EF | Tagged , , , | Leave a comment

Architecture : Entity Framework

Posted on May 6, 2013 by david

I’ve had an extensive opportunity to play with entity framework. Here are my few thoughts. Code first does work reasonably well if you are starting from scratch, but managing the release of vital enterprise applications, which require care around the DB become … Continue reading →

Posted in EF | Tagged , , | Leave a comment

Working with Databases in Visual Studio 2010

Posted on June 15, 2012 by david

Having had a less than happy time with the Database Project in Visual Studio 2010 I can report that I have found a workable alternative. Create Database (DEV version) (However you like) Use Sql Server Management Studio to generate an … Continue reading →

Posted in VS2010 | Tagged | Leave a comment

Visual Studio 2010 Database Projects

Posted on June 15, 2012 by david

I’ve never used a database project in a Visual Studio solution before. In most of the places I’ve worked, the database is managed by full time DBA’s, who deal in sql scripts taylored to make specific schema updates. So i … Continue reading →

Posted in VS2010 | Tagged | Leave a comment