Error while executing db.Database.Migrate(): Incorrect syntax near the keyword 'NOT'

asp.net-core asp.net-core-mvc c# entity-framework-core

Question

Here's my Dataseeder class:

using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using StackStore.Data;
using System.Collections.Generic;
using System.Linq;

namespace StackStore.Models
{
    // http://stackoverflow.25lm.com/questions/34536021/seed-initial-data-in-entity-framework-7-rc-1-and-asp-net-mvc-6
    public static class DataSeeder // EntityFramework 7.0 DataSeeder
    {
        // TODO: Move this code when seed data is implemented in EF 7

        /// <summary>
        /// This is a workaround for missing seed data functionality in EF 7.0-rc1
        /// More info: https://github.com/aspnet/EntityFramework/issues/629
        /// </summary>
        /// <param name="app">
        /// An instance that provides the mechanisms to get instance of the database context.
        /// </param>
        public static async void SeedData(this IApplicationBuilder app)
        {
            var db = app.ApplicationServices.GetService<ApplicationDbContext>();

            //Caution: Clear all the tables in the database first.
            db.Database.Migrate();


            db.SaveChanges();
        }
    }
}

Basically, the error hits at db.Database.Migrate() and it throws me this chunk which I have completely no idea about. I've been trying my best to look for the source of the error but to no avail. Even attempting to check the definitions of the migrate method.

Here's the error:

