public async Task Test()
{
var dbFile = "test.db";
if (File.Exists(dbFile))
{
File.Delete(dbFile);
}
var builder = new DbContextOptionsBuilder();
MyDbContext.Configure(builder, new SqliteConnectionStringBuilder()
{
DataSource = dbFile
}.ConnectionString);
var options = builder.Options;
using (var ctx = new MyDbContext(options))
{
await ctx.Database.MigrateAsync();
}
using (var ctx = new MyDbContext(options))
{
var city = new City {
Id = 1, Location = new Point(12.8, 51.1, 0)
{
SRID = 4326
}, Name = "Just Testing"
};
await ctx.Cities.AddAsync(city);
await ctx.SaveChangesAsync();
}
}