TypeInitializationException occured in 'System.Data.Entity.dll' - type initializer 'ExtentPlaceholderCreator'

asp.net-mvc c# entity-framework

Question

Running Visual Studio 2013 ASP.NET MVC 4 Entity Framework (EF) 5

After running my project, when navigating to the 'create' page. I try to post information to local mysql database, this exception is thrown...

An exception of type 'System.TypeInitializationException' occurred in System.Data.Entity.dll but was not handled in user code

Additional information: The type initializer for 'ExtentPlaceholderCreator' threw an exception.

at this location in my AuctionController.cs file

[HttpPost]
public ActionResult Create([Bind(Exclude="CurrentPrice")]Models.Auction auction)
{
    if (ModelState.IsValid)
    {
        // Save to the database
        var db = new MvcAuction.Models.AuctionsDataContext();
        db.Auctions.Add(auction);

        db.SaveChanges();

        return RedirectToAction("Index");
    }

    return Create();
}

Click here to see screenshot of error

This is my Database Context class file:

 namespace MvcAuction.Models
{
    public class AuctionsDataContext : System.Data.Entity.DbContext
    {
        public System.Data.Entity.DbSet<Auction> Auctions { get; set; }
    }
}

I think the issue is going wrong in my web.config file:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcAuction-20121126103244;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcAuction-20121126103244.mdf" providerName="System.Data.SqlClient" />
    <add name="MvcAuction.Models.AuctionsDatacontext" connectionString="Data Source=(LocalDb)\v11.0;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\MvcAuction.Models.AuctionsDatacontext.mdf" providerName="System.Data.SqlClient" />
  </connectionStrings>

I am following this tutorial: https://www.lynda.com/ASP-NET-tutorials/Persisting-data-Entity-Framework-code-first/109762/120303-4.html?autoplay=true

The teacher is using Visual Studio 2012, his works fine:D

I do not know why this is holding me up. Nor what exactly it is asking, to my knowledge there were no breaking changes from Visual Studio 2012 to 2013.

1
1
10/17/2016 5:58:27 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Ok I found the solution here:

Entity Framework cannot update database

First of all, if I would have post the entire stack trace it would have been more helpful: 

