How to insert or update large data into varchar(max) using EF 6

How do I set a column in SQL Server to varchar(max) using ASP.net EF Codefirst Data Annotations?

I've been searching around the web trying to figure out the right syntax to have Entity Framework Code First create my table with a column: varchar(max)....This is what I have. By default this creates varchar(128). How do I create varchar(max)?...I have tried [MaxLength] without success....Any help would be appreciated. Thanks!...[Column(TypeName =...

Can't update database using EF Migrations after updating to EF 6.0.0-alpha

OK. I have found the solution. It appears that EF expects the Primary Key constraint of ...__MigrationHistory... table to have the name ...PK_dbo.__MigrationHistory.... but it is ...PK___MigrationHistory.......So the following sql statements will do the trick....ALTER TABLE __MigrationHistory drop CONSTRAINT PK___MigrationHistory ALTER TABLE __Migr...

Streaming varbinary(max) data using Entity Framework 6

A bit late maybe - but context.Database.ExecuteSqlCommand accepts streams as parameters, i.e...var id = 1234; var blobStream = await someSource.ReadAsStreamAsync(); // obtain some stream db.Database.ExecuteSqlCommand($"UPDATE MyTable set BlobColumn=@p0 where Id=@p1", blobStream, id);

EF Insert entity with large number of new child entities

IMHO You dont need to add parent first in-order to insert child items. You could do that in one shot....You could try this in EF 5 ...AddRange... is only available in ...EF 6... or higher....This will not insert the item in bulk it will generate the query and insert at one shot...Ef bulk insertion reference...Another reference...public bool InsertP...

Updating the Record with EntityState.Modified but its inserting the new row rather than update

This is happening because Entity Framework is "unaware" of this entity of yours. You are passing just a view model and even though you know it has a PK or FK, there's no way EF knows what to do, so it creates a new one. See that you create a ...new Product()...? This line, creates a new Product and since it is new, EF will treat its state as Added....

EF6 data context throws stackoverflow exception after SqlBulkCopy insrt large data

Ok, problem solved, just in case someone else would face a similar error, I will share my solution....I have modified the T4 template to enable the EDM to produce entities from my database that:...Implement the INotifyPropertyChanged....Apply Data Validation by implementing the INotifyDataErrorInfo and using DataAnnotations by checking validation r...

Specify max length attribute to match varchar(max)

I have a model like so:...public int Id { get; set; } [Required] [StringLength(50, MinimumLength = 3)] public string Title { get; set; } [Required] [StringLength(50, MinimumLength = 3)] public string Slug { get; set; } [Required] [StringLength(100, MinimumLength = 3)] public string Body { get; set; } ...As you can see for the ...Body..., I set a...

EntityFramework insert speed is very slow with large quantity of data

You already got rid of the ChangeTracker problem by disabling AutoDetectChanges....I normally recommend using one of theses solutions:...AddRange over Add ...(Recommended)...SET AutoDetectChanges to false...SPLIT SaveChanges in multiple batches...See: ...http://entityframework.net/improve-ef-add-performance...Making multiple batches won't really im...

"Sequence contains no matching element" setting HasColumnType("varchar") in EF Mappings using Effort

I figured what it was. Turns out that I was using ...Effort... library which does not support some Column Types as pointed out by @Balah. I used his technique to bypass the entity mapping configuration when coming from my Memory Context: ...Effort (EF Unit Testing) giving errors

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

I have used Entity Framework to insert data into SQL tables....For larger number of records, instead of ...Add()..., I have used ...AddRange()... and called ...SaveChanges()... later....It's still taking too much time to insert records - are there any solutions to increase the speed? ..._Repository.InsertMultiple(deviceDataList); await _Repository...