Microsoft.EntityFrameworkCore.DbUpdateException from PRO MVC.CORE 2 by Adam Freeman

-1

I'm reading PRO MVC CORE 2 by Adam Freeman and following the Sports Store project. However, I'm getting this error when i try to make my order:

error

Microsoft.EntityFrameworkCore.DbUpdateException
  HResult=0x80131500
  Message=An error occurred while updating the entries. See the inner exception for details.
  Source=Microsoft.EntityFrameworkCore.Relational
  StackTrace:
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(Tuple`2 parameters)
   at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList`1 entries)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
   at SportsStore.Models.EFOrderRepository.SaveOrder(Order order) in C:\Users\Mateusz\source\repos\SportsStore\SportsStore\Models\EFOrderRepository.cs:line 27

Inner Exception 1:
SqlException: Invalid column name 'Shipped'.

    public EFOrderRepository(ApplicationDbContext ctx)
    {
        context = ctx;
    }

    public IQueryable<Order> Orders => context.Orders.Include(o => o.Lines).ThenInclude(l => l.Product);





    public void SaveOrder(Order order)
        {
            context.AttachRange(order.Lines.Select(l => l.Product));
            if (order.OrderID == 0)
            {
                context.Orders.Add(order);
            }
            context.SaveChanges();
        }
    }
}

This is my database currently, I don't know why it doesn't have the Shipped column.

enter image description here

c#
entity-framework-core
asked on Stack Overflow Nov 3, 2018 by Mateusz Cym • edited Nov 3, 2018 by Camilo Terevinto

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0