The entity type provider uses Entity Framework (EF) to work with the database. EF is an object-relational mapping (ORM) tool to model database objects such as SQL tables with .NET-compatible types. In this section, you will learn how to use EF with the F# SQL entity type provider.
Similar to what we saw in the SQL type provider section, we will prepare a NorthwindDB
for testing.
We will use the EF Code First approach to work with the database. EF Code First is a set of conventions that allows us to represent our data models and directly write the code without having to use other tools such as UML. First, we will set up a simple F# script file to explore the SQL entity type provider. Add the following code to start exploring LINQ to Entities:
#r "System.Data.Entity.dll" #r "FSharp.Data.TypeProviders" open System open System.Data open System.Data.EntityClient open Microsoft.FSharp.Data...