Today we are making EF Core 2.2 Preview 3 available, together with a new preview of our data provider for Cosmos DB and updated spatial extensions for various providers.<\/p>\n
Preview 3 is going to be the last milestone before EF Core 2.2 RTM, so now is your last chance to try the bits and give us feedback if you want to have an impact on the quality and the shape of the APIs in this release.<\/p>\n
Besides the new features, you can help by trying EF Core 2.2 preview 3 on applications that are using third party providers.\u00a0 Although we now have our own testing for this, there might be unforeseen compatibility problems, and the earlier we can detect them, the higher chances we have of addressing them before RTM.<\/p>\n
We thank you in advance for reporting any issues your find on our issue tracker on GitHub<\/a>.<\/p>\n EF Core 2.2 RTM is still planned for the end of the 2018 calendar year, alongside ASP.NET Core 2.2 and .NET Core 2.2.<\/p>\n However, based on a reassessment of the progress we have made so far, and on new information about the work we need to complete 2.2, we are no longer trying to include the following features in the EF Core 2.2 RTM:<\/p>\n The preview bits are available on NuGet<\/a>, and also as part of ASP.NET Core 2.2 Preview 3<\/a> and the .NET Core SDK 2.2 Preview 3<\/a>, also releasing today. If you are want to try the preview in an application based on ASP.NET Core, we recommend you follow the instructions to upgrade to ASP.NET Core 2.2 Preview 3.<\/p>\n The SQL Server and in-memory providers are also included in ASP.NET Core, but for other providers and any other type of application, you will need to install the corresponding NuGet package.<\/p>\n For example, to add the 2.2 Preview 3 version of the SQL Server provider in a .NET Core library or application from the command line, use:<\/p>\n Or from the Package Manager Console in Visual Studio:<\/p>\n For more details on how to add EF Core to your projects see our documentation on Installing Entity Framework Core<\/a>.<\/p>\n The Cosmos DB provider and the spatial extensions ship as new separate NuGet packages. We’ll explain how to get started with them in the corresponding feature descriptions.<\/p>\n Around 69 issues have been fixed<\/a>\u00a0since we finished Preview 2 last month<\/a>. This includes product bug fixes and improvements to the new features. Specifically about the new features, the most significant changes are:<\/p>\n Here is an updated usage example:<\/p>\n In order to use this code with SQL Server, simply install the 2.2 preview 3 version of the Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite <\/strong>NuGet package, and configure your DbContext<\/strong> as follows:<\/p>\n In order to use this code with SQLite, you can install the 2.2 preview 3 version of the Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite<\/strong> and\u00a0Microsoft.EntityFrameworkCore.Sqlite<\/strong>\u00a0packages. Then you can configure the DbContext<\/strong> like this:<\/p>\n Note that the spatial extension for SQLite requires the SpatiaLite library. This will be added as a dependency by the NuGet packages previously mentioned if you are on Windows, but on other systems you will need extra steps. For example:<\/p>\n In order to use this code with the in-memory provider, simply install the NetTopologySuite\u00a0<\/strong>package, and the 2.2 preview 3 version of the Microsoft.EntityFrameworkCore.InMemory<\/strong> package. Then you can simply configure the DbContext<\/strong> like this:<\/p>\n We have made several changes and improvements since preview 2:<\/p>\n We still have some pending work and several limitations to remove in the provider. Most of them as tracked as uncompleted tasks on our task list<\/a>. In addition to those:<\/p>\nEF Core 2.2 roadmap update<\/h2>\n
\n
Obtaining the preview<\/h2>\n
$ dotnet add package Microsoft.EntityFrameworkCore.SqlServer -v 2.2.0-preview3-35497<\/pre>\n
PM> Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 2.2.0-preview3-35497<\/pre>\n
What is new in this preview?<\/h2>\n
Spatial extensions<\/h3>\n
\n
\r\n\/\/ Model class\r\npublic class Friend\r\n{\r\n [Key]\r\n public string Name { get; set; }\r\n\r\n [Required]\r\n public IPoint Location { get; set; }\r\n}\r\n\r\n\/\/ Program\r\nprivate static void Main(string[] args)\r\n{\r\n \/\/ Create spatial factory\r\n var geometryFactory = NtsGeometryServices.Instance.CreateGeometryFactory(srid: 4326);\r\n\r\n \/\/ Setup data in datbase\r\n using (var context = new MyDbContext())\r\n {\r\n context.Database.EnsureDeleted();\r\n context.Database.EnsureCreated();\r\n\r\n context.Add(\r\n new Friend\r\n {\r\n Name = \"Bill\",\r\n Location = geometryFactory.CreatePoint(new Coordinate(-122.34877, 47.6233355))\r\n });\r\n context.Add(\r\n new Friend\r\n {\r\n Name = \"Paul\",\r\n Location = geometryFactory.CreatePoint(new Coordinate(-122.3308366, 47.5978429))\r\n });\r\n context.SaveChanges();\r\n }\r\n\r\n \/\/ find nearest friends\r\n using (var context = new MyDbContext())\r\n {\r\n var myLocation = geometryFactory.CreatePoint(new Coordinate(-122.13345, 47.6418066));\r\n\r\n var nearestFriends =\r\n (from f in context.Friends\r\n orderby f.Location.Distance(myLocation) descending\r\n select f).Take(5);\r\n\r\n Console.WriteLine(\"Your nearest friends are:\");\r\n foreach (var friend in nearestFriends)\r\n {\r\n Console.WriteLine($\"Name: {friend.Name}.\");\r\n }\r\n }\r\n}\r\n\r\n<\/code><\/pre>\n\r\npublic class MyDbContext : DbContext\r\n{\r\n public DbSet Friends { get; set; }\r\n\r\n protected override void OnConfiguring(DbContextOptionsBuilder options)\r\n {\r\n options.UseSqlServer(\r\n \"Server=(localdb)\\\\mssqllocaldb;Database=SpatialFriends;ConnectRetryCount=0\",\r\n b => b.UseNetTopologySuite());\r\n\r\n }\r\n}\r\n<\/code><\/pre>\n\r\npublic class MyDbContext : DbContext\r\n{\r\n public DbSet Friends { get; set; }\r\n\r\n protected override void OnConfiguring(DbContextOptionsBuilder options)\r\n {\r\n options.UseSqlite(\r\n \"Filename=SpatialFriends.db\",\r\n x => x.UseNetTopologySuite());\r\n }\r\n\r\n protected override void OnModelCreating(ModelBuilder modelBuilder)\r\n {\r\n \/\/ For SQLite, you need to configure reference system on column\r\n modelBuilder\r\n .Entity()\r\n .Property(f => f.Location)\r\n .ForSqliteHasSrid(4326);\r\n }\r\n}\r\n<\/code><\/pre>\n\n
$ brew install libspatialite<\/pre>\n<\/li>\n
$ apt-get install libsqlite3-mod-spatialite<\/pre>\n<\/li>\n<\/ul>\n
\r\npublic class MyDbContext : DbContext\r\n{\r\n public DbSet Friends { get; set; }\r\n\r\n protected override void OnConfiguring(DbContextOptionsBuilder options)\r\n {\r\n options.UseInMemoryDatabase(\"SpatialFriends\");\r\n }\r\n}\r\n<\/code><\/pre>\nCosmos DB provider<\/h3>\n
\n
\n