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)

52 results in tag: sql-server-2008

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

How do you use Linq to ADO.NET entity framework to do full text search (FTS)?

Now that SQL Server 2008 has full text search built in. I'm looking to use it to power my website's search. I'm also looking at using ADO.NET entity framework for my ORM but I was wondering how do you do full text search (FTS) with Linq to ADO.NET entity ...
c# entity-framework full-text-search linq-to-entities sql-server-2008
asked by ajma

What exactly is datetime2?

I´ve got this in a INSERT statment to MSSQL 2008...System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
.net c#-3.0 entity-framework sql sql-server-2008
asked by Glenn

Entity Framework with a (SQL Server) xml column

Has anyone tried to use xml typed columns with Entity Framework ? The entity returns a string. ...Will the next version of Entity Framework support XElement types when the table column is of type XML....Regards.
entity-framework sql-server-2008 xml
asked by Alexandre Brisebois

In the Entity Framework, how do you construct a connection between a table and a view?

I have an Entity Framework model that was generated by the Visual Studio 2008 wizard based on a Sql Server 2008 database. ...The model has a view that logically is joined in a many-to-many relationship with another table through a join table (enforced in...
entity-framework sql-server-2008
asked by Sako73

How to use Entity Framework's GetDate() method

I have a column like this in 1 of my database tables...DateCreated, datetime, default(GetDate()), not null ...I am trying to use the Entity Framework to do an insert on this table like this...... PlaygroundEntities context = new PlaygroundEntities(...
entity-framework sql-server-2008
asked by Rod Johnson

How do I get rid of Error 3002?

Say I have the following table definitions in SQL Server 2008:...CREATE TABLE Person (PersonId INT IDENTITY NOT NULL PRIMARY KEY, Name VARCHAR(50) NOT NULL, ManyMoreIrrelevantColumns VARCHAR(MAX) NOT NULL) CREATE TABLE Model (ModelId INT IDENTITY NOT N...
.net-3.5 entity-framework linq-to-entities sql-server-2008
asked by Andrew

When utilizing entity framework with Visual Studio 2010.net 4.0, you get a 'datetime2' issue.

Getting this error:...System.Data.SqlClient.SqlException : The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value....My entity objects all line up to the DB objects....I found only a single reference to this erro...
c# entity-framework sql-server sql-server-2008
asked by KevinDeus

SQL Server 2008 Performance Issues with Entity Framework 4

I'am developing a software based on Entity Framework to handle data in a MS SQL Server 2008 database....[Trouble 1]...I've just tried to insert some small data (...about 2 Mb...) from my progam to the database : the performance are very bad ! It takes ...
c# entity-framework performance sql-server-2008
asked by Patrice Pezillier

Entity Framework data type for document storage in SQL Server 2008.

I'm trying to store a document in SQL Server 2008 using the Entity Framework....I believe I have the code for doing this completed. The problem I'm now facing is which Data Type to use in SQL Server and in my entity model....'Image' was my first choice, b...
document entity-framework sql-server-2008 store types
asked by awj

How can I make DbSet.Add() faster?

I have to import about 30k rows from a CSV file to my SQL database, this sadly takes 20 minutes....Troubleshooting with a profiler shows me that ...DbSet.Add is taking the most time, but why?...I have these Entity Framework Code-First classes:...public cl...
c# entity-framework performance sql-server-2008
asked by Tamara Wijsman

How can I use Entity Framework Code First CTP 5 to store images?

I'm just trying to figure out if there is a simple way to store and retrieve binary (file) data using EF Code First CTP 5? I would really like it to use the FILESTREAM type, but I'm really just looking for some way to make it work.
.net ef-code-first entity-framework sql-server-2008
asked by Max Schmeling

This Command is already paired with an open DataReader in Entity Framework.

I am using Entity Framework and occasionally i will get this error. ...EntityCommandExecutionException {"There is already an open DataReader associated with this Command which must be closed first."} at System.Data.EntityClient.EntityCommandDefinition....
entity-framework linq sql-server-2008
asked by Sonic Soul

Incredibly similar query in Entity Framework

My SQL query against a particular view returns me 3 different rows.... select * from vwSummary where vidate >= '10-15-2010' and vidate <= '10-15-2010' and idno = '0330' order by viDate ...But if i run the same query through my entity framework, I get 3...
c# duplicates entity-framework sql-server-2008
asked by franklins

SQL Server 2008 violated the multiplicity restriction - CodeFirst

I'm working to solve a very tedious problem. I have a class called Nation and a class called NationAlly...public class Nation { public int ID {get; set;} public int name {get;set;} public List<NationAlly> NationAllies {get;set;} } public c...
code-first entity-framework sql-server-2008
asked by Francesco

'server' is an unsupported keyword.

I've been trying to edit my connection string for uploading my website to a server.... I am not really experienced with this. I got this exception: the Keyword not supported: 'server'.... Here is my connection string:...<add name="AlBayanEntities" connect...
ado.net asp.net connection-string entity-framework sql-server-2008
asked by Evanescence

SQL Exception in Entity Framework: The given value is not a valid instance of the data type float.

I have an application using the Entity Framework with a SQL Server 2008 (Express) database. I'm getting an intermittent error while doing an update to an entity in the database which indicates that 'the supplied value is not a valid instance of data type ...
entity-framework sql-server-2008 types
asked by John

Using Visual Studio to get the database name from a SQL Server Express database

I'm currently using this connection string to attach to my database that I created in Visual Studio:...Data Source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Database1.mdf;User Instance=true ...I'm trying to host the site with I...
entity-framework iis-7.5 sql-server sql-server-2008 sql-server-express
asked by RandomEngy

Row size exceeds the maximum row size of 8060 in Entity Framework.

I have an entity with a binary datatype and a corresponding ...varbinary(max)... column in SQL Server. EF creates this:...CREATE TABLE [dbo].[Attachments] ( [Id] INT IDENTITY(1,1) NOT NULL, [FileName] NVARCHAR(255) NOT NULL, [Attachment] VARB...
entity-framework sql-server sql-server-2008
asked by Richard

"CREATE DATABASE permission refused in database'master'," says EF Code First.

I just want to quickly spin up the default database in my development environment....How is the easiest way to get around this problem?
c# ef-code-first entity-framework sql-server-2008
asked by user880954

Page 1 of 3
  • 1
  • 2
  • 3
  • »

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!