Save a long string in SQL database using Entity Framework

entity-framework sql-server

Question

I'm trying to save the contents of a website to my database using Entity Framework. However, when the length of the HTML > 4000, I get these validation errors:

A first chance exception of type 'System.Data.Entity.Validation.DbEntityValidationException' occurred in EntityFramework.DLL WebDev.WebServer40.exe Information: 0 : Property: RawData Error: The field RawData must be a string or array type with a maximum length of '4000'.

Any idea how to get around this? RawData is being created as NVARCHAR(4000) but a better type would be TEXT. Can I force that somehow?

Thanks!

1
4
10/18/2011 4:22:57 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The TEXT data type has been deprecated in favor of NVARCHAR(MAX), I would use that to save yourself refactoring down the road.

http://technet.microsoft.com/en-us/library/bb510662.aspx

SQL CE doesn't support NVARCHAR(MAX) so it limits your strings to NVARCHAR(4000)

If it is possible to use SQL Server 2008, Entity Framework will generate NVARCHAR(MAX) columns for you from your strings.

2
10/20/2011 3:40:27 AM

Popular Answer

I'm using SQL CE 4.0 and having the very same problem. I managed to solve it using the following DataAnnotation (i like annotations :) )

public class Page
    {
        [Key]
        public int PageId { get; set; }

        [MaxLength]
        public string Content { get; set; }
    }

Now i can save whatever content in the Content property!

Savvas Sopiadis

Related Questions

Converting String to Long ...in LINQ to Entity Framework using a MySQL adaptor

I have a table with a column of type ...varchar... where the majority of rows have numerical looking values, that is, each string contains nothing but the digits 0 through 9....+------+ | n | +------+ | 123 | | 234 | | BLAH | -- This row is an exception to the rule. | 456 | | 789 | +------+...In MySQL, this works: ...SELECT * FROM t WHERE n...
entity-framework linq linq-to-entities mysql type-conversion
asked by Walt Stoneburner

How to make sql membership provider and entity framework work using my database?

I have .NET MVC 3 project where I use sql membership provider and entity framework....I've created new database on my SQL server and created all objects for membership provider using ...aspnet_regsql.exe..., I've changed my connection string and it works fine....Now I want to use entity framework for db interaction. I'm using Code-First so I create...
.net asp.net-membership asp.net-mvc connection-string entity-framework
asked by Burjua

Using Entity framework with SQL Server 2012 (local *.mdf database)

Please check the application has access to .mdf file location. If your application resides in "myDocuments" etc type of folders, the application may not have access to it by default.
asp.net-mvc c# entity-framework sql-server
asked by testuser

Save and retrieve image (binary) from SQL Server using Entity Framework 6

Convert the image to a ...byte[]... and store that in the database....Add this column to your model:...public byte[] Content { get; set; } ...Then convert your image to a byte array and store that like you would any other data:...public byte[] ImageToByteArray(System.Drawing.Image imageIn) { using(var ms = new MemoryStream()) { imag...
binary bitmap c# entity-framework
asked by JensB

Saving AutoMapper mapped Collections of Entities using Entity Framework

I have the following Entity Framework Entities:...public class Region { public int RegionId { get; set; } // Primary Key public string Name { get; set; } public virtual ICollection<Country> Countries { get; set; } // Link Table } public class Country { public int CountryId { get; set; } // Primary Key public string Name { get; s...
.net automapper c# entity-framework entity-framework-6
asked by Muhammad Rehan Saeed

Using SqlQuery<Dictionary<string, string>> in Entity Framework 6

I'm trying to execute a SQL query in EF 6. The ...select... query returns two string columns, e.g. ...select 'a', 'b'..., and can have any number of rows....I'd like to map the result to a dictionary, but I can't get ride of the following error....Error 1 Cannot implicitly convert type 'System.Data.Entity.Infrastructure.DbRawSqlQuery>' to 'Syste...
.net c# dictionary entity-framework sql
asked by Akbari

Entity Framework and SQL Server database connection string

I have worked with EF for a while now and i have always used LocalDb's for storing data. I want to start working with SQL Server databases instead but I'm having some issues setting up the connection string....https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx#sse...https://www.connectionstrings.com/...and looked over google but none ...
c# connection-string database entity-framework sql-server
asked by Dimitri

Disable conversion between VARCHAR and NVARCHAR when using Entity Framework over an existing SQL server database

The default data type for ...string... columns is ...nvarchar(MAX)..., you don't have the need to set data type in your columns for changing to ...NVARCHAR(MAX).... Ef has default conventions that Specify it. ...here... is explained for knowing conventions....if you want config generally convention for your models, you can do this:...public class D...
.net entity-framework entity-framework-6 sql sql-server
asked by Soheil Alizadeh

Searching for multiple strings using single database query with entity framework and LINQ

Alternative solution: use the EF 6.2 ...Like...:....Where(x => stringsToSearchFor.Any(s => DbFunctions.Like(x.name, $"%{s}%"))) ...Here's the documentation for ...DbFunctions.Like....
c# entity-framework entity-framework-6 linq linq-to-sql
asked by V0ldek

Using Entity Framework with Multiple Databases and Providers in the Same Project (SQL Server and MySql)

Background:...I have an application (both web forms and console) that easily accesses multiple SQL Server databases using Entity Framework code first with no problems. I can switch back and forth between contexts with no errors. Now I'm trying to add in a new MySql database (different provider), but if I switch from one context to another, I get th...
.net c# entity-framework entity-framework-6 mysql-connector
asked by Mike

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow