EF Core Update-Database throws System.NullReferenceException

Question

I'm trying to test making SQLite database using EF.Core. Despite all my effort to get it work, it still not working as intended and i don't know why. The Add-Migration command works ok but then when i try to Update-DataBase it throws System.NullReferenceException. Anyone has an idea why is that? Below you can see the code and the exception.

public class TestModel
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public string Name { get; set; }
    }

private const string ConnectionString = "Data Source = AutoHome.db";

        public DbSet<TestModel> testModels { get; set; }
        protected override void OnConfiguring(DbContextOptionsBuilder options)
        {
            options.UseSqlite(ConnectionString);
            base.OnConfiguring(options);
        }

PM> Update-DataBase Build started... Build succeeded. System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Data.Sqlite.SqliteConnection.Open() at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteDatabaseCreator.Exists() at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0() at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action) Object reference not set to an instance of an object. PM>

DreamNet · Accepted Answer · 2019-12-05 21:16:10Z

12

It seems that it is an issue with Microsoft.Data.Sqlite.Core. I just added a reference Microsoft.Data.Sqlite and everything works right now.

OBS!!!

There is already an open ticket about this GitHub/EF/Issues

answered Dec 5, 2019 at 21:16

DreamNet

6273 gold badges8 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mojoblanco Over a year ago

Worked for me too

CodingYourLife Over a year ago

Just wanted to add that your problems might not end there. After troubleshooting further and further I ran into this issue: SQLite does not support this migration operation ('DropColumnOperation'). For more information, see go.microsoft.com/fwlink/?LinkId=723262 - which basically means Migrations aren't fully supported or at least compatible to MSSQL unless you tend to drop columns from time to time.

Collectives™ on Stack Overflow

EF Core Update-Database throws System.NullReferenceException

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related