Book Image

Mastering F#

By : Alfonso García-Caro Núñez, Suhaib Fahad
Book Image

Mastering F#

By: Alfonso García-Caro Núñez, Suhaib Fahad

Overview of this book

F# is a multi-paradigm programming language that encompasses object-oriented, imperative, and functional programming language properties. Now adopted in a wide range of application areas and is supported both by industry-leading companies who provide professional tools and by an active open community, F# is rapidly gaining popularity as it emerges in digital music advertising, creating music-focused ads for Spotify, Pandora, Shazam, and anywhere on the web. This book will guide you through the basics and will then help you master F#. The book starts by explaining how to use F# with Visual Studio, file ordering, and the differences between F# and C# in terms of usage. It moves on to explain the functional core of F# such as data types, type declarations, immutability, strong type interference, pattern matching, records, F# data structures, sequence expressions, and lazy evaluation. Next, the book takes you through imperative and asynchronous programming, F# type providers, applications, and testing in F#. Finally, we look into using F# with distributed programming and using F# as a suitable language for data science. In short, this book will help you learn F# for real-world applications and increase your productivity with functional programming.
Table of Contents (16 chapters)

SQL type provider


This section explains how to use the SqlDataConnection (LINQ to SQL) type provider to generate types for the Northwind database. The SQL type provider reads the metadata information from the database and then generates SQL based on LINQ internally. We will walk through this using the SQL type provider in a step-by-step manner.

Preparing the test database

We will prepare the database using the SQL Server Explorer option of Visual Studio. On a server or local machine with SQL Express, we need to run through the following steps:

  1. Use the Northwind.sql script provided in the examples of this book. Alternatively, download the Northwind SQL script file from https://northwinddatabase.codeplex.com/releases/view/71634.
  2. Open SQL Server Explorer in Visual Studio.
  3. Create a new database called Northwind.
  4. Choose New Query… and copy/paste the SQL script from the Northwind.sql file.
  5. Run the SQL script to generate the database.
  6. At the end, we can see a listing similar to the following screenshot...