Erik Ejlskov Jensen edited this page Jan 29, 2017 · 11 revisions

Entity Framework

Entity Framework is Microsoft's recommended data access technology for new applications in .NET.

Entity Framework Core (EF Core) provides a familiar developer experience to previous versions of EF, including LINQ, POCO, Migrations and Code First support. EF Core also enables access to data across relational and non-relational stores. EF Core is much more lightweight than previous versions and is built from the ground up to work great in the cloud (using ASP.NET vNext) on devices (i.e. in universal Windows apps) as well as in traditional .NET scenarios. You can find the latest documentation on EF Core here

SQL Server Compact

Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on desktops. The latest release is SQL Server Compact 4.0 SP1 supporting .NET Framework 4.0 and later. It includes both 32-bit and 64-bit native support. SQL CE targets occasionally connected applications and applications with an embedded database. It is free to download and redistribute. You can use Visual Studio (including the free Community Edition) combined with my free SQL Server Compact Toolbox extension for SQL CE development. In addition I have a SQL Server Compact related blog and a number of open source tools and libraries to help you make the most of SQL Server Compact.