protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlite("Filename=TestDatabase.db", options => { options.MigrationsAssembly(Assembly.GetExecutingAssembly().FullName); }); using (SqliteConnection con = new SqliteConnection("Data Source=TestDatabase.db;")) using (Microsoft.Data.Sqlite.SqliteCommand command = con.CreateCommand()) { con.Open(); command.CommandText = "SELECT name FROM sqlite_master WHERE name='Personas'"; var name = command.ExecuteScalar(); if (name != null && name.ToString() == "Personas") { return; } // acount table not exist, create table and insert command.CommandText = "CREATE TABLE Personas (Nombre VARCHAR(50),Apellidos VARCHAR(50),DNI VARCHAR(10),Sexo VARCHAR(10), FechaNacimiento TEXT, Direccion VARCHAR(50),Pais VARCHAR(50), CodigoPostal int)"; command.ExecuteNonQuery(); } base.OnConfiguring(optionsBuilder); }