Entity Framework 6 - Knowledge Base (KB)

SQL Physical Connection is not usable

My application moved to a new DEV SQL Server and I'm trying to update my EF model. The database through Management Studio 2014 is able to connect (though truthfully, the connection has had some interruptions today). However, i'm trying to update my EF m...

Create database using code first Entity Framework in SQL Server

I am using code first EF and new to this framework. I am trying to create a database using ...Database.SetInitializer... but it looks like I need SQL Server Express. But I have to create database in SQL Server 2014. How to do this?...Can anybody explain t...

Does EF 6 support SQL Server 2014 Types?

I have an asp.net mvc 5 web api application where I need to convert a ...SqlGeography... instance into a ...DbGeography... instance for querying with Entity Framework 6. I'm using the following code to do so:...SqlGeography geo = SqlGeography.STGeomFromTe...

How to use Scalar Value functions in EntityFramework Query

I have a scalar valued function as below:...CREATE FUNCTION [dbo].[GetCustomersTime] ( @TimeSpanType char(1), @TimeSpan int, @CurrentUtc datetime ) RETURNS datetime AS BEGIN DECLARE @CustomersTime DATETIME; SELECT @CustomersTime = CA...

Could not load file or assembly 'System.Data.DataSetExtensions, Version=4.0.0.0PublicKeyToken=b77a5c561934e089' or one of its dependencies

Error Description:...Could not load file or assembly 'System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The file or directory is corrupted and unreadable. (Exception from HRES...

"Invalid column name" with Entity Framework migrations

I'm having an issue with updating a database with a migration that adds a column to a table and assign values to it. I have reduced the issue to a very simple case....Here's the model:...public class Model { public int Id { get; set; } public int...