Entity Framework 6 - Knowledge Base (KB)
52 results for: in tag: sql-server-2008
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...
asked by Monroecheeseman
How do you do full text search (FTS) with Linq to ADO.NET entity framework?
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 ...
asked by ajma
What 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.
asked by Glenn
Using an (Sql Server) xml column with Entity Framework
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.
asked by Alexandre Brisebois
How to create a relationship between table and view in the Entity Framework
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...
asked by Sako73
How to manage GetDate() with Entity Framework
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(...
asked by Rod Johnson
How do I eliminate 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...
asked by Andrew
'datetime2' error when using entity framework in VS 2010 .net 4.0
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...
asked by KevinDeus
Entity Framework 4 : Bad performance with SQL Server 2008
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 ...
asked by Patrice Pezillier
Data Type for storing document in SQL Server 2008 via Entity Framework
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...
asked by awj
How do I speed up DbSet.Add()?
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...
asked by Tamara Wijsman
How to store images using Entity Framework Code First CTP 5?
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.
asked by Max Schmeling
Entity Framework: There is already an open DataReader associated with this Command
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....
asked by Sonic Soul
Unbelievable duplicate in an Entity Framework Query
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...
asked by franklins
Multiplicity constraint violated SQL Server 2008 - 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...
asked by Francesco
Keyword not supported: 'server'
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...
asked by Evanescence
Entity Framework SQL Exception: The supplied value is not a valid instance of 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 ...
asked by John
Getting the database name from a SQL Server Express database in Visual Studio
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...
asked by RandomEngy
Entity Framework - Row size greater than allowable maximum row size of 8060
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...
asked by Richard
EF Code First - {"CREATE DATABASE permission denied in database 'master'."}
I just want to quickly spin up the default database in my development environment....How is the easiest way to get around this problem?
asked by user880954
Page 1 of 3