System.TypeInitializationException was unhandled by user code
  HResult=-2146233036
  Message=The type initializer for 'ExtentPlaceholderCreator' threw an exception.
  Source=System.Data.Entity
  TypeName=ExtentPlaceholderCreator
  StackTrace:
       at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.GetPropagatorResultForPrimitiveType(PrimitiveType primitiveType, PropagatorResult& result)
       at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.Visit(EdmMember node)
       at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.CreateEntitySetPlaceholder(EntitySet entitySet)
       at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.CreatePlaceholder(EntitySetBase extent, UpdateTranslator parent)
       at System.Data.Mapping.Update.Internal.Propagator.Visit(DbScanExpression node)
       at System.Data.Common.CommandTrees.DbScanExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
       at System.Data.Mapping.Update.Internal.UpdateExpressionVisitor`1.Visit(DbExpression expression)
       at System.Data.Mapping.Update.Internal.Propagator.Visit(DbProjectExpression node)
       at System.Data.Common.CommandTrees.DbProjectExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
       at System.Data.Mapping.Update.Internal.Propagator.Propagate(UpdateTranslator parent, EntitySet table, DbQueryCommandTree umView)
       at System.Data.Mapping.Update.Internal.UpdateTranslator.<ProduceDynamicCommands>d__44.MoveNext()
       at System.Linq.Enumerable.<ConcatIterator>d__58`1.MoveNext()
       at System.Data.Mapping.Update.Internal.UpdateCommandOrderer..ctor(IEnumerable`1 commands, UpdateTranslator translator)
       at System.Data.Mapping.Update.Internal.UpdateTranslator.ProduceCommands()
       at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
       at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
       at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
       at System.Data.Entity.Internal.InternalContext.SaveChanges()
       at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
       at System.Data.Entity.DbContext.SaveChanges()
       at MvcAuction.Controllers.AuctionsController.Create(Auction auction) in c:\Users\ZOHNPJ\Documents\Ex_Files_ASP.NET_MVC4_EssT\Ex_Files_ASP.NET_MVC4_EssT\Exercise Files\06_04\MvcAuction\MvcAuction\Controllers\AuctionsController.cs:line 80
       at lambda_method(Closure , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.InvokeSynchronousActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
       at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
       at System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33()
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49()
  InnerException: System.Reflection.TargetInvocationException
       HResult=-2146232828
       Message=Exception has been thrown by the target of an invocation.
       Source=mscorlib
       StackTrace:
            at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
            at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
            at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
            at System.Data.SqlClient.SqlSpatialServices.GeometryFromText(String geometryText)
            at System.Data.Spatial.DbGeometry.FromText(String wellKnownText)
            at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator.InitializeTypeDefaultMap()
            at System.Data.Mapping.Update.Internal.Propagator.ExtentPlaceholderCreator..cctor()
       InnerException: System.EntryPointNotFoundException
            HResult=-2146233053
            Message=Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'.
            Source=Microsoft.SqlServer.Types
            TypeName=""
            StackTrace:
                 at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap)
                 at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive()
                 at Microsoft.SqlServer.Types.SqlGeometry..ctor(GeoData g, Int32 srid)
                 at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid)
                 at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid)
                 at Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
                 at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s)
            InnerException:

Notice the last InnerException: System.EntryPointNotFoundException. After researching this error (I didn't see it earlier) I found this code to add to my web.config file and it worked!

 <runtime>
  <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <dependentAssembly>
      <assemblyIdentity name="Microsoft.SqlServer.Types" publicKeyToken="89845dcd8080cc91" />
      <bindingRedirect oldVersion="1.0.0.0-11.0.0.0" newVersion="10.0.0.0" />
    </dependentAssembly>
  </assemblyBinding>
</runtime>

I believe it has something to do with an sql update breaking something. This article & comments were also helpful: http://www.networksteve.com/forum/topic.php/Entity_framework_can't_make_updates_in_db_(missing_entry_point_S/?TopicId=97401&Posts=2

p.s: I am very new to stackoverflow, if this question and answer should be discarded in favor of the one I referenced that's fine.

11
5/23/2017 12:23:03 PM

Related Questions

EntityFramework.dll vs System.Data.Entity.dll -- ambiguity

I wonder what EntityFramework.dll and System.Data.Entity.dll have in common and what they have different? My project references System.Data.Entity.dll (June CTP) to leverage code first model and everything works fine. ...Now I wish to use Code First Migrations tool, and it requires EntityFramework.dll that I also have to add to my project. However,...
.net ef-code-first entity-framework
asked by Alex Avrutin

Why am I getting a NullReferenceException in System.Data.Entity.dll (Entity Framework)?

I have a ...List<State>... of ...State... entity objects, and each ...State... object has collections of other objects, such as ...Licenses..., ...Taxes..., ...Bonds..., etc...There's also a collection for ...ExpiredObjects..., which is a list of any object which is expired and needs to be renewed. For some reason, this property is giving me a ...N...
c# entity-framework wpf
asked by Rachel

An unhandled exception of type 'System.TypeInitializationException' occurred in EntityFramework.dll

I was trying to learn ...Entity Framework... and ...SQLite... using ...this tutorial.... However, I get an error....The error thrown is:...An unhandled exception of type 'System.TypeInitializationException' occurred in EntityFramework.dll...Additional information: The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception..
.net c# entity-framework sqlite
asked by Joe Slater

System.InvalidCastException: Unable to cast object of type 'System.Int32' to type 'System.String'

I've been stuck trying to debug this issue. I believe the error Is occurring when I am trying to populate a drop down list.... IEnumerable<Customer> values = db.Customers.SqlQuery("SELECT * FROM Customer").ToList().Cast<Customer>(); IEnumerable<SelectListItem> items = from value in values select new SelectListItem { Text =...
asp.net-mvc entity-framework
asked by kayze

Unable to cast Anonymous Type from 'System.Linq.IQueryable' to 'System.Data.Entity.Core.Objects.ObjectQuery'

The following query was working well with EF5 but gives me error with EF6. I use DbContext and CodeFirst....Error raised with EF6:...Unable to cast the type 'System.Linq.IQueryable...1[[<>f__AnonymousType5...4[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Int32, mscorlib, Version=4.0.0.0, Cultur...
c# entity-framework entity-framework-6 linq linq-to-entities
asked by Dan

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

Cannot implicitly convert type System.Data.Entity.Core.Objects.ObjectResult to System.Data.Objects.ObjectResult

I am trying to update an EDMX Stored Procedure and I am getting this error:...Cannot implicitly convert type ...System.Data.Entity.Core.Objects.ObjectResult<X>... to ...System.Data.Objects.ObjectResult<X>...I am using Visual Studio 2012.
c# entity-framework
asked by Akira Yamamoto

A first chance exception of type 'System.Data.Entity.Core.EntityCommandExecutionException' occurred in EntityFramework.SqlServer.dll

I am trying to call a stored procedure using entity framework 6. I get an error on the output message....A first chance exception of type 'System.Data.Entity.Core.EntityCommandExecutionException' occurred in EntityFramework.SqlServer.dll... using (var context = new PartnerPortalEntities2()) { var outputParameter = new ObjectParameter("result",...
asp.net-mvc-5 entity-framework-6
asked by Prady

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

My WPF application works fine on Windows 7, but throws the above error when running on Windows XP. I am using ENtity Framework 6.1.1...App.xaml is ...<Application.Resources> <main:MainConverter x:Key="MainVerter"/> <Style x:Key="DetailHead1Style" TargetType="TextBlock"> <Setter Property="FontSize" Value="20"/> <Setter Proper...
c# entity-framework windows-xp-sp3 wpf
asked by Kirsten Greed

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

I have ...ASP.Net MVC... site....Technology Stack ...ASP.Net 4.6...C#.Net...EF 6...MySQL -Database...While I am trying to generate the database using ...Nuget... command:-...Enable-Migrations -force ...I am getting the below exception...The type initializer for 'System.Data.Entity.Migrations.DbMigrationsConfiguration`1' threw an exception....Follow...
asp.net asp.net-mvc c# entity-framework mysql
asked by Kgn-web

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