We finally got it – native support for SqlSever temporal tables in Entity Framework Core. Among others this is the most requesting feature in EF 6. Let’s see what it tastes like…
By Mirek on (tags: Code First, EF, ef core, Entity Framework, SQL Server, Temporal Tables, categories: architecture, code)In this post I’ll show you simple script that can be used to clear all data from table with history versioning using temporal table.
By Mirek on (tags: SQL Server, Temporal Tables, categories: code)A time ago I wrote a post about enabling support for SqlServer Temporal tables in EF Core. Then it was EF Core 2.1. Let’s see what has changed during that time and what we can do today with EF Core 5 in terms of Temporal table support.
By Mirek on (tags: EF, Entity Framework, .Net 5, SQL Server, Temporal Tables, categories: architecture, code)Although SQL Server Temporal Tables feature is not natively supported in Entity Framework Core, there is a way you can still use it together with EF Core. Read on to see how we can, quite nicely, integrate it with the Entity Framework.
By Mirek on (tags: Entity Framework, SQL Server, Temporal Tables, categories: code)A time ago I have been writing about the Sql Server application roles, what are the benefits of using them and what are the limitations when we want to incorporate the Entity Framework to use application role. Today I will show you how to workaround those limitations with new Entity Framework facility introduced in version 6 of the framework.
By Mirek on (tags: Application Role, Entity Framework, SQL Server, categories: architecture, code)The XML data type allows storing a xml content in our SQL Server database. The great feature is that we can also attach an XSD schema to it and have the xml content automatically validated. Here I am going to show you how to set it up together with Entity Framework Code First.
By Mirek on (tags: Entity Framework, SQL Server, XML, XSD, categories: architecture, code)Sql Server Application Role is a way to control access to the database for specific applications. It simply grants a access to a program that provides application role credentials, not for the user login that is used to connect to a database.
By Mirek on (tags: Application Role, Entity Framework, SQL Server, categories: architecture)