EF6 data context throws stackoverflow exception after SqlBulkCopy insrt large data

entity-framework-6 sqlbulkcopy wpf

Question

I have a situation, consider:

  1. SQL Server 2014 Database with table T1.
  2. WPF application that has EF6 to maintain data in table T1.

Application is running OK.

When app starts, if table T1 is empty (0 records), SqlBulkCopy is used to insert 5000 records in T1 allowing triggers to fire and constraints check, the result is:

  1. Table T1 is filled with 5000 records successfully.
  2. All triggers were fired and constraints were checked and non of them being violated.
  3. The problem is, after the SqlBulkCopy.WriteToServer is completed, context.T1 will crash once tried to enumerate it, throwing StackOverfolow exception.

I have tried to initialize the context but no success.

The procedure will succeed in two cases:

  1. If the app is closed and re run, context will read T1 successfully.
  2. If all steps were applied where T1 has at least one record (app is started with non empty T1 table).

What could cause the StackOverflow exception.

1
0
5/25/2016 1:41:51 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

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:

  1. Implement the INotifyPropertyChanged.

  2. Apply Data Validation by implementing the INotifyDataErrorInfo and using DataAnnotations by checking validation rules in Metadata separate class.

That caused the StackOverFlow excepetion.

Disabling the Property Validation solved the problem.

So, Data Validation is not welcomed as SqlBulkCopy while WriteToServer is in progress.

0
5/27/2016 9:07:47 PM

Related Questions

How to generate data context class from entity data model (edmx)?

This is my first time to use Entity Data Model as data access layer....From some example codes, I see people have data context class that inherit from ...DbContext...[file name: FooEntities.Context.tt] public partial class FooEntities : DbContext { // ... } ...when I try to ...Add Code Generation Item... from entity data model (edmx) , I always...
c# entity-framework
asked by Tambunan

Entity framework large data set, out of memory exception

The issue is that when you get data from EF there are actually two copies of the data created, one which is returned to the user and a second which EF holds onto and uses for change detection (so that it can persist changes to the database). EF holds this second set for the lifetime of the context and its this set thats running you out of memory...
c# entity-framework
asked by Not loved

The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception on a Sub Website

I have 2 websites, one is a sub directory of another but is an Application ex: /root & /root/Services...They both use Entity Framework 6.x but the child website is throwing ...The type initializer for System.Data.Entity.Internal.AppConfig' threw an exception... because it appears to be seeing to many entries for the same EF Database Provider becaus...
c# entity-framework entity-framework-6 nuget
asked by Brian

EF6 Type of context 'System.Data.Entity.Core.Objects.ObjectContext' is not supported

I have a new project created using Visual Studio 2013 with an ADO.NET Entity Data Model (EF6)....Now I have to use some Dynamic Data function (like access to MetaTable object), so I add this code:...MetaModel model = new MetaModel(); model.RegisterContext(() => { return ((System.Data.Entity.Infrastructure.IObjectContextA...
asp.net c# entity-framework objectcontext
asked by gidanmx2

the type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception for Windows XP

Is the Q: drive local? If not, try to run the app from a local drive - the error message indicates that there is a security issue preventing you to run from a network folder.
c# entity-framework windows-xp-sp3 wpf
asked by ErikEJ

Exception has been thrown by the target of an invocation thrown when scaffolding a controller

I had more than one ConnectionStrings define. I removed the default and replaced it with the ConstringStrings from my Class Library. Works fine now!...Solution taken from the following post: ...Application can't scaffold items
asp.net-mvc dbcontext entity-framework scaffold
asked by Randell Lamont

DbContext.SaveChanges Method Throw null reference exception while saving data

Solved! Actually the problem is with ...ddlType DataSource..., i just refresh the schema of ...SqlDataSource... for ...ddlType... and the problem vanished. Because i did an update to the database and that's why the ...ddlType... pointing to such reference which wasn't exist anymore and for this reason ...DbContext.SaveChanges... method throwing ...
asp.net c# entity-framework-6
asked by Hamid Waheed

The type initializer for 'System.Data.Entity.Migrations.DbMigrationsConfiguration`1' threw an exception

In Entity Framework ...The type initializer... error is most likely due to malformed ...Web.config... files, like having two or more sections of connection string, or having problem in the connection string itself, such as invalid provider.
asp.net asp.net-mvc c# entity-framework mysql
asked by Ashraf Abusada

Query with large WHERE clause causes timeout exception in EF6 with npgsql

I have a query that looks something like this:...private static IQueryable<MultiframeModule> WhereAllFramesProperties(this IQueryable<MultiframeModule> query, ICollection<Frame> frames) { return frames.Aggregate(query, (q, frame) => { return q.Where(p => p.Frames.Any(i => i.FrameData.ShaHash == frame.FrameData.ShaHash)); }); } ....
c# entity-framework entity-framework-6 npgsql
asked by Sassa

LinQ to SQL throws Stackoverflow exception when using Any()

I'm using a LinQ query that looks like this...public List<TEntity> GetEntities<TEntity>(int[] ids) { var someDbSet = new DbSet<TEntity>(); var resultQ = someDbSet.Where(t => !ids.Any() || ids.Contains(t.ID)); //<= crashing line return resultQ.toList(); } ...It usually works, but for some case when ids size is ~ 7000 items it crashes. ...
c# entity-framework-6 linq linq-to-sql postgresql
asked by ionutnespus

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