If, like me, you are having reliability issue with some of your Entity Framework queries performing consistently this post is going to help you immensely. To start with, make sure you understand the LINQ queries and how they translate to SQL and make sure you’ve done what you can to get the end SQL query… Continue reading Making Entity Framework Queries Perform Reliably
Category: Entity Framework
Delete localDb database after physical files have been deleted
While working on setting up a new project structure for the team and prototyping how I could get the Entity Framework ‘Update-Database’ command to work from the repository project (EF aware) to create/update the database and have the web project (not EF aware) make use of the database – I made the mistake of deleting the database… Continue reading Delete localDb database after physical files have been deleted
Enity Framework Fluent APIs
Fluent API and annotations are you two options when it comes to controling mappings and configuring constraints such as field length or required. When configured these constraints it will affect the database that is created by Code First as well as the validation that is done by Entity Framework. Some reasons to favour fluent APIs:… Continue reading Enity Framework Fluent APIs
Visual Stuido and IntelliTrace gotcha
I was trouble shooting the ability to create a localdb database using Entity Framework and Visual Studio when I found that I had waisted over an hour because I didn’t understand the fundamentals of IntelliTrace. When the error popped up I immediately went to the first Exception at the top of the IntelliTrace log and… Continue reading Visual Stuido and IntelliTrace gotcha
Kaz on Commerce! 