A DbSet in an Entity Framework DbContext has a Local property that let us access entities already retrieved within the scope of the DbContext. This way it is possible to further query a local entity set, without sending a query to the database. More…
The DbContext of Entity Framework lets us add, remove, attach and detach entities to and from it. Calling SaveChanges on the DbContext the Entity Framework performs different actions on entities dependant on their EntityState. So an added entity gets inserted, a removed entity gets deleted and so on. More…
Using a Timestamp column for optimistic concurrency control is quite a common practice in the SQL realm. While doing an insert, update or delete operation the database checks the Timestamp to see if the row has changed since the last time we retrieved it. More…
Entity Framework let us use the Code First Fluent API in the DbContext to configure how your entities are created. This is done by using the modelbuilder in an override of the OnModelCreate method as explained here. More…
Lets talk strategy for a moment. By default the entity framework uses a database creation strategy called CreateDatabaseIfNotExists. As the name implies this database initializer only creates the database if it’s not on your SQL Express or by a connectionstring specified location. More…
In the previous post we explored the use of the Entity Framework Code First Fluent API to configure properties and specify how the corresponding database is created. You can do this also by using data annotations. More…
Since Entity Framework 4.1 we can use the Code First Fluent API to specify how our database gets created, effectively overriding the default settings. This is also possible with data annotations, but the Fluent API gives us a way to keep this out of our POCO classes and into the data layer. More…
Many Brownfield Architectures (read this book!) provide a database with stored procedures for CUD operations. Or maybe the company we work for has a scary DBA believing his precious little handcrafted stored procedures are a piece of art. More…