System.Data.SqlClient.SqlException was unhandled by user code
  Class=15
  HResult=-2146232060
  LineNumber=7
  Message=Incorrect syntax near the keyword 'NOT'.
  Number=156
  Procedure=""
  Server=NIXHOLAS\SQLEXPRESS
  Source=Core .Net SqlClient Data Provider
  State=1
  StackTrace:
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, String executeMethod, IReadOnlyDictionary`2 parameterValues, Boolean openConnection, Boolean closeConnection)
       at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues, Boolean manageConnection)
       at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
       at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
       at StackStore.Models.DataSeeder.<SeedData>d__0.MoveNext() in C:\Users\nixho\StackStore\src\StackStore\Models\DataSeeder.cs:line 36
  InnerException: 


  Microsoft.EntityFrameworkCore.DbUpdateException was unhandled by user code
  HResult=-2146233088
  Message=An error occurred while updating the entries. See the inner exception for details.
  Source=Microsoft.EntityFrameworkCore.Relational
  StackTrace:
       at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.<ExecuteAsync>d__32.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.<ExecuteAsync>d__1.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<SaveChangesAsync>d__47.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<SaveChangesAsync>d__45.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.EntityFrameworkCore.DbContext.<SaveChangesAsync>d__30.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.AspNetCore.Identity.EntityFrameworkCore.RoleStore`5.<SaveChanges>d__14.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.AspNetCore.Identity.EntityFrameworkCore.RoleStore`5.<CreateAsync>d__15.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at Microsoft.AspNetCore.Identity.RoleManager`1.<CreateAsync>d__30.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
       at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
       at StackStore.Models.DataSeeder.<SeedData>d__0.MoveNext() in C:\Users\nixho\StackStore\src\StackStore\Models\DataSeeder.cs:line 44
  InnerException: 
       Class=16
       HResult=-2146232060
       LineNumber=2
       Message=Invalid object name 'AspNetRoles'.
       Number=208
       Procedure=""
       Server=NIXHOLAS\SQLEXPRESS
       Source=Core .Net SqlClient Data Provider
       State=1
       StackTrace:
            at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__107_0(Task`1 result)
            at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
            at System.Threading.Tasks.Task.Execute()
         --- End of stack trace from previous location where exception was thrown ---
            at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
            at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
            at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__20.MoveNext()
         --- End of stack trace from previous location where exception was thrown ---
            at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
            at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
            at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.<ExecuteAsync>d__32.MoveNext()
       InnerException:
1
1
9/9/2016 2:29:15 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I have an entity relationship syntax error. ApplicationDbContext has a few relationship issues that I did not resolve.

Basically, please check your own ApplicationDbContext before you migrate.

0
9/25/2016 4:46:49 AM

Related Questions

EF6 Beta1 - db.Database.CreateIfNotExists(); doesn't create the database anymore after enabling the migration

EF team responded me that it's a new changes in EF. Please refer to this thread. ...https://entityframework.codeplex.com/discussions/450998
entity-framework entity-framework-6
asked by Michael Sync

`Collection was modified; enumeration operation may not execute` error while reading data

This problem happens if you add/remove to a collection while iterating over it:...// throws "collection was modified" error foreach (var item in myCollection) { myCollection.Remove(item); } // to fix this problem, iterate over a copy of the collection whose count does not change var fixedSize = myCollection.ToArray(); foreach (var item in fixe...
c# entity-framework entity-framework-6
asked by Georg Patscheider

How and where to call Database.EnsureCreated and Database.Migrate?

I think this is an important question and should be well answered!...What is Database.EnsureCreated?...context.Database.EnsureCreated()... is new EF core method which ensures that the database for the context exists. If it exists, no action is taken. If it does not exist then the database and all its schema are created and also it ensures it is com...
asp.net asp.net-mvc entity-framework entity-framework-core
asked by Bassam Alugili

Error : Cannot execute this command because Microsoft.EntityFrameworkCore.Design is not installed

I had a similar issue I could not run add-migration from package manager console; it produced the same error. In my case lacking ..."type": "platform"... for .netcore.app was the issue. I had to change ..."Microsoft.NETCore.App": "1.1.0", "Microsoft.EntityFrameworkCore.Design": "1.1.0", "Microsoft.EntityFrameworkCore.Tools": "1.1.0-preview4-final" ...
c# entity-framework entity-framework-core
asked by flexxxit

Incorrect syntax near 'MERGE' Entity Framework Core

Don't do the AddRange. Just add a ClientId to the Phone entity (assuming that one phone will only belong to one client). The phones will be then saved when adding a Client....public class Client { public int Id { get; set; } public string Name{ get; set; } public string Lastname{ get; set; } public int DNI { get; set; } public List<Phones> Phones{ ...
asp.net-core c# entity-framework-core
asked by joaoruimartins

Code First Update-Database Keyword Not Supported

Use the admin user of your SQL Azure database on the following connection string of the appsettings.json. If you don't know the Admin password, reset the password using instructions provided in ...this... article....{ "Logging": { "IncludeScopes": false, "LogLevel": { "Default": "Warning" } }, "ConnectionStrings": { "Development": "...
azure-sql-database connection-string entity-framework-core
asked by Alberto Morillo

Entity Framework DB updating but DB context not showing updates

Thanks to both Eric J and DevilSuichiro for helping me resolve my issue. The problem was that I should not have been trying to use the same DB context. By retrieving a new DB context instead of trying to reuse the same DB context I was able to verify my test results....Many thanks again.
c# entity-framework entity-framework-6 identityserver4 unit-testing
asked by CLSavill

EF Core SQLite in memory exception: SQLite Error 1: 'near "MAX": syntax error'

I am creating SQLite In Memory database for unit testing:... var connection = new SqliteConnection("DataSource=:memory:"); connection.Open(); try { var options = new DbContextOptionsBuilder<BloggingContext>() .UseSqlite(connection) .Options; // Create the schem...
c# ef-core-2.0 ef-core-2.1 entity-framework-core sqlite
asked by Deivydas Voroneckis

System.Private.CoreLib: Exception while executing function: System.Data.SqlClient: Keyword not supported: 'authentication'

The exception is expected for now, check the ...thread.......SqlClient for .NET Core still does not support using the 'authentication' keyword in the connection string. That will happen when ...this issue... is actually fixed....In order to use AAD in the new version of SqlClient in .NET Core 2.2, customers need to obtain the access token themselve...
.net-core azure azure-functions azure-sql-database entity-framework-core
asked by Jerry Liu

Error migrating to Entity Framework, the table is not updated

when you delete the migrations to create just one you should delete the database because the tables are created and you get that error. The faster solution in this case is delete all migrations folder and database and start all over.
asp.net-core c# ef-migrations entity-framework-core
asked by Elvis Jr

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