Entity Framework 6 - Knowledge Base (KB)

Date time and SQL Server 2008 and SQL Server 2005

I've built a entity framework model against a 2008 database. All works ok against the 2008 database. When I try to update the entity on a 2005 database I get this error. ...The version of SQL Server in use does not support datatype 'datetime2...I speci...

VARBINARY and the Entity Framework

I’m using the .NET entity framework and I’ve got one entity containing a varbinary. Is there an easy way to get the size of the varbinary in the codebehind, efter it’s been retrieved from the database?...I’m thinking there might be some way to get...

View of Entity Framework and SQL Server

For several reasons that I don't have the liberty to talk about, we are defining a view on our Sql Server 2005 database like so:...CREATE VIEW [dbo].[MeterProvingStatisticsPoint] AS SELECT CAST(0 AS BIGINT) AS 'RowNumber', CAST(0 AS BIGINT) AS 'Pr...

Multiple SQL Server versions in a single ASP.NET application utilizing Entity Framework

I am using the Entity Framework in a web application that utilizes SQL server 2000, 2005, and 2008. When I create a new EDMX file using anything other than 2008 (version of the first edmx created) I receive ...error 0172: All SSDL artifacts must target th...

Transactions and the.NET Entity Framework

Being new to the Entity Framework, I'm really rather stuck on how to proceed with this set of issues. On the project I am currently working on, the entire site is heavily integrated with the EF model. At first, the access to the EF context was being contr...

Inserts/deletes/updates are not visible in SQL Profiler.

When I run the profiler while running my application, it only seems to show SELECTs, not INSERTs or anything that changes the database. Yet my database is being updated, so those commands must be being executed. What do I have to do to get it to show upda...

Property StoreGeneratedPattern="Computed" in Entity Framework

I have a ...DateTime... property. I need this property's default value to be ...DateTime.Now.... And then I found out that you can specify an attribute ...StoreGeneratedPattern="Computed"... and set it to ...(getdate())... in SQL. This works successfully....

In EF Code First and SQL 2005, what causes "Incorrect syntax at stored procedure name>"?

The examples for System.Data.Entity.Database.SqlQuery method I've found appear to work well with SQL 2008 R2 but do not appear to work with SQL 2005....This call will work with SQL 2008 R2:...var myEntities = dbContext.Database.SqlQuery<MyEntity>("GetData...

Error ASP.NET Core EF Core and SQL Server 2005: The version of SQL Server in use does not support datatype 'datetime2'

I receive the following exception when attempting to update a database record even though I was passing in the correct datetime values to the controller....System.ArgumentException: The version of SQL Server in use does not support datatype 'datetime2'...