Entity Framework 6 - Knowledge Base (KB)

Entity Framework not working with temporal table

I'm using database first entity framework 6. After changing some of the tables in my schema to be temporal tables, I started getting the following error when attempting to insert new data:...Cannot insert an explicit value into a GENERATED ALWAYS column ...

Entity Framework: How to make DataGridView Sortable?

How do I make a DataGridView sort-able when using Entity Framework to pull data from a database?...I'm putting the query into the DataSource of the DataGridView....Dim Query = (From t In DB.interview_task Where t.CONTROL = CONTROL And t.CLIENTCODE = CLIEN...

Cannot connect to Sql Server from Visual Studio (in the process of creating a new Entity Data Model): login failed for user 'sa'

I know there are similar questions, but I have a specific problem....Microsoft Visual Studio (2017)... pops up this error when I try to create a DB connection for my ...Entity Data Model...The attempt to attach to the database failed with the following ...

How to pass parameters to a stored procedure that returns multiple records

How to pass parameters to a stored procedure that returns multiple records using EF6 - ...DbContext... with SQL Server 2016 stored procedure having encrypted columns?...Using EF 6.1.3, SQL Server 2016 - AlwaysEncrypted (deterministic)...There are a ...few...