zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

9 results in tag: sql-server-2005

Using SQL Server 2008 and SQL Server 2005 and date time

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...
datetime datetime2 entity-framework sql-server-2005 sql-server-2008
asked by Monroecheeseman

Entity framework and VARBINARY

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...
asp.net c# entity-framework sql-server-2005
asked by Marcus L

Entity Framework and SQL Server View

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...
.net-3.5 entity-framework primary-key sql-server-2005 sql-view
asked by Sergio Romero

Multiple Versions of SQL Server using Entity Framework in a single ASP.NET application

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...
entity entity-framework sql-server-2000 sql-server-2005
asked by Ian B

.NET Entity Framework and transactions

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...
.net entity-framework sql-server-2005
asked by sicknote

SQL Profiler not showing inserts/deletes/updates

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...
entity-framework sql sqlprofiler sql-server-2005
asked by Cynthia

Entity framework: StoreGeneratedPattern="Computed" property

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....
ado.net-entity-data-model c# entity-framework sql-server-2005
asked by ebattulga

What causes "Incorrect syntax near <stored procedure name>" in EF Code First and SQL 2005?

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...
code-first ef-code-first entity-framework sql-server-2005 stored-procedures
asked by Dan Mork

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'...
asp.net-core-mvc entity-framework entity-framework-6 sql-server-2005
asked by gadgetguy

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